查询功能所属的菜单、查询报表所属的职责

select fffv.function_name,
       fm.menu_name,
       fr.responsibility_key


  from fnd_form_functions_vl fffv,
       
       fnd_menu_entries_vl fmev,
       
       fnd_menus fm,
       
       fnd_responsibility fr


 where fffv.function_id = fmev.function_id
      
   and fmev.menu_id = fm.menu_id
      
   and fmev.menu_id = fr.menu_id(+)
      
   and fffv.function_name LIKE '&function_name'



2.---------------------------查询报表所属的职责
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')


转载：http://www.cnblogs.com/benio/archive/2010/12/31/1923185.html