Oracle SQL to 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;

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.