VIEW: APPS.BNE_MENUS_VL

Source

View Text - Preformatted

SELECT M.ROWID ROW_ID, M.APPLICATION_ID, M.MENU_CODE, M.OBJECT_VERSION_NUMBER, M.PARENT_APP_ID, M.PARENT_CODE, M.SEQUENCE_NUM, M.INTEGRATOR_APP_ID, M.INTEGRATOR_CODE, M.RESOLVER_CLASS, M.ACCESS_POINT, M.PARAM_LIST_APP_ID, M.PARAM_LIST_CODE, T.USER_NAME, M.CREATED_BY, M.CREATION_DATE, M.LAST_UPDATED_BY, M.LAST_UPDATE_LOGIN, M.LAST_UPDATE_DATE FROM BNE_MENUS_B M, BNE_MENUS_TL T WHERE M.APPLICATION_ID = T.APPLICATION_ID AND M.MENU_CODE = T.MENU_CODE AND T.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT M.ROWID ROW_ID
, M.APPLICATION_ID
, M.MENU_CODE
, M.OBJECT_VERSION_NUMBER
, M.PARENT_APP_ID
, M.PARENT_CODE
, M.SEQUENCE_NUM
, M.INTEGRATOR_APP_ID
, M.INTEGRATOR_CODE
, M.RESOLVER_CLASS
, M.ACCESS_POINT
, M.PARAM_LIST_APP_ID
, M.PARAM_LIST_CODE
, T.USER_NAME
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_LOGIN
, M.LAST_UPDATE_DATE
FROM BNE_MENUS_B M
, BNE_MENUS_TL T
WHERE M.APPLICATION_ID = T.APPLICATION_ID
AND M.MENU_CODE = T.MENU_CODE
AND T.LANGUAGE=USERENV('LANG')