oracle ebs 11i > concurrent programs –> request group –> responsibility
--concurrent programs
--request group
--responsibility
SELECT fr.responsibility_key,
fr.responsibility_name,
fcp.concurrent_program_name,
fcp.user_concurrent_program_name,
frgu.request_unit_type,
frg.request_group_name
FROM fnd_responsibility_vl fr,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcp
WHERE 1 = 1
AND fr.request_group_id(+) = frgu.request_group_id
AND frg.application_id(+) = frgu.application_id
AND frg.request_group_id(+) = frgu.request_group_id
AND frgu.request_unit_id(+) = fcp.concurrent_program_id
-- AND FRG.REQUEST_GROUP_NAME(+) LIKE UPPER ('Kol - OM Reports%')
--AND UPPER(fcp.concurrent_program_name) LIKE UPPER('XX_OM_068%')
AND UPPER (fcp.user_concurrent_program_name) LIKE UPPER ('Kolinker - Sales Order Export (EDI)');