查看功能所挂在的菜单

--查看功能所挂在的菜单
alter session set nls_language ='AMERICAN';
alter session set nls_language='SIMPLIFIED CHINESE';

SELECT *
FROM FND_MENUS_VL FM,
FND_MENU_ENTRIES_VL  FME,
FND_FORM_FUNCTIONS_VL  FF
WHERE 1=1
AND FM.MENU_ID = FME.MENU_ID
AND FME.FUNCTION_ID= FF.FUNCTION_ID
AND FF.USER_FUNCTION_NAME = &function_name;

posted @ 2018-06-13 17:29  全威儒  阅读(529)  评论(0编辑  收藏  举报