View: DOM_DOC_REV_VERSIONS_VL

Product:	DOM - Document Managment and Collaboration
Description:	View to display document revision versions
Implementation/DBA Data:	APPS.DOM_DOC_REV_VERSIONS_VL

View Text

SELECT B.DOCUMENT_ID
, B.REVISION_ID
, B.VERSION_ID
, B.VERSION
, T.COMMENTS
, B.STATUS_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM DOM_DOC_REV_VERSIONS B
, DOM_DOC_REV_VERSIONS_TL T
WHERE B.DOCUMENT_ID = T.DOCUMENT_ID
AND B.REVISION_ID = T.REVISION_ID
AND B.VERSION_ID = T.VERSION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns