[Home] [Help]
View: DOM_DOC_REV_VERSIONS_VL
| Product: | DOM - Document Managment and Collaboration |
|---|
| Description: | View to display document revision versions |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| Name |
| DOCUMENT_ID |
| REVISION_ID |
| VERSION_ID |
| VERSION |
| COMMENTS |
| STATUS_CODE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |