How to Find Request Group associated for a Program
How to Find Request Group associated for a Program
SELECT rg.application_id
“Request Group Application ID”,
rg.request_group_id
“Request Group – Group ID”,
rg.request_group_name,
rg.description,
rgu.unit_application_id,
rgu.request_group_id
“Request Group Unit – Group ID”,
rgu.request_unit_id,
cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
Decode(rgu.request_unit_type, ‘P’, ‘Program’,
‘S’, ‘Set’,
rgu.request_unit_type) “Unit Type”
FROM fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt
WHERE rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND cpt.user_concurrent_program_name = ‘Program Name’;