Identify Concurrent Programs attached to Request Groups
frg.request_group_name
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_request_group_units frgu,
apps.fnd_request_groups frg
WHERE frgu.request_unit_type = ‘P’ –Program
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND frgu.request_group_id = frg.request_group_id
AND upper(fcpt.user_concurrent_program_name) LIKE upper(‘CONCURRENT_PROGRAM_NAME%’);
Leave a Reply
Want to join the discussion?Feel free to contribute!