查找报表挂的职责

select frv.RESPONSIBILITY_NAME,

       frg.request_group_name,

       frgu.request_unit_id

  from fnd_request_groups         frg,

       fnd_request_group_units    frgu,

       fnd_responsibility_vl      frv,

       FND_CONCURRENT_PROGRAMS_VL fcr

 where frv.REQUEST_GROUP_ID = frg.request_group_id

   and frg.application_id = frgu.application_id

   and frg.request_group_id = frgu.request_group_id

      -- and frgu.request_unit_id = 39718

   and fcr.CONCURRENT_PROGRAM_ID = frgu.request_unit_id

   and fcr.USER_CONCURRENT_PROGRAM_NAME = 'CUXXXXXXX'