Oracle EBS 根据功能查询所在的菜单和责任信息

Oracle EBS 根据功能查询所在的菜单和责任信息

ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
 
SELECT LEVEL  
       ,entr.prompt   菜单提示
       ,(SELECT fun.function_name  
                        FROM fnd_form_functions_vl fun  
                       WHERE fun.function_id = entr.FUNCTION_ID
         ) 功能名
       ,menu.menu_name   菜单
       ,menu.user_menu_name   用户菜单  
       ,frv.RESPONSIBILITY_KEY   职责关键字
       ,frv.RESPONSIBILITY_NAME  职责名
       ,frv.RESPONSIBILITY_id
       ,menu.menu_id        
FROM fnd_menus_vl       menu  
    ,fnd_menu_entries_vl entr  
    ,fnd_responsibility_vl frv
WHERE menu.menu_id = entr.menu_id  
AND entr.menu_id = frv.menu_id
START WITH function_id =  
                     (SELECT fun.function_id  
                        FROM fnd_form_functions_vl fun  
                       WHERE fun.function_name = '要查找的功能名')  
CONNECT BY PRIOR entr.menu_id = entr.sub_menu_id;

--刘轶鹤