查询功能所属的菜单

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 '