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 "功能",
标签:菜单,--,MENU,查询,FM,EBS,FFF,ID From: https://www.cnblogs.com/samrv/p/17217964.html