查看菜单&功能
SELECT res.RESPONSIBILITY_NAME 职责名称,
menu.MENU_NAME 菜单编码,
menu.USER_MENU_NAME 菜单名称,
func.FUNCTION_NAME 功能编码,
func.USER_FUNCTION_NAME 菜单名称,
sub_menu.PROMPT
FROM FND_RESPONSIBILITY_VL res,
fnd_menus_vl menu,
FND_MENU_ENTRIES_VL sub_menu,
FND_FORM_FUNCTIONS_VL func
WHERE res.MENU_ID = sub_menu.MENU_ID
AND menu.MENU_ID = sub_menu.MENU_ID
AND sub_menu.FUNCTION_ID = func.FUNCTION_ID
AND res.RESPONSIBILITY_NAME LIKE 'HJSJ%'
AND sub_menu.SUB_MENU_ID IS NULL
AND sub_menu.FUNCTION_ID IS NOT NULL
AND sub_menu.PROMPT IS NOT NULL
UNION ALL
SELECT res.RESPONSIBILITY_NAME,
menu.MENU_NAME,
menu.USER_MENU_NAME,
func.FUNCTION_NAME,
func.USER_FUNCTION_NAME,
sub_menu1.PROMPT
FROM FND_RESPONSIBILITY_VL res,
fnd_menus_vl menu,
FND_MENU_ENTRIES_VL sub_menu,
FND_MENU_ENTRIES_VL sub