| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
