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';
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';
EXCELLENT, THANK YOU!
ReplyDelete