View: AHL_DOCUMENTS_V

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

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
, HZ_SOURCE.PARTY_NUMBER SOURCE_PARTY_NUMBER
, ADB.SUBSCRIBE_AVAIL_FLAG
, ADB.SUBSCRIBE_TO_FLAG
, ADB.DOC_TYPE_CODE
, FND_DOC_TYPE.MEANING DOC_TYPE_DESC
, ADB.DOC_SUB_TYPE_CODE
, FND_DOC_SUB_TYPE.MEANING DOC_SUB_TYPE_DESC
, ADB.OPERATOR_CODE
, HZ_OPERATOR.PARTY_NAME OPERATOR_NAME
, ADB.PRODUCT_TYPE_CODE
, FND_PRODUCT_TYPE.MEANING PRODUCT_TYPE_DESC
, ADB.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_VL ADB
, FND_LOOKUP_VALUES_VL FND_DOC_TYPE
, FND_LOOKUP_VALUES_VL FND_DOC_SUB_TYPE
, FND_LOOKUP_VALUES_VL FND_PRODUCT_TYPE
, HZ_PARTIES HZ_OPERATOR
, HZ_PARTIES HZ_SOURCE
WHERE FND_DOC_TYPE.LOOKUP_CODE = ADB.DOC_TYPE_CODE
AND FND_DOC_TYPE.LOOKUP_TYPE='AHL_DOC_TYPE'
AND FND_DOC_SUB_TYPE.LOOKUP_CODE (+)= ADB.DOC_SUB_TYPE_CODE
AND FND_DOC_SUB_TYPE.LOOKUP_TYPE(+)='AHL_DOC_SUB_TYPE'
AND FND_PRODUCT_TYPE.LOOKUP_CODE (+)= ADB.PRODUCT_TYPE_CODE
AND FND_PRODUCT_TYPE.LOOKUP_TYPE(+)='ITEM_TYPE'
AND HZ_OPERATOR.PARTY_ID (+)= ADB.OPERATOR_CODE
AND HZ_SOURCE.PARTY_ID = ADB.SOURCE_PARTY_ID

Columns