SELECT --rg.application_id, --rg.request_group_id, --unit_application_id, --request_unit_id, --request_unit_type, request_group_name, --rg.description rg_desc, cp.concurrent_program_name, cpt.user_concurrent_program_name, --cpt.description ccp_desc, fr.responsibility_key, frt.responsibility_name FROM fnd_request_group_units rgu, fnd_request_groups rg, fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpt, fnd_responsibility fr, fnd_responsibility_tl frt WHERE 1 = 1 AND 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 rg.request_group_id = fr.request_group_id AND frt.responsibility_id = fr.responsibility_id --and upper(rg.request_group_name) like upper(:REQ_GRP_NAME) --and upper(cpt.user_concurrent_program_name) like upper(:CCP_FULL_NAME) AND cp.concurrent_program_name LIKE '%XX_OM_056%' ORDER BY fr.responsibility_key
![image image](https://images.cnblogs.com/cnblogs_com/quanweiru/201212/2012120417110517.png)