View: AHL_DOCUMENTS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view is based on AHL_DOCUMENTS_B and AHL_DOCUMENTS_TL tables.
Implementation/DBA Data:	APPS.AHL_DOCUMENTS_VL

View Text

SELECT ADB.ROWID ROW_ID
, ADB.DOCUMENT_ID
, ADB.OBJECT_VERSION_NUMBER
, ADB.LAST_UPDATE_DATE
, ADB.LAST_UPDATED_BY
, ADB.CREATION_DATE
, ADB.CREATED_BY
, ADB.LAST_UPDATE_LOGIN
, ADB.DOCUMENT_NO
, ADB.SOURCE_PARTY_ID
, ADB.SUBSCRIBE_AVAIL_FLAG
, ADB.SUBSCRIBE_TO_FLAG
, ADB.DOC_TYPE_CODE
, ADB.DOC_SUB_TYPE_CODE
, ADB.OPERATOR_CODE
, ADB.PRODUCT_TYPE_CODE
, ADT.DOCUMENT_TITLE
, ADB.SECURITY_GROUP_ID
, ADB.ATTRIBUTE_CATEGORY
, ADB.ATTRIBUTE1
, ADB.ATTRIBUTE2
, ADB.ATTRIBUTE3
, ADB.ATTRIBUTE4
, ADB.ATTRIBUTE5
, ADB.ATTRIBUTE6
, ADB.ATTRIBUTE7
, ADB.ATTRIBUTE8
, ADB.ATTRIBUTE9
, ADB.ATTRIBUTE10
, ADB.ATTRIBUTE11
, ADB.ATTRIBUTE12
, ADB.ATTRIBUTE13
, ADB.ATTRIBUTE14
, ADB.ATTRIBUTE15
FROM AHL_DOCUMENTS_B ADB
, AHL_DOCUMENTS_TL ADT
WHERE ADB.DOCUMENT_ID = ADT.DOCUMENT_ID
AND ADT.LANGUAGE =USERENV('LANG')

Columns