Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View Based on PC Header, PC Nodes ,FMP and MR views. |
Implementation/DBA Data: | APPS.AHL_PC_HEADER_DETAILS_V |
SELECT HDR.ROW_ID
, HDR.PC_HEADER_ID
, HDR.OBJECT_VERSION_NUMBER
, HDR.NAME
, HDR.STATUS
, HDR.STATUS_DESC
, HDR.DESCRIPTION
, HDR.PRODUCT_TYPE_CODE
, HDR.PRODUCT_TYPE_DESC
, HDR.PRIMARY_FLAG
, HDR.PRIMARY_FLAG_DESC
, HDR.ASSOCIATION_TYPE_FLAG
, HDR.ASSOCIATION_TYPE_DESC
, HDR.DRAFT_FLAG
, HDR.SECURITY_GROUP_ID
, HDR.LINK_TO_PC_ID
, DOC.DOCUMENT_ID
, DOC.DOCUMENT_NO
, ADR.DOC_REVISION_ID
, ADR.REVISION_NO
, AHS.PC_ASSOCIATION_ID NODE_ID
, AHS.UNIT_ITEM_NAME NODE_NAME
, AHS.ASSOCIATION_TYPE_FLAG NODE_TYPE
, AHS.UNIT_ITEM_ID
, AHS.INVENTORY_ORG_ID
, MR.MR_HEADER_ID
, MR.TITLE MR_NAME
, HDR.ATTRIBUTE_CATEGORY
, HDR.ATTRIBUTE1
, HDR.ATTRIBUTE2
, HDR.ATTRIBUTE3
, HDR.ATTRIBUTE4
, HDR.ATTRIBUTE5
, HDR.ATTRIBUTE6
, HDR.ATTRIBUTE7
, HDR.ATTRIBUTE8
, HDR.ATTRIBUTE9
, HDR.ATTRIBUTE10
, HDR.ATTRIBUTE11
, HDR.ATTRIBUTE12
, HDR.ATTRIBUTE13
, HDR.ATTRIBUTE14
, HDR.ATTRIBUTE15
FROM AHL_PC_HEADERS_V HDR
, AHL_PC_NODES_B AHNO
, AHL_PC_ASSOCIATIONS_V AHS
, AHL_DOCUMENTS_B DOC
, AHL_DOC_TITLE_ASSOS_B ADT
, AHL_DOC_REVISIONS_B ADR
, AHL_MR_PC_NODES_V MR
WHERE HDR.PC_HEADER_ID = AHNO.PC_HEADER_ID (+)
AND AHNO.PC_NODE_ID = AHS.PC_NODE_ID (+)
AND AHNO.PC_NODE_ID = ADT.ASO_OBJECT_ID (+)
AND ADT.ASO_OBJECT_TYPE_CODE (+) = 'PC'
AND ADT.DOCUMENT_ID = DOC.DOCUMENT_ID(+)
AND ADR.DOC_REVISION_ID (+) = ADT.DOC_REVISION_ID
AND AHNO.PC_NODE_ID = MR.PC_NODE_ID (+)