EBS:菜单\功能查询

EBS运维过程中,用户只说当前功能名称,运维人员不知道应该用什么职责

怎么查功能名称对应的职责呢?

第一步:按功能提示 查询 。

SELECT FM.MENU_ID,
       FM.MENU_NAME AS "菜单",
       FM.USER_MENU_NAME AS "用户菜单名", 
       FM.TYPE AS "菜单类型",
       FM.DESCRIPTION AS "菜单说明",
       fme.entry_sequence as "序号",
       fme.prompt AS "提示",
       fme.DESCRIPTION AS "说明",
       --FME.MENU_ID,
       --FME.SUB_MENU_ID, 
       (SELECT FM2.USER_MENU_NAME FROM FND_MENUS_VL FM2
         WHERE FM2.MENU_ID = FME.SUB_MENU_ID AND ROWNUM = 1
        )AS "子菜单" ,
       FME.FUNCTION_ID,
       FFF.USER_FUNCTION_NAME AS "功能",
       FFF.DESCRIPTION AS "功能-说明"
       --,FM.*  
  FROM FND_MENUS_VL FM,  -- 菜单 
       apps.FND_MENU_ENTRIES_VL  fme,  -- 功能提示 
       APPS.FND_FORM_FUNCTIONS_VL FFF  -- 功能 
 where FM.MENU_ID = FME.MENU_ID
  AND FFF.FUNCTION_ID(+) = FME.FUNCTION_ID
  AND fme.prompt like '供应商%' 
ORDER BY FM.MENU_NAME, fme.entry_sequence

  第二步:菜单下所有功能(包括子菜单下的功能),可以理解为菜单总目录

-- 菜单下所有功能(包括子菜单下的功能),可以理解为菜单总目录
SELECT CMF.MENU_ID,
       FM.MENU_NAME AS "菜单",
       FM.USER_MENU_NAME AS "用户菜单名", 
       FM.TYPE AS "菜单类型",
       FM.DESCRIPTION AS "菜单说明",
       FFF.FUNCTION_ID,
       FFF.USER_FUNCTION_NAME AS "功能",
       FFF.DESCRIPTION AS "功能-说明" 
  FROM APPS.FND_MENUS_VL FM,  -- 菜单
       APPLSYS.FND_COMPILED_MENU_FUNCTIONS  CMF,
      -- apps.FND_MENU_ENTRIES_VL  fme,  -- 功能提示 
       APPS.FND_FORM_FUNCTIONS_VL FFF  -- 功能   
 WHERE FM.MENU_ID = CMF.MENU_ID
   AND CMF.FUNCTION_ID = FFF.FUNCTION_ID
  -- AND CMF.MENU_ID = 86669 -- 客户化开发菜单 
   AND FFF.USER_FUNCTION_NAME LIKE '%供应商%' -- --AS "功能",
   

  

posted @ 2023-03-15 11:43  samrv  阅读(137)  评论(0编辑  收藏  举报