VIEW: APPS.AHL_PC_HEADER_DETAILS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)