VIEW: APPS.AHL_DOC_REVISIONS_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, 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, ADRB.ENIGMA_DOC_ID, ADRB.ENIGMA_MODEL_CODE, MODEL.MEANING 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, FND_LOOKUP_VALUES_VL MODEL 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' AND MODEL.LOOKUP_TYPE (+) = 'AHL_ENIGMA_MODEL_CODE' AND MODEL.LOOKUP_CODE (+) = ADRB.ENIGMA_MODEL_CODE

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
, 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
, ADRB.ENIGMA_DOC_ID
, ADRB.ENIGMA_MODEL_CODE
, MODEL.MEANING
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
, FND_LOOKUP_VALUES_VL MODEL
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'
AND MODEL.LOOKUP_TYPE (+) = 'AHL_ENIGMA_MODEL_CODE'
AND MODEL.LOOKUP_CODE (+) = ADRB.ENIGMA_MODEL_CODE