[Home] [Help]
View: BNE_MENUS_VL
Product: | BNE - Web Applications Desktop Integrator |
Description: | |
Implementation/DBA Data: |
APPS.BNE_MENUS_VL
|
View Text
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')
Columns
Name |
ROW_ID |
APPLICATION_ID |
MENU_CODE |
OBJECT_VERSION_NUMBER |
PARENT_APP_ID |
PARENT_CODE |
SEQUENCE_NUM |
INTEGRATOR_APP_ID |
INTEGRATOR_CODE |
RESOLVER_CLASS |
ACCESS_POINT |
PARAM_LIST_APP_ID |
PARAM_LIST_CODE |
USER_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |