---List of Concurrent Programs with Request Group and Responsibility Name
SELECT DISTINCT fnrtl.responsibility_name
, frg.request_group_name
, fcpl.user_concurrent_program_name
, fcp.concurrent_program_name
, fapp.application_name
, fl.meaning execution_type
, fe.executable_name
, fe.execution_file_name
FROM apps.fnd_request_groups frg,
apps.fnd_application_tl fapp,
apps.fnd_request_group_units frgu,a
apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl fcpl,
apps.fnd_responsibility fnr,
apps.fnd_responsibility_tl fnrtl,
apps.fnd_executables fe,
apps.fnd_lookups fl
WHERE frg.application_id = fapp.application_id
AND frg.application_id = frgu.application_id
AND frg.request_group_id = frgu.request_group_id
AND frg.request_group_id = fnr.request_group_id
AND fnr.responsibility_id = fnrtl.responsibility_id
AND frgu.request_unit_id = fcp.concurrent_program_id
AND frgu.unit_application_id = fcp.application_id
AND fcp.concurrent_program_id = fcpl.concurrent_program_id
--AND fcpl.user_concurrent_program_name LIKE '<concurrent program name>'
AND frg.application_short_code in('XX')
AND fe.executable_id = fcp.executable_id
AND fcp.execution_method_code = fe.execution_method_code
AND fl.lookup_code = fe.execution_method_code
AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fnrtl.LANGUAGE = 'US'
AND fapp.LANGUAGE = 'US'
ORDER BY 3;