Protected by Copyscape Web Copyright Protection Software

Search This Blog

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';