View: AHL_DOC_REVISIONS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view is based on AHL_DOC_REVISIONS_B and AHL_DOC_REVISIONS_TL tables.
Implementation/DBA Data:	APPS.AHL_DOC_REVISIONS_VL

View Text

SELECT ADRB.ROWID ROW_ID
, ADRB.DOC_REVISION_ID
, ADRB.OBJECT_VERSION_NUMBER
, ADRB.LAST_UPDATE_DATE
, ADRB.LAST_UPDATED_BY
, ADRB.CREATION_DATE
, ADRB.CREATED_BY
, ADRB.LAST_UPDATE_LOGIN
, ADRB.DOCUMENT_ID
, ADRB.REVISION_NO
, ADRB.APPROVED_BY_PARTY_ID
, ADRB.REVISION_TYPE_CODE
, ADRB.REVISION_STATUS_CODE
, ADRB.REVISION_DATE
, ADRB.APPROVED_DATE
, ADRB.EFFECTIVE_DATE
, ADRB.OBSOLETE_DATE
, ADRB.ISSUE_DATE
, ADRB.RECEIVED_DATE
, ADRB.URL
, ADRB.MEDIA_TYPE_CODE
, ADRB.VOLUME
, ADRB.ISSUE
, ADRB.ISSUE_NUMBER
, ADRT.COMMENTS
, ADRB.SECURITY_GROUP_ID
, ADRB.ATTRIBUTE_CATEGORY
, ADRB.ATTRIBUTE1
, ADRB.ATTRIBUTE2
, ADRB.ATTRIBUTE3
, ADRB.ATTRIBUTE4
, ADRB.ATTRIBUTE5
, ADRB.ATTRIBUTE6
, ADRB.ATTRIBUTE7
, ADRB.ATTRIBUTE8
, ADRB.ATTRIBUTE9
, ADRB.ATTRIBUTE10
, ADRB.ATTRIBUTE11
, ADRB.ATTRIBUTE12
, ADRB.ATTRIBUTE13
, ADRB.ATTRIBUTE14
, ADRB.ATTRIBUTE15
FROM AHL_DOC_REVISIONS_B ADRB
, AHL_DOC_REVISIONS_TL ADRT
WHERE ADRB.DOC_REVISION_ID = ADRT.DOC_REVISION_ID
AND ADRT.LANGUAGE = USERENV('LANG')

Columns