Oracle E-Business Suite: Concurrent Request'in Bağlı Olduğu Sorumluluklar ve Request Group'lar

Concurrent Request'in Bağlı Olduğu Sorumluluklar ve Request Group'lar:

 SELECT fcp.concurrent_program_name "Prog Short Name",  
     fcpt.user_concurrent_program_name "Program Name",  
     fcpt.description "Program desc",  
     frg.request_group_name "Request Group",  
     frg.description "Request group desc",  
     frt.responsibility_name "Responsibility Name",  
     frt.description "Responsibility desc"  
  FROM fnd_responsibility fr,  
     fnd_responsibility_tl frt,  
     fnd_request_groups frg,  
     fnd_request_group_units frgu,  
     fnd_concurrent_programs_tl fcpt,  
     fnd_concurrent_programs fcp  
  WHERE frt.responsibility_id = fr.responsibility_id  
   AND fr.request_group_id = frg.request_group_id  
   AND frg.request_group_id = frgu.request_group_id  
   AND frgu.request_unit_id = fcpt.concurrent_program_id  
   AND fcpt.concurrent_program_id = fcp.concurrent_program_id  
   AND frgu.request_unit_type = 'P'  
   AND fcpt.LANGUAGE = frt.LANGUAGE  
   AND frt.LANGUAGE = 'US'  
   AND fcpt.user_concurrent_program_name = 'Active Users'