Wednesday, 30 May 2012

Query to find REQUEST GROUP


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

No comments:

Post a Comment