VIEW: APPS.JTM_FND_MENU_ENTRIES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.MENU_ID, B.ENTRY_SEQUENCE, B.SUB_MENU_ID, B.FUNCTION_ID, B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATION_DATE, B.CREATED_BY, T.PROMPT, T.DESCRIPTION, T.LANGUAGE, T.SOURCE_LANG FROM FND_MENU_ENTRIES_TL T , FND_MENU_ENTRIES B , FND_MENUS M , JTM_FND_MENU_ENTRIES_ACC ACC WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE AND B.MENU_ID = M.MENU_ID AND B.MENU_ID = ACC.MENU_ID AND B.ENTRY_SEQUENCE = ACC.ENTRY_SEQUENCE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.MENU_ID
, B.ENTRY_SEQUENCE
, B.SUB_MENU_ID
, B.FUNCTION_ID
, B.GRANT_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, T.PROMPT
, T.DESCRIPTION
, T.LANGUAGE
, T.SOURCE_LANG
FROM FND_MENU_ENTRIES_TL T
, FND_MENU_ENTRIES B
, FND_MENUS M
, JTM_FND_MENU_ENTRIES_ACC ACC
WHERE B.MENU_ID = T.MENU_ID
AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND B.MENU_ID = M.MENU_ID
AND B.MENU_ID = ACC.MENU_ID
AND B.ENTRY_SEQUENCE = ACC.ENTRY_SEQUENCE