查询报表所属的职责

select fcpt.user_concurrent_program_name,
       
       frg.request_group_name,
       
       fr.responsibility_key

  from fnd_concurrent_programs_tl fcpt,
       
       fnd_request_group_units frgu,
       
       fnd_request_groups frg,
       
       fnd_responsibility fr

 where fcpt.concurrent_program_id = frgu.request_unit_id
      
   and frgu.request_group_id = frg.request_group_id
      
   and frg.request_group_id = fr.request_group_id
      
   and lower(fcpt.user_concurrent_program_name) like lower('&program_name')