| How to capture Application id --- in the report [message #140133] |
Sat, 01 October 2005 04:03  |
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
|
|
|
|
| Re: How to capture Application id --- in the report [message #145924 is a reply to message #140133] |
Mon, 07 November 2005 13:30  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
check out the fnd_global package.
I did not see one for APPLICATION_ID in this package, but other global info should be accessible (application name, short name, form id, session id, things of that nature).
If you have TOAD, just type in FND_GLOBAL.
and let the package contents come up and you will see the list available to call in that package.
HTH,
STeve
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
