Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | Its a view based on AHL_DOCUMENTS_VL, AHL_DOC_TITLE_ASSOS_VL, AHL_DOC_REVISIONS_B ,FND_LOOKUP_VALUES_VL |
Implementation/DBA Data: | APPS.AHL_DOCUMENT_ASSOS_V |
SELECT ADS.DOCUMENT_ID
, ADS.DOCUMENT_NO
, ADT.DOC_TITLE_ASSO_ID
, ADT.OBJECT_VERSION_NUMBER
, ADT.ASO_OBJECT_ID
, ADT.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.SOURCE_REF_CODE
, SRF.MEANING SOURCE_MEANING
, ADT. CHAPTER
, ADT.SECTION
, ADT.SUBJECT
, ADT.FIGURE
, ADT.PAGE
, ADT.NOTE
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 SRF
WHERE ADS.DOCUMENT_ID = ADR.DOCUMENT_ID(+)
AND ADR.DOC_REVISION_ID = ADT.DOC_REVISION_ID(+)
AND ADT.DOC_REVISION_ID IS NOT 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 SRF.LOOKUP_CODE(+) = ADT.SOURCE_REF_CODE
AND SRF.LOOKUP_TYPE(+) = 'AHL_DI_SOURCE_REF' UNION SELECT ADS.DOCUMENT_ID
, ADS.DOCUMENT_NO
, ADT.DOC_TITLE_ASSO_ID
, ADT.OBJECT_VERSION_NUMBER
, ADT.ASO_OBJECT_ID
, ADT.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.SOURCE_REF_CODE
, SRF.MEANING SOURCE_MEANING
, ADT. CHAPTER
, ADT.SECTION
, ADT.SUBJECT
, ADT.FIGURE
, ADT.PAGE
, ADT.NOTE
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 SRF
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 SRF.LOOKUP_CODE(+) = ADT.SOURCE_REF_CODE
AND AOB.LOOKUP_TYPE(+) = 'AHL_DI_SOURCE_REF'