OraFAQ Forum: Reports & Discoverer » How to capture Application id --- in the report

Home » Developer & Programmer » Reports & Discoverer » How to capture Application id --- in the report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to capture Application id --- in the report [message #140132]

Sat, 01 October 2005 04:00

gopal_488
Messages: 3
Registered: October 2005

Junior Member

Hi guys,
i am developing a report, i need to capture current applicationd_id in the query for a place holder column.

please let me know how could i pass the application id

for the below query to get period_names sequentially

select rownum b, period_name,period_year,period_num
from GL_PERIOD_STATUSES_V
where application_id = "---"
set_of_books_id=:sob 107
ORDER BY period_year desc , period_num desc;

.

rgds,
venu

Report message to a moderator

Previous Topic:	Oracle Report from Report Builder to JasperReport in java
Next Topic:	How to draw thick rectangle in Oracle Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:47:02 CST 2024