Introduction
This Post illustrates the steps required to get the Menu and Submenu list against a responsibility in Oracle EBS R12.
Script t0 get the Menu and Submenu list against a responsibility
SELECT FRV.responsibility_name,
fm.menu_name,
FMEV.ENTRY_SEQUENCE,
FMEV.PROMPT,
FMEV.DESCRIPTION,
SUB_MENU_FMEV.USER_MENU_NAME SUB_MENU_NAME,
SUB_MENU_FMEV.DESCRIPTION SUB_MENU_DESCRIPTION,
FFFT.USER_FUNCTION_NAME,
FMEV.GRANT_FLAG
FROM apps.FND_MENU_ENTRIES_VL FMEV,
apps.FND_MENUS_TL SUB_MENU_FMEV,
APPS.FND_FORM_FUNCTIONS_TL FFFT,
apps.FND_RESPONSIBILITY_VL FRV,
apps.fnd_menus fm
WHERE FRV.MENU_ID = fm.menu_id
AND fm.menu_id = FMEV.menu_id
AND SUB_MENU_FMEV.MENU_ID(+) = FMEV.SUB_menu_id
AND SUB_MENU_FMEV.LANGUAGE(+) = ‘US’
AND FFFT.FUNCTION_ID(+) = FMEV.FUNCTION_ID
AND FFFT.LANGUAGE(+) = ‘US’
–AND FRV.responsibility_name = ‘AP Suppliers Inquiry (TTK)’
ORDER BY FMEV.entry_sequence;
Queries
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
