Query too get the concurrent program name and module name [message #582076] |
Fri, 12 April 2013 23:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/30e94ee65e61afb5853bf8aa6028a0f9?s=64&d=mm&r=g) |
bhawnakaamra
Messages: 66 Registered: March 2013 Location: delhi
|
Member |
|
|
Hello Friends.
I am in dillema of getting the module short name and the program name and some other things.
I have a query
SELECT UNIQUE appl.application_name,
prog.user_concurrent_program_name,
f.application_short_name,
prog.concurrent_program_name,
e.executable_name
FROM fnd_executables e,
fnd_application f,
fnd_application_tl appl,
fnd_concurrent_programs_vl prog,
fnd_request_groups frg,
fnd_request_group_units frgu
WHERE prog.application_id = appl.application_id
AND f.application_id = appl.application_id
AND e.executable_id = prog.executable_id
AND prog.enabled_flag = 'Y'
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = PROG.concurrent_program_id
--and f.application_short_name like '%AR%'
AND prog.user_concurrent_program_name LIKE 'STL%'
-- Replace with your Concurrent Program Name
ORDER BY prog.user_concurrent_program_name
and i am not getting the right module name like if there is oracle payables then i should have AP in module name.
Its urgent guys please help me out
[Updated on: Fri, 12 April 2013 23:21] Report message to a moderator
|
|
|
|