如何通过SQL查询某个报表挂载的Responsibility

有的时候我们会遇到一些需求，用户要求我们新增一个报表，然后当你问用户需要挂到哪些responsibility的时候，用户会说跟某某报表一样，这个时候，你就会需要一条sql去DB中查询原先的报表哪些权限可以执行了。详细SQL如下所示：

   1:  SELECT   responsibility_name,
   2:           frg.request_group_name,
   3:           FCPV.CONCURRENT_PROGRAM_NAME,
   4:           fcpv.user_concurrent_program_name,
   5:           fcpv.description
   6:  FROM     fnd_request_groups frg,
   7:           fnd_request_group_units frgu,
   8:           fnd_concurrent_programs_vl fcpv,
   9:           fnd_responsibility_vl frv
  10:  WHERE    frgu.request_unit_type = 'P'
  11:  AND      frgu.request_group_id = frg.request_group_id
  12:  AND      frgu.request_unit_id = fcpv.concurrent_program_id
  13:  AND      frv.request_group_id(+) = frg.request_group_id
  14:  AND      fcpv.user_concurrent_program_name =
  15:              ('Sales Margin Report 可轉為Excel格式 XXOM0050R')
  16:  ORDER BY responsibility_name