Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Showing posts with label FINDING REQUEST GROUP. Show all posts
Showing posts with label FINDING REQUEST GROUP. Show all posts

Monday, May 27, 2013

How to Find REQUEST GROUP?

This query display the Request Group Name with help of Executable name in oracle applications.

SELECT frg.request_group_name,
        fa.application_short_name,
       fe.execution_file_name,
       fe.executable_name
  FROM fnd_request_groups frg,
       fnd_request_group_units frgu,
       fnd_concurrent_programs fcp,
       fnd_executables fe,
       fnd_application fa
 WHERE    FRG.application_id = fa.application_id
       AND frgu.request_group_id = frg.request_group_id
       AND fe.executable_id = fcp.executable_id
       AND frgu.request_unit_id = fcp.concurrent_program_id
       AND fe.executable_name = 'XX_PC_PURCHASE';