[Home] [Help]
View: BNE_CONTENTS_VL
Product: | BNE - Web Applications Desktop Integrator |
Description: | BNE_CONTENTS_VL is a standard translation view over the BNE_CONTENTS entity. |
Implementation/DBA Data: |
APPS.BNE_CONTENTS_VL
|
View Text
SELECT C.ROWID ROW_ID
, C.APPLICATION_ID
, C.CONTENT_CODE
, C.OBJECT_VERSION_NUMBER
, C.INTEGRATOR_APP_ID
, C.INTEGRATOR_CODE
, C.PARAM_LIST_APP_ID
, C.PARAM_LIST_CODE
, C.CONTENT_CLASS
, T.USER_NAME
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.LAST_UPDATE_DATE
, C.ONCE_ONLY_DOWNLOAD_FLAG
FROM BNE_CONTENTS_B C
, BNE_CONTENTS_TL T
WHERE C.APPLICATION_ID = T.APPLICATION_ID
AND C.CONTENT_CODE = T.CONTENT_CODE
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
APPLICATION_ID |
CONTENT_CODE |
OBJECT_VERSION_NUMBER |
INTEGRATOR_APP_ID |
INTEGRATOR_CODE |
PARAM_LIST_APP_ID |
PARAM_LIST_CODE |
CONTENT_CLASS |
USER_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
ONCE_ONLY_DOWNLOAD_FLAG |