EBS:菜单\功能查询

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

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

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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

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

　　第二步：菜单下所有功能（包括子菜单下的功能），可以理解为菜单总目录

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-- 菜单下所有功能（包括子菜单下的功能），可以理解为菜单总目录 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 "功能",