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 "功能",
优质生活从拆开始
浙公网安备 33010602011771号