VIEW: APPS.AHL_PC_ASSOCIATIONS_V

Source

View Text - Preformatted

SELECT DISTINCT AHS.ROWID ROW_ID, AHS.PC_ASSOCIATION_ID, AHS.OBJECT_VERSION_NUMBER, AHS.LAST_UPDATE_DATE, AHS.LAST_UPDATED_BY, AHS.CREATION_DATE, AHS.CREATED_BY, AHS.LAST_UPDATE_LOGIN, AHS.PC_NODE_ID, AHS.UNIT_ITEM_ID, DECODE(AHS.ASSOCIATION_TYPE_FLAG,'U',UNIT.NAME,MTL.CONCATENATED_SEGMENTS) UNIT_ITEM_NAME, MTL.DESCRIPTION UNIT_ITEM_DESCRIPTION, AHS.ASSOCIATION_TYPE_FLAG, AHS.LINK_TO_ASSOCIATION_ID, AHS.DRAFT_FLAG, AHS.OPERATION_STATUS_FLAG, AHS.INVENTORY_ORG_ID, DECODE(AHS.ASSOCIATION_TYPE_FLAG,'U',CSI.SERIAL_NUMBER,'') SERIAL_NUMBER, MTL.CONCATENATED_SEGMENTS ITEM_NUMBER, MTL.ITEM_TYPE PRODUCT_TYPE, AHS.SECURITY_GROUP_ID, AHS.ATTRIBUTE_CATEGORY, AHS.ATTRIBUTE1, AHS.ATTRIBUTE2, AHS.ATTRIBUTE3, AHS.ATTRIBUTE4, AHS.ATTRIBUTE5, AHS.ATTRIBUTE6, AHS.ATTRIBUTE7, AHS.ATTRIBUTE8, AHS.ATTRIBUTE9, AHS.ATTRIBUTE10, AHS.ATTRIBUTE11, AHS.ATTRIBUTE12, AHS.ATTRIBUTE13, AHS.ATTRIBUTE14, AHS.ATTRIBUTE15, NODE.PC_HEADER_ID FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT, CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL, AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID AND UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+) AND DECODE(AHS.ASSOCIATION_TYPE_FLAG,'I',AHS.UNIT_ITEM_ID, 'U',CSI.INVENTORY_ITEM_ID) = MTL.INVENTORY_ITEM_ID AND DECODE(AHS.ASSOCIATION_TYPE_FLAG,'I',AHS.INVENTORY_ORG_ID, 'U',CSI.INV_MASTER_ORGANIZATION_ID) = MTL.ORGANIZATION_ID AND DECODE(AHS.ASSOCIATION_TYPE_FLAG,'I',MTL.ITEM_TYPE, 'U',HEADER.PRODUCT_TYPE_CODE) = MTL.ITEM_TYPE

View Text - HTML Formatted

SELECT DISTINCT AHS.ROWID ROW_ID
, AHS.PC_ASSOCIATION_ID
, AHS.OBJECT_VERSION_NUMBER
, AHS.LAST_UPDATE_DATE
, AHS.LAST_UPDATED_BY
, AHS.CREATION_DATE
, AHS.CREATED_BY
, AHS.LAST_UPDATE_LOGIN
, AHS.PC_NODE_ID
, AHS.UNIT_ITEM_ID
, DECODE(AHS.ASSOCIATION_TYPE_FLAG
, 'U'
, UNIT.NAME
, MTL.CONCATENATED_SEGMENTS) UNIT_ITEM_NAME
, MTL.DESCRIPTION UNIT_ITEM_DESCRIPTION
, AHS.ASSOCIATION_TYPE_FLAG
, AHS.LINK_TO_ASSOCIATION_ID
, AHS.DRAFT_FLAG
, AHS.OPERATION_STATUS_FLAG
, AHS.INVENTORY_ORG_ID
, DECODE(AHS.ASSOCIATION_TYPE_FLAG
, 'U'
, CSI.SERIAL_NUMBER
, '') SERIAL_NUMBER
, MTL.CONCATENATED_SEGMENTS ITEM_NUMBER
, MTL.ITEM_TYPE PRODUCT_TYPE
, AHS.SECURITY_GROUP_ID
, AHS.ATTRIBUTE_CATEGORY
, AHS.ATTRIBUTE1
, AHS.ATTRIBUTE2
, AHS.ATTRIBUTE3
, AHS.ATTRIBUTE4
, AHS.ATTRIBUTE5
, AHS.ATTRIBUTE6
, AHS.ATTRIBUTE7
, AHS.ATTRIBUTE8
, AHS.ATTRIBUTE9
, AHS.ATTRIBUTE10
, AHS.ATTRIBUTE11
, AHS.ATTRIBUTE12
, AHS.ATTRIBUTE13
, AHS.ATTRIBUTE14
, AHS.ATTRIBUTE15
, NODE.PC_HEADER_ID
FROM AHL_PC_ASSOCIATIONS AHS
, AHL_UNIT_CONFIG_HEADERS UNIT
, CSI_ITEM_INSTANCES CSI
, MTL_SYSTEM_ITEMS_KFV MTL
, AHL_PC_NODES_B NODE
, AHL_PC_HEADERS_B HEADER
WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID
AND UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
AND DECODE(AHS.ASSOCIATION_TYPE_FLAG
, 'I'
, AHS.UNIT_ITEM_ID
, 'U'
, CSI.INVENTORY_ITEM_ID) = MTL.INVENTORY_ITEM_ID
AND DECODE(AHS.ASSOCIATION_TYPE_FLAG
, 'I'
, AHS.INVENTORY_ORG_ID
, 'U'
, CSI.INV_MASTER_ORGANIZATION_ID) = MTL.ORGANIZATION_ID
AND DECODE(AHS.ASSOCIATION_TYPE_FLAG
, 'I'
, MTL.ITEM_TYPE
, 'U'
, HEADER.PRODUCT_TYPE_CODE) = MTL.ITEM_TYPE