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