Home » Applications » Oracle Fusion Apps & E-Business Suite » Query too get the concurrent program name and module name (TOAD
Query too get the concurrent program name and module name [message #582076] Fri, 12 April 2013 23:20 Go to next message
Messages: 66
Registered: March 2013
Location: delhi
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, 
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

Re: Query too get the concurrent program name and module name [message #582203 is a reply to message #582076] Mon, 15 April 2013 12:30 Go to previous message
vamsi kasina
Messages: 2098
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
fnd_request_groups frg,
fnd_request_group_units frgu
I'm unable to understand why you always add unnecessary tables in the join to complicate things.
Accounts Payable short name is not AP, but it is SQLAP.
If you want as AP, decode it.

Previous Topic: Personlization In The PROMPT-TEXT
Next Topic: Error: APO-PO-14082 Unable to find a charge account
Goto Forum:

Current Time: Fri Nov 27 00:28:06 CST 2015

Total time taken to generate the page: 0.12379 seconds