VIEW: APPS.AHL_DOCUMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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