查询功能所属的菜单

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'