VIEW: APPS.AHL_DOC_REV_DETAILS_V

Source

View Text - Preformatted

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, 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, ADRB.ENIGMA_DOC_ID FROM AHL_DOC_REVISIONS_VL ADRB, FND_LOOKUP_VALUES_VL FND_REV_STAT, FND_LOOKUP_VALUES_VL FND_REV_TYPE, FND_LOOKUP_VALUES_VL FND_REV_MED WHERE 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'

View Text - HTML Formatted

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
, 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
, ADRB.ENIGMA_DOC_ID
FROM AHL_DOC_REVISIONS_VL ADRB
, FND_LOOKUP_VALUES_VL FND_REV_STAT
, FND_LOOKUP_VALUES_VL FND_REV_TYPE
, FND_LOOKUP_VALUES_VL FND_REV_MED
WHERE 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'