Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | Documents Revision View |
Implementation/DBA Data: | APPS.AHL_DOC_REVISIONS_V |
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
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, ADRB.REVISION_TYPE_CODE
, FND_REV_TYPE.MEANING
, DECODE ( ADRB.REVISION_STATUS_CODE
, 'OBSOLETE'
, ADRB.REVISION_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(ADRB.OBSOLETE_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, ADRB.REVISION_STATUS_CODE
, 'OBSOLETE') ) REVISION_STATUS_CODE
, FND_REV_STAT.MEANING
, ADRB.REVISION_DATE
, ADRB.APPROVED_DATE
, ADRB.EFFECTIVE_DATE
, ADRB.OBSOLETE_DATE
, ADRB.ISSUE_DATE
, ADRB.RECEIVED_DATE
, ADRB.URL
, ADRB.MEDIA_TYPE_CODE
, FND_REV_MED.MEANING
, ADRB.VOLUME
, ADRB.ISSUE
, ADRB.ISSUE_NUMBER
, ADRB.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_VL ADRB
, AHL_HZ_PER_EMPLOYEES_V HZ
, FND_LOOKUP_VALUES_VL FND_REV_STAT
, FND_LOOKUP_VALUES_VL FND_REV_TYPE
, FND_LOOKUP_VALUES_VL FND_REV_MED
WHERE HZ.PARTY_ID (+) = ADRB.APPROVED_BY_PARTY_ID
AND FND_REV_STAT.LOOKUP_CODE(+) = DECODE ( ADRB.REVISION_STATUS_CODE
, 'OBSOLETE'
, ADRB.REVISION_STATUS_CODE
, DECODE ( SIGN(TRUNC(NVL(ADRB.OBSOLETE_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, ADRB.REVISION_STATUS_CODE
, 'OBSOLETE' ))
AND FND_REV_STAT.LOOKUP_TYPE(+)='AHL_REVISION_STATUS_TYPE'
AND FND_REV_TYPE.LOOKUP_CODE(+)=ADRB.REVISION_TYPE_CODE
AND FND_REV_TYPE.LOOKUP_TYPE(+)='AHL_REVISION_TYPE'
AND FND_REV_MED.LOOKUP_CODE(+)=ADRB.MEDIA_TYPE_CODE
AND FND_REV_MED.LOOKUP_TYPE(+)='AHL_MEDIA_TYPE'