Oracle E-Business Suite: Request Group'lar - Sorumluluklar - Concurrent Program'lar

Bu sorguyla request group'lar, bu request group'ların atandığı sorumluluklar ve bu request groupların atandığı concurrent program'lar descriptionları ile birlikte gösterilir.

 SELECT responsibility_name , frg.request_group_name,  
 fcpv.user_concurrent_program_name, fcpv.description  
 FROM fnd_request_groups frg,  
 fnd_request_group_units frgu,  
 fnd_concurrent_programs_vl fcpv,  
 fnd_responsibility_vl frv  
 WHERE frgu.request_unit_type = 'P'  
 AND frgu.request_group_id = frg.request_group_id  
 AND frgu.request_unit_id = fcpv.concurrent_program_id  
 AND frv.request_group_id = frg.request_group_id  
 --and responsibility_name='Sistem Yöneticisi'  
 ORDER BY responsibility_name;