VIEW: APPS.AHL_REFERENCE_DOC_V

Source

View Text - Preformatted

SELECT ADS.DOCUMENT_ID, ADS.DOCUMENT_NO, ADT.DOC_TITLE_ASSO_ID, ADT.OBJECT_VERSION_NUMBER, ADT.ASO_OBJECT_ID, ADR.DOC_REVISION_ID, ADR.REVISION_NO, ADS.DOC_TYPE_CODE, DTC.MEANING DOC_TYPE_DESCRIPTION, ADT.ASO_OBJECT_TYPE_CODE, AOB.MEANING ASO_OBJECT_TYPE_DESC, ADS.DOCUMENT_TITLE , ADT.CHAPTER,ADT.SECTION,ADT.SUBJECT,ADT.PAGE,ADT.FIGURE,ADT.NOTE , ADT.USE_LATEST_REV_FLAG,ULR.MEANING USE_LATEST_REV_FLAG_MEANING, ADR.REVISION_STATUS_CODE, FUP.FILE_ID, FUP.FILE_NAME FROM AHL_DOCUMENTS_VL ADS, AHL_DOC_TITLE_ASSOS_VL ADT, AHL_DOC_REVISIONS_B ADR, FND_LOOKUP_VALUES_VL DTC, FND_LOOKUP_VALUES_VL AOB , FND_LOOKUP_VALUES_VL ULR, AHL_DOC_FILE_ASSOC_VL FUP WHERE ADR.DOCUMENT_ID(+) = ADS.DOCUMENT_ID AND ADT.DOC_REVISION_ID(+) = ADR.DOC_REVISION_ID AND DTC.LOOKUP_CODE(+) = ADS.DOC_TYPE_CODE AND DTC.LOOKUP_TYPE(+) = 'AHL_DOC_TYPE' AND AOB.LOOKUP_CODE(+) = ADT.ASO_OBJECT_TYPE_CODE AND AOB.LOOKUP_TYPE(+)= 'AHL_OBJECT_TYPE' AND ULR.LOOKUP_CODE(+) = ADT.USE_LATEST_REV_FLAG AND ULR.LOOKUP_TYPE(+) = 'AHL_USE_LATEST_REV_FLAG' AND ADR.DOC_REVISION_ID = FUP.REVISION_ID(+) AND FUP.DATATYPE_CODE(+) = 'FILE' UNION SELECT ADS.DOCUMENT_ID, ADS.DOCUMENT_NO, ADT.DOC_TITLE_ASSO_ID, ADT.OBJECT_VERSION_NUMBER, ADT.ASO_OBJECT_ID, ADR.DOC_REVISION_ID, ADR.REVISION_NO, ADS.DOC_TYPE_CODE, DTC.MEANING DOC_TYPE_DESCRIPTION, ADT.ASO_OBJECT_TYPE_CODE, AOB.MEANING ASO_OBJECT_TYPE_DESC, ADS.DOCUMENT_TITLE , ADT.CHAPTER,ADT.SECTION,ADT.SUBJECT,ADT.PAGE,ADT.FIGURE,ADT.NOTE, ADT.USE_LATEST_REV_FLAG,ULR.MEANING USE_LATEST_REV_FLAG_MEANING, ADR.REVISION_STATUS_CODE, FUP.FILE_ID, FUP.FILE_NAME FROM AHL_DOC_TITLE_ASSOS_VL ADT, AHL_DOC_REVISIONS_B ADR, AHL_DOCUMENTS_VL ADS, FND_LOOKUP_VALUES_VL DTC, FND_LOOKUP_VALUES_VL AOB,FND_LOOKUP_VALUES_VL ULR, AHL_DOC_FILE_ASSOC_VL FUP WHERE ADS.DOCUMENT_ID = ADT.DOCUMENT_ID(+) AND ADR.DOC_REVISION_ID(+) = ADT.DOC_REVISION_ID AND ADT.DOC_REVISION_ID IS NULL AND DTC.LOOKUP_CODE(+) = ADS.DOC_TYPE_CODE AND DTC.LOOKUP_TYPE(+) = 'AHL_DOC_TYPE' AND AOB.LOOKUP_CODE(+) = ADT.ASO_OBJECT_TYPE_CODE AND AOB.LOOKUP_TYPE(+) = 'AHL_OBJECT_TYPE' AND ULR.LOOKUP_CODE(+) = ADT.USE_LATEST_REV_FLAG AND ULR.LOOKUP_TYPE(+) = 'AHL_USE_LATEST_REV_FLAG' AND ADR.DOC_REVISION_ID = FUP.REVISION_ID(+) AND FUP.DATATYPE_CODE(+) = 'FILE'

View Text - HTML Formatted

SELECT ADS.DOCUMENT_ID
, ADS.DOCUMENT_NO
, ADT.DOC_TITLE_ASSO_ID
, ADT.OBJECT_VERSION_NUMBER
, ADT.ASO_OBJECT_ID
, ADR.DOC_REVISION_ID
, ADR.REVISION_NO
, ADS.DOC_TYPE_CODE
, DTC.MEANING DOC_TYPE_DESCRIPTION
, ADT.ASO_OBJECT_TYPE_CODE
, AOB.MEANING ASO_OBJECT_TYPE_DESC
, ADS.DOCUMENT_TITLE
, ADT.CHAPTER
, ADT.SECTION
, ADT.SUBJECT
, ADT.PAGE
, ADT.FIGURE
, ADT.NOTE
, ADT.USE_LATEST_REV_FLAG
, ULR.MEANING USE_LATEST_REV_FLAG_MEANING
, ADR.REVISION_STATUS_CODE
, FUP.FILE_ID
, FUP.FILE_NAME
FROM AHL_DOCUMENTS_VL ADS
, AHL_DOC_TITLE_ASSOS_VL ADT
, AHL_DOC_REVISIONS_B ADR
, FND_LOOKUP_VALUES_VL DTC
, FND_LOOKUP_VALUES_VL AOB
, FND_LOOKUP_VALUES_VL ULR
, AHL_DOC_FILE_ASSOC_VL FUP
WHERE ADR.DOCUMENT_ID(+) = ADS.DOCUMENT_ID
AND ADT.DOC_REVISION_ID(+) = ADR.DOC_REVISION_ID
AND DTC.LOOKUP_CODE(+) = ADS.DOC_TYPE_CODE
AND DTC.LOOKUP_TYPE(+) = 'AHL_DOC_TYPE'
AND AOB.LOOKUP_CODE(+) = ADT.ASO_OBJECT_TYPE_CODE
AND AOB.LOOKUP_TYPE(+)= 'AHL_OBJECT_TYPE'
AND ULR.LOOKUP_CODE(+) = ADT.USE_LATEST_REV_FLAG
AND ULR.LOOKUP_TYPE(+) = 'AHL_USE_LATEST_REV_FLAG'
AND ADR.DOC_REVISION_ID = FUP.REVISION_ID(+)
AND FUP.DATATYPE_CODE(+) = 'FILE' UNION SELECT ADS.DOCUMENT_ID
, ADS.DOCUMENT_NO
, ADT.DOC_TITLE_ASSO_ID
, ADT.OBJECT_VERSION_NUMBER
, ADT.ASO_OBJECT_ID
, ADR.DOC_REVISION_ID
, ADR.REVISION_NO
, ADS.DOC_TYPE_CODE
, DTC.MEANING DOC_TYPE_DESCRIPTION
, ADT.ASO_OBJECT_TYPE_CODE
, AOB.MEANING ASO_OBJECT_TYPE_DESC
, ADS.DOCUMENT_TITLE
, ADT.CHAPTER
, ADT.SECTION
, ADT.SUBJECT
, ADT.PAGE
, ADT.FIGURE
, ADT.NOTE
, ADT.USE_LATEST_REV_FLAG
, ULR.MEANING USE_LATEST_REV_FLAG_MEANING
, ADR.REVISION_STATUS_CODE
, FUP.FILE_ID
, FUP.FILE_NAME
FROM AHL_DOC_TITLE_ASSOS_VL ADT
, AHL_DOC_REVISIONS_B ADR
, AHL_DOCUMENTS_VL ADS
, FND_LOOKUP_VALUES_VL DTC
, FND_LOOKUP_VALUES_VL AOB
, FND_LOOKUP_VALUES_VL ULR
, AHL_DOC_FILE_ASSOC_VL FUP
WHERE ADS.DOCUMENT_ID = ADT.DOCUMENT_ID(+)
AND ADR.DOC_REVISION_ID(+) = ADT.DOC_REVISION_ID
AND ADT.DOC_REVISION_ID IS NULL
AND DTC.LOOKUP_CODE(+) = ADS.DOC_TYPE_CODE
AND DTC.LOOKUP_TYPE(+) = 'AHL_DOC_TYPE'
AND AOB.LOOKUP_CODE(+) = ADT.ASO_OBJECT_TYPE_CODE
AND AOB.LOOKUP_TYPE(+) = 'AHL_OBJECT_TYPE'
AND ULR.LOOKUP_CODE(+) = ADT.USE_LATEST_REV_FLAG
AND ULR.LOOKUP_TYPE(+) = 'AHL_USE_LATEST_REV_FLAG'
AND ADR.DOC_REVISION_ID = FUP.REVISION_ID(+)
AND FUP.DATATYPE_CODE(+) = 'FILE'