[Home] [Help]
View: BNE_CONTENT_COLS_VL
Product: | BNE - Web Applications Desktop Integrator |
Description: | BNE_CONTENT_COLS_VL is a standard translation view over the BNE_CONTENT_COLS entity. |
Implementation/DBA Data: |
APPS.BNE_CONTENT_COLS_VL
|
View Text
SELECT C.ROWID ROW_ID
, C.APPLICATION_ID
, C.CONTENT_CODE
, C.SEQUENCE_NUM
, C.OBJECT_VERSION_NUMBER
, C.COL_NAME
, T.USER_NAME
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.LAST_UPDATE_DATE
, C.READ_ONLY_FLAG
FROM BNE_CONTENT_COLS_B C
, BNE_CONTENT_COLS_TL T WHERE C.APPLICATION_ID = T.APPLICATION_ID
AND C.CONTENT_CODE = T.CONTENT_CODE
AND C.SEQUENCE_NUM = T.SEQUENCE_NUM AND T.LANGUAGE = USERENV ('LANG')
Columns
Name |
ROW_ID |
APPLICATION_ID |
CONTENT_CODE |
SEQUENCE_NUM |
OBJECT_VERSION_NUMBER |
COL_NAME |
USER_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
READ_ONLY_FLAG |