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

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: 2089
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
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.

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


Current Time: Sat Apr 19 18:28:31 CDT 2014

Total time taken to generate the page: 0.21223 seconds