-- Verify Concurrent Programs
SELECT *
FROM apps.fnd_concurrent_programs_vl
WHERE user_concurrent_program_name = 'XYZ Price Utility Report'
ORDER BY user_concurrent_program_name;
-- Verify Concurrent Program is assigned request set or not
SELECT fcpt.user_concurrent_program_name, fcpt.concurrent_program_id,
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'
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.user_concurrent_program_name LIKE 'abc%';