EBS 系统在安装好后，针对每个应用模块均已经预定义包括所有功能（或权限）所谓的“超级用户菜单”（ Super User Menu ），系统管理员在定义用户“责任”时可利用“排除法”来满足实际的业务管理需要。此外，系统还提供了“仅具查询”功能的预定义菜单，供某些需要限制做业务的用户使用。

Navigation: SYSADMIN -> Application -> Menu

菜单相关SQL

1. 菜单信息

select fm.menu_id,fm.menu_name,fmt.user_menu_name,fme.entry_sequence,fmet.prompt,--------------------------------fme.sub_menu_id,(select fmt.user_menu_name from fnd_menus fm, fnd_menus_tl fmtwhere fm.menu_id = fmt.menu_id and fmt.language = userenv('lang') andfm.menu_id = fme.sub_menu_id) sub_menu_name,--------------------------------fme.function_id,(select ffft.user_function_name from fnd_form_functions fff, fnd_form_functions_tl ffftwhere fff.function_id = ffft.function_id and ffft.language = userenv('lang') andfff.function_id = fme.function_id) function_name,fmet.description,--------------------------------fme.grant_flag
from fnd_menus fm,fnd_menus_tl fmt,fnd_menu_entries fme,fnd_menu_entries_tl fmet
where fm.menu_name = 'PO_SUPERUSER_GUI' andfm.menu_id = fmt.menu_id and fmt.language = userenv('lang') and----------------------fm.menu_id = fme.menu_id andfme.menu_id = fmet.menu_id andfme.entry_sequence = fmet.entry_sequence andfmet.language = userenv('lang')          
order by fme.entry_sequence asc

2. 多级菜单展开

SELECT LPAD(' ', 6*(LEVEL-1)) || menu_entry.entry_sequence sequence 
, LPAD(' ', 6*(LEVEL-1)) || menu.user_menu_name SubMenu_Descrition 
, LPAD(' ', 6*(LEVEL-1)) || func.user_function_name Function_Description 
, menu.menu_id 
, func.function_id 
, menu_entry.grant_flag Grant_Flag 
, DECODE( menu_entry.sub_menu_id 
, null, 'FUNCTION' 
, DECODE( menu_entry.function_id 
, null, 'SUBMENU' 
, 'BOTH') 
) Type 
FROM fnd_menu_entries menu_entry, 
fnd_menus_vl menu, 
fnd_form_functions_vl func 
WHERE menu_entry.sub_menu_id = menu.menu_id(+) 
AND menu_entry.function_id = func.function_id(+) 
AND grant_flag = 'Y' 
START WITH menu_entry.menu_id = (SELECT menu_id 
FROM fnd_menus_tl menu2 
WHERE menu2.user_menu_name = '採購管理系統超級使用者 GUI'
and menu2.language = 'ZHT'
) 
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id 
ORDER SIBLINGS BY menu_entry.entry_sequence

3. 包含某个Function的菜单

select fff.function_id, fff.function_name,ffft.user_function_name,fme.ENTRY_SEQUENCE,fmet.prompt,fm.menu_name,fmt.user_menu_name
from fnd_form_functions fff,fnd_form_functions_tl ffft,fnd_menu_entries fme,fnd_menu_entries_tl fmet,FND_MENUS fm,FND_MENUS_TL fmt
where fff.function_id = ffft.function_id andffft.language = userenv('lang') andffft.user_function_name = &p_user_function_name and  --例:通用收件匣--------------------------------fff.function_id = fme.function_id and fme.menu_id  = fmet.menu_id and fme.entry_sequence = fmet.entry_sequence and fmet.language = userenv('lang') and--------------------------------fme.menu_id = fm.menu_id andfm.menu_id = fmt.menu_id andfmt.language = userenv('lang')