View: DOM_DOCUMENT_REVISIONS_VL

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

View Text

SELECT B.DOCUMENT_ID
, B.REVISION_ID
, B.CATEGORY_ID
, B.REVISION
, B.CHECKOUT_STATUS
, B.CHECKED_OUT_BY
, B.STATUS_CODE
, B.CREATION_REASON
, T.COMMENTS
, B.LIFECYCLE_TRACKING_ID
, B.LIFECYCLE_PHASE_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM DOM_DOCUMENT_REVISIONS B
, DOM_DOCUMENT_REVISIONS_TL T
WHERE B.DOCUMENT_ID = T.DOCUMENT_ID
AND B.REVISION_ID = T.REVISION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns