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; 

  • September 27, 2018 | 19 views
  • Comments