View: ECE_DSNO_ITEMS_V

View Text

SELECT DISTINCT SPLD.DELIVERY_ID DELIVERY_ID
, DLV.ACTUAL_DEPARTURE_ID DEPARTURE_ID
, SPLD.CONTAINER_ID CONTAINER_ID
, SPL.INVENTORY_ITEM_ID ITEM_ID
, SOL.HEADER_ID ORDER_HEADER_ID
, SPL.ORDER_LINE_ID ORDER_LINE_ID
, SPL.PICKING_HEADER_ID PICKING_HEADER_ID
, SPL.PICKING_LINE_ID PICKING_LINE_ID
, SOL.DEMAND_STREAM_ID DEMAND_STREAM_ID
, SOL.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, SOL.PARENT_LINE_ID PARENT_LINE_ID
, SOL.ATO_LINE_ID ATO_LINE_ID
, SOL.LINK_TO_LINE_ID LINK_TO_LINE_ID
, SOL.ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, SOL.LINE_NUMBER ORDER_LINE_NUMBER
, MCI.CUSTOMER_ITEM_NUMBER CUSTOMER_PART_NUMBER
, MIF.ITEM_NUMBER SUPPLIER_PART_NUMBER
, SPL.DATE_REQUESTED REQUESTED_DATE
, SOL.PROMISE_DATE PROMISE_DATE
, SPL.SHIPPED_QUANTITY SHIPPED_QUANTITY
, SPL.UNIT_CODE ITEM_UOM_CODE_INT
, SOL.CUSTOMER_MODEL_SERIAL_NUMBER CUSTOMER_MODEL_SERIAL_NUMBER
, MCI.COMMODITY_CODE COMMODITY_CODE
, SOL.ITEM_TYPE_CODE ITEM_TYPE_CODE_INT
, MSI.CONTAINER_ITEM_FLAG CONTAINER_ITEM_FLAG
, MSI.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, MSI.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_FLAG
, SOL.ORDERED_QUANTITY ORDERED_QUANTITY
, SOL.CANCELLED_QUANTITY CANCELLED_QUANTITY
, EDPQ.PACKED_QUANTITY PACKED_QUANTITY
, SOL.LIST_PRICE LIST_PRICE
, SOL.SELLING_PRICE SELLING_PRICE
, SPL.CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG
, SOL.OPTION_FLAG OPTION_FLAG
, SOL.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, SPL.INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, SOL.S4 SHIP_ORDER_STATUS_CODE_INT
, SOL.CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, SOL.CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, SOL.CUSTOMER_JOB CUSTOMER_JOB
, SOL.PLANNING_PROD_SEQ_NUMBER PLANNING_PRODUCTION_SEQ_NUMBER
, SPL.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE_INT
, SPL.DATE_CONFIRMED SHIPMENT_CONFIRMED_DATE
, RDL.REQUIREMENT_EXT TRANSACTION_REFERENCE_KEY
, MCI.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESCRIPTION
, SPL.COMPONENT_RATIO COMPONENT_RATIO
, SPL.COMPONENT_CODE COMPONENT_CODE
, 'UN' HAZARDOUS_MATERIAL_CODE_INT
, PHC.HAZARD_CLASS HAZARD_CLASS_INT
, PHC.DESCRIPTION HAZARD_CLASS_DESCRIPTION
, SOL.PRICING_CONTEXT ORDER_LINE_PRICING_CONTEXT
, SOL.PRICING_ATTRIBUTE1 ORDER_LINE_PRICING_ATTRIBUTE1
, SOL.PRICING_ATTRIBUTE2 ORDER_LINE_PRICING_ATTRIBUTE2
, SOL.PRICING_ATTRIBUTE3 ORDER_LINE_PRICING_ATTRIBUTE3
, SOL.PRICING_ATTRIBUTE4 ORDER_LINE_PRICING_ATTRIBUTE4
, SOL.PRICING_ATTRIBUTE5 ORDER_LINE_PRICING_ATTRIBUTE5
, SOL.PRICING_ATTRIBUTE6 ORDER_LINE_PRICING_ATTRIBUTE6
, SOL.PRICING_ATTRIBUTE7 ORDER_LINE_PRICING_ATTRIBUTE7
, SOL.PRICING_ATTRIBUTE8 ORDER_LINE_PRICING_ATTRIBUTE8
, SOL.PRICING_ATTRIBUTE9 ORDER_LINE_PRICING_ATTRIBUTE9
, SOL.PRICING_ATTRIBUTE10 ORDER_LINE_PRICING_ATTRIBUTE10
, SOL.PRICING_ATTRIBUTE11 ORDER_LINE_PRICING_ATTRIBUTE11
, SOL.PRICING_ATTRIBUTE12 ORDER_LINE_PRICING_ATTRIBUTE12
, SOL.PRICING_ATTRIBUTE13 ORDER_LINE_PRICING_ATTRIBUTE13
, SOL.PRICING_ATTRIBUTE14 ORDER_LINE_PRICING_ATTRIBUTE14
, SOL.PRICING_ATTRIBUTE15 ORDER_LINE_PRICING_ATTRIBUTE15
, SOL.CONTEXT ORDER_LINE_CONTEXT
, SOL.ATTRIBUTE1 ORDER_LINE_ATTRIBUTE1
, SOL.ATTRIBUTE2 ORDER_LINE_ATTRIBUTE2
, SOL.ATTRIBUTE3 ORDER_LINE_ATTRIBUTE3
, SOL.ATTRIBUTE4 ORDER_LINE_ATTRIBUTE4
, SOL.ATTRIBUTE5 ORDER_LINE_ATTRIBUTE5
, SOL.ATTRIBUTE6 ORDER_LINE_ATTRIBUTE6
, SOL.ATTRIBUTE7 ORDER_LINE_ATTRIBUTE7
, SOL.ATTRIBUTE8 ORDER_LINE_ATTRIBUTE8
, SOL.ATTRIBUTE9 ORDER_LINE_ATTRIBUTE9
, SOL.ATTRIBUTE10 ORDER_LINE_ATTRIBUTE10
, SOL.ATTRIBUTE11 ORDER_LINE_ATTRIBUTE11
, SOL.ATTRIBUTE12 ORDER_LINE_ATTRIBUTE12
, SOL.ATTRIBUTE13 ORDER_LINE_ATTRIBUTE13
, SOL.ATTRIBUTE14 ORDER_LINE_ATTRIBUTE14
, SOL.ATTRIBUTE15 ORDER_LINE_ATTRIBUTE15
, SLD.CONTEXT ORDER_LINE_DETAILS_CONTEXT
, SLD.ATTRIBUTE1 ORDER_LINE_DETAILS_ATTRIBUTE1
, SLD.ATTRIBUTE2 ORDER_LINE_DETAILS_ATTRIBUTE2
, SLD.ATTRIBUTE3 ORDER_LINE_DETAILS_ATTRIBUTE3
, SLD.ATTRIBUTE4 ORDER_LINE_DETAILS_ATTRIBUTE4
, SLD.ATTRIBUTE5 ORDER_LINE_DETAILS_ATTRIBUTE5
, SLD.ATTRIBUTE6 ORDER_LINE_DETAILS_ATTRIBUTE6
, SLD.ATTRIBUTE7 ORDER_LINE_DETAILS_ATTRIBUTE7
, SLD.ATTRIBUTE8 ORDER_LINE_DETAILS_ATTRIBUTE8
, SLD.ATTRIBUTE9 ORDER_LINE_DETAILS_ATTRIBUTE9
, SLD.ATTRIBUTE10 ORDER_LINE_DETAILS_ATTRIBUTE10
, SLD.ATTRIBUTE11 ORDER_LINE_DETAILS_ATTRIBUTE11
, SLD.ATTRIBUTE12 ORDER_LINE_DETAILS_ATTRIBUTE12
, SLD.ATTRIBUTE13 ORDER_LINE_DETAILS_ATTRIBUTE13
, SLD.ATTRIBUTE14 ORDER_LINE_DETAILS_ATTRIBUTE14
, SLD.ATTRIBUTE15 ORDER_LINE_DETAILS_ATTRIBUTE15
, SLA.GLOBAL_ATTRIBUTE_CATEGORY ORDER_LINE_GLOBAL_CONTEXT
, SLA.GLOBAL_ATTRIBUTE1 ORDER_LINE_GLOBAL_ATTRIBUTE1
, SLA.GLOBAL_ATTRIBUTE2 ORDER_LINE_GLOBAL_ATTRIBUTE2
, SLA.GLOBAL_ATTRIBUTE3 ORDER_LINE_GLOBAL_ATTRIBUTE3
, SLA.GLOBAL_ATTRIBUTE4 ORDER_LINE_GLOBAL_ATTRIBUTE4
, SLA.GLOBAL_ATTRIBUTE5 ORDER_LINE_GLOBAL_ATTRIBUTE5
, SLA.GLOBAL_ATTRIBUTE6 ORDER_LINE_GLOBAL_ATTRIBUTE6
, SLA.GLOBAL_ATTRIBUTE7 ORDER_LINE_GLOBAL_ATTRIBUTE7
, SLA.GLOBAL_ATTRIBUTE8 ORDER_LINE_GLOBAL_ATTRIBUTE8
, SLA.GLOBAL_ATTRIBUTE9 ORDER_LINE_GLOBAL_ATTRIBUTE9
, SLA.GLOBAL_ATTRIBUTE10 ORDER_LINE_GLOBAL_ATTRIBUTE10
, SLA.GLOBAL_ATTRIBUTE11 ORDER_LINE_GLOBAL_ATTRIBUTE11
, SLA.GLOBAL_ATTRIBUTE12 ORDER_LINE_GLOBAL_ATTRIBUTE12
, SLA.GLOBAL_ATTRIBUTE13 ORDER_LINE_GLOBAL_ATTRIBUTE13
, SLA.GLOBAL_ATTRIBUTE14 ORDER_LINE_GLOBAL_ATTRIBUTE14
, SLA.GLOBAL_ATTRIBUTE15 ORDER_LINE_GLOBAL_ATTRIBUTE15
, SLA.GLOBAL_ATTRIBUTE16 ORDER_LINE_GLOBAL_ATTRIBUTE16
, SLA.GLOBAL_ATTRIBUTE17 ORDER_LINE_GLOBAL_ATTRIBUTE17
, SLA.GLOBAL_ATTRIBUTE18 ORDER_LINE_GLOBAL_ATTRIBUTE18
, SLA.GLOBAL_ATTRIBUTE19 ORDER_LINE_GLOBAL_ATTRIBUTE19
, SLA.GLOBAL_ATTRIBUTE20 ORDER_LINE_GLOBAL_ATTRIBUTE20
, SLDA.GLOBAL_ATTRIBUTE_CATEGORY OL_DETAIL_GLOBAL_CONTEXT
, SLDA.GLOBAL_ATTRIBUTE1 OL_DETAIL_GLOBAL_ATTRIBUTE1
, SLDA.GLOBAL_ATTRIBUTE2 OL_DETAIL_GLOBAL_ATTRIBUTE2
, SLDA.GLOBAL_ATTRIBUTE3 OL_DETAIL_GLOBAL_ATTRIBUTE3
, SLDA.GLOBAL_ATTRIBUTE4 OL_DETAIL_GLOBAL_ATTRIBUTE4
, SLDA.GLOBAL_ATTRIBUTE5 OL_DETAIL_GLOBAL_ATTRIBUTE5
, SLDA.GLOBAL_ATTRIBUTE6 OL_DETAIL_GLOBAL_ATTRIBUTE6
, SLDA.GLOBAL_ATTRIBUTE7 OL_DETAIL_GLOBAL_ATTRIBUTE7
, SLDA.GLOBAL_ATTRIBUTE8 OL_DETAIL_GLOBAL_ATTRIBUTE8
, SLDA.GLOBAL_ATTRIBUTE9 OL_DETAIL_GLOBAL_ATTRIBUTE9
, SLDA.GLOBAL_ATTRIBUTE10 OL_DETAIL_GLOBAL_ATTRIBUTE10
, SLDA.GLOBAL_ATTRIBUTE11 OL_DETAIL_GLOBAL_ATTRIBUTE11
, SLDA.GLOBAL_ATTRIBUTE12 OL_DETAIL_GLOBAL_ATTRIBUTE12
, SLDA.GLOBAL_ATTRIBUTE13 OL_DETAIL_GLOBAL_ATTRIBUTE13
, SLDA.GLOBAL_ATTRIBUTE14 OL_DETAIL_GLOBAL_ATTRIBUTE14
, SLDA.GLOBAL_ATTRIBUTE15 OL_DETAIL_GLOBAL_ATTRIBUTE15
, SLDA.GLOBAL_ATTRIBUTE16 OL_DETAIL_GLOBAL_ATTRIBUTE16
, SLDA.GLOBAL_ATTRIBUTE17 OL_DETAIL_GLOBAL_ATTRIBUTE17
, SLDA.GLOBAL_ATTRIBUTE18 OL_DETAIL_GLOBAL_ATTRIBUTE18
, SLDA.GLOBAL_ATTRIBUTE19 OL_DETAIL_GLOBAL_ATTRIBUTE19
, SLDA.GLOBAL_ATTRIBUTE20 OL_DETAIL_GLOBAL_ATTRIBUTE20
, SPL.CONTEXT PICKING_LINE_CONTEXT
, SPL.ATTRIBUTE1 PICKING_LINE_ATTRIBUTE1
, SPL.ATTRIBUTE2 PICKING_LINE_ATTRIBUTE2
, SPL.ATTRIBUTE3 PICKING_LINE_ATTRIBUTE3
, SPL.ATTRIBUTE4 PICKING_LINE_ATTRIBUTE4
, SPL.ATTRIBUTE5 PICKING_LINE_ATTRIBUTE5
, SPL.ATTRIBUTE6 PICKING_LINE_ATTRIBUTE6
, SPL.ATTRIBUTE7 PICKING_LINE_ATTRIBUTE7
, SPL.ATTRIBUTE8 PICKING_LINE_ATTRIBUTE8
, SPL.ATTRIBUTE9 PICKING_LINE_ATTRIBUTE9
, SPL.ATTRIBUTE10 PICKING_LINE_ATTRIBUTE10
, SPL.ATTRIBUTE11 PICKING_LINE_ATTRIBUTE11
, SPL.ATTRIBUTE12 PICKING_LINE_ATTRIBUTE12
, SPL.ATTRIBUTE13 PICKING_LINE_ATTRIBUTE13
, SPL.ATTRIBUTE14 PICKING_LINE_ATTRIBUTE14
, SPL.ATTRIBUTE15 PICKING_LINE_ATTRIBUTE15
, MIF.ATTRIBUTE_CATEGORY LINE_PART_CATEGORY
, MIF.ATTRIBUTE1 LINE_PART_ATTRIBUTE1
, MIF.ATTRIBUTE2 LINE_PART_ATTRIBUTE2
, MIF.ATTRIBUTE3 LINE_PART_ATTRIBUTE3
, MIF.ATTRIBUTE4 LINE_PART_ATTRIBUTE4
, MIF.ATTRIBUTE5 LINE_PART_ATTRIBUTE5
, MIF.ATTRIBUTE6 LINE_PART_ATTRIBUTE6
, MIF.ATTRIBUTE7 LINE_PART_ATTRIBUTE7
, MIF.ATTRIBUTE8 LINE_PART_ATTRIBUTE8
, MIF.ATTRIBUTE9 LINE_PART_ATTRIBUTE9
, MIF.ATTRIBUTE10 LINE_PART_ATTRIBUTE10
, MIF.ATTRIBUTE11 LINE_PART_ATTRIBUTE11
, MIF.ATTRIBUTE12 LINE_PART_ATTRIBUTE12
, MIF.ATTRIBUTE13 LINE_PART_ATTRIBUTE13
, MIF.ATTRIBUTE14 LINE_PART_ATTRIBUTE14
, MIF.ATTRIBUTE15 LINE_PART_ATTRIBUTE15
, SLA.INDUSTRY_CONTEXT OL_INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1 OL_INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2 OL_INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3 OL_INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4 OL_INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5 OL_INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6 OL_INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7 OL_INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8 OL_INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9 OL_INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10 OL_INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11 OL_INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12 OL_INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13 OL_INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14 OL_INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15 OL_INDUSTRY_ATTRIBUTE15
FROM PO_HAZARD_CLASSES PHC
, MTL_SYSTEM_ITEMS MSI
, MTL_CUSTOMER_ITEMS_ALL_V MCI
, MTL_ITEM_FLEXFIELDS MIF
, RLA_DEMAND_LINES_ALL RDL
, SO_LINE_DETAIL_ATTRIBUTES SLDA
, SO_LINE_DETAILS SLD
, SO_LINE_ATTRIBUTES SLA
, SO_LINES_ALL SOL
, WSH_DELIVERIES DLV
, ECE_DSNO_PACKED_QUANTITY_V EDPQ
, SO_PICKING_LINES_ALL SPL
, SO_PICKING_LINE_DETAILS SPLD
WHERE MSI.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+) AND SOL.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID (+) AND DLV.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND SOL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND DLV.ORGANIZATION_ID = MIF.ORGANIZATION_ID AND SOL.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID AND SOL.DEMAND_STREAM_ID = RDL.DEMAND_LINE_ID (+) AND SPL.LINE_DETAIL_ID = SLDA.LINE_DETAIL_ID (+) AND SPL.LINE_DETAIL_ID = SLD.LINE_DETAIL_ID AND SPL.ORDER_LINE_ID = SLA.LINE_ID (+) AND SPL.ORDER_LINE_ID = SOL.LINE_ID AND SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID AND SPLD.DELIVERY_ID = DLV.DELIVERY_ID AND NVL(SPLD.SHIPPED_QUANTITY
, 0) > 0
AND DLV.ACTUAL_DEPARTURE_ID = EDPQ.DEPARTURE_ID AND SPLD.DELIVERY_ID = EDPQ.DELIVERY_ID AND NVL(SPLD.CONTAINER_ID
, 0) = NVL(EDPQ.CONTAINER_ID
, 0) AND SPLD.PICKING_LINE_ID = EDPQ.PICKING_LINE_ID
AND SPL.INVENTORY_ITEM_ID = EDPQ.INVENTORY_ITEM_ID AND SPL.ORDER_LINE_ID = EDPQ.ORDER_LINE_ID UNION ALL SELECT SPLD.DELIVERY_ID DELIVERY_ID
, DLV.ACTUAL_DEPARTURE_ID DEPARTURE_ID
, SPLD.CONTAINER_ID CONTAINER_ID
, SPL.INVENTORY_ITEM_ID ITEM_ID
, SOLA.HEADER_ID ORDER_HEADER_ID
, SPL.ORDER_LINE_ID ORDER_LINE_ID
, SPL.PICKING_HEADER_ID PICKING_HEADER_ID
, SPL.PICKING_LINE_ID PICKING_LINE_ID
, SOLA.DEMAND_STREAM_ID DEMAND_STREAM_ID
, SOLA.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, SOLA.PARENT_LINE_ID PARENT_LINE_ID
, SOLA.ATO_LINE_ID ATO_LINE_ID
, SOLA.LINK_TO_LINE_ID LINK_TO_LINE_ID
, SOLA.ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, SOLA.LINE_NUMBER ORDER_LINE_NUMBER
, MCI.CUSTOMER_ITEM_NUMBER CUSTOMER_PART_NUMBER
, MIF.ITEM_NUMBER SUPPLIER_PART_NUMBER
, SPL.DATE_REQUESTED REQUESTED_DATE
, SOLA.PROMISE_DATE PROMISE_DATE
, (SOLA.ORDERED_QUANTITY - NVL(SOLA.CANCELLED_QUANTITY
, 0)) * (SPLD.SHIPPED_QUANTITY/ (SOL.ORDERED_QUANTITY - NVL(SOL.CANCELLED_QUANTITY
, 0))) SHIPPED_QUANTITY
, SPL.UNIT_CODE ITEM_UOM_CODE_INT
, SOLA.CUSTOMER_MODEL_SERIAL_NUMBER CUSTOMER_MODEL_SERIAL_NUMBER
, MCI.COMMODITY_CODE COMMODITY_CODE
, SOLA.ITEM_TYPE_CODE ITEM_TYPE_CODE_INT
, MSI.CONTAINER_ITEM_FLAG CONTAINER_ITEM_FLAG
, MSI.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, MSI.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_FLAG
, SOLA.ORDERED_QUANTITY ORDERED_QUANTITY
, SOLA.CANCELLED_QUANTITY CANCELLED_QUANTITY
, TO_NUMBER(NVL(NULL
, 0)) PACKED_QUANTITY
, SOLA.LIST_PRICE LIST_PRICE
, SOLA.SELLING_PRICE SELLING_PRICE
, SPL.CONFIGURATION_ITEM_FLAG CONFIGURATION_ITEM_FLAG
, SOLA.OPTION_FLAG OPTION_FLAG
, SOLA.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, SPL.INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, SOLA.S4 SHIP_ORDER_STATUS_CODE_INT
, SOLA.CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, SOLA.CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, SOLA.CUSTOMER_JOB CUSTOMER_JOB
, SOLA.PLANNING_PROD_SEQ_NUMBER PLANNING_PRODUCTION_SEQ_NUMBER
, SPL.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE_INT
, SPL.DATE_CONFIRMED SHIPMENT_CONFIRMED_DATE
, RDL.REQUIREMENT_EXT TRANSACTION_REFERENCE_KEY
, MCI.CUSTOMER_ITEM_DESC CUSTOMER_ITEM_DESCRIPTION
, SPL.COMPONENT_RATIO COMPONENT_RATIO
, SPL.COMPONENT_CODE COMPONENT_CODE
, 'UN' HAZARDOUS_MATERIAL_CODE_INT
, PHC.HAZARD_CLASS HAZARD_CLASS_INT
, PHC.DESCRIPTION HAZARD_CLASS_DESCRIPTION
, SOLA.PRICING_CONTEXT ORDER_LINE_PRICING_CONTEXT
, SOLA.PRICING_ATTRIBUTE1 ORDER_LINE_PRICING_ATTRIBUTE1
, SOLA.PRICING_ATTRIBUTE2 ORDER_LINE_PRICING_ATTRIBUTE2
, SOLA.PRICING_ATTRIBUTE3 ORDER_LINE_PRICING_ATTRIBUTE3
, SOLA.PRICING_ATTRIBUTE4 ORDER_LINE_PRICING_ATTRIBUTE4
, SOLA.PRICING_ATTRIBUTE5 ORDER_LINE_PRICING_ATTRIBUTE5
, SOLA.PRICING_ATTRIBUTE6 ORDER_LINE_PRICING_ATTRIBUTE6
, SOLA.PRICING_ATTRIBUTE7 ORDER_LINE_PRICING_ATTRIBUTE7
, SOLA.PRICING_ATTRIBUTE8 ORDER_LINE_PRICING_ATTRIBUTE8
, SOLA.PRICING_ATTRIBUTE9 ORDER_LINE_PRICING_ATTRIBUTE9
, SOLA.PRICING_ATTRIBUTE10 ORDER_LINE_PRICING_ATTRIBUTE10
, SOLA.PRICING_ATTRIBUTE11 ORDER_LINE_PRICING_ATTRIBUTE11
, SOLA.PRICING_ATTRIBUTE12 ORDER_LINE_PRICING_ATTRIBUTE12
, SOLA.PRICING_ATTRIBUTE13 ORDER_LINE_PRICING_ATTRIBUTE13
, SOLA.PRICING_ATTRIBUTE14 ORDER_LINE_PRICING_ATTRIBUTE14
, SOLA.PRICING_ATTRIBUTE15 ORDER_LINE_PRICING_ATTRIBUTE15
, SOLA.CONTEXT ORDER_LINE_CONTEXT
, SOLA.ATTRIBUTE1 ORDER_LINE_ATTRIBUTE1
, SOLA.ATTRIBUTE2 ORDER_LINE_ATTRIBUTE2
, SOLA.ATTRIBUTE3 ORDER_LINE_ATTRIBUTE3
, SOLA.ATTRIBUTE4 ORDER_LINE_ATTRIBUTE4
, SOLA.ATTRIBUTE5 ORDER_LINE_ATTRIBUTE5
, SOLA.ATTRIBUTE6 ORDER_LINE_ATTRIBUTE6
, SOLA.ATTRIBUTE7 ORDER_LINE_ATTRIBUTE7
, SOLA.ATTRIBUTE8 ORDER_LINE_ATTRIBUTE8
, SOLA.ATTRIBUTE9 ORDER_LINE_ATTRIBUTE9
, SOLA.ATTRIBUTE10 ORDER_LINE_ATTRIBUTE10
, SOLA.ATTRIBUTE11 ORDER_LINE_ATTRIBUTE11
, SOLA.ATTRIBUTE12 ORDER_LINE_ATTRIBUTE12
, SOLA.ATTRIBUTE13 ORDER_LINE_ATTRIBUTE13
, SOLA.ATTRIBUTE14 ORDER_LINE_ATTRIBUTE14
, SOLA.ATTRIBUTE15 ORDER_LINE_ATTRIBUTE15
, SLD.CONTEXT ORDER_LINE_DETAILS_CONTEXT
, SLD.ATTRIBUTE1 ORDER_LINE_DETAILS_ATTRIBUTE1
, SLD.ATTRIBUTE2 ORDER_LINE_DETAILS_ATTRIBUTE2
, SLD.ATTRIBUTE3 ORDER_LINE_DETAILS_ATTRIBUTE3
, SLD.ATTRIBUTE4 ORDER_LINE_DETAILS_ATTRIBUTE4
, SLD.ATTRIBUTE5 ORDER_LINE_DETAILS_ATTRIBUTE5
, SLD.ATTRIBUTE6 ORDER_LINE_DETAILS_ATTRIBUTE6
, SLD.ATTRIBUTE7 ORDER_LINE_DETAILS_ATTRIBUTE7
, SLD.ATTRIBUTE8 ORDER_LINE_DETAILS_ATTRIBUTE8
, SLD.ATTRIBUTE9 ORDER_LINE_DETAILS_ATTRIBUTE9
, SLD.ATTRIBUTE10 ORDER_LINE_DETAILS_ATTRIBUTE10
, SLD.ATTRIBUTE11 ORDER_LINE_DETAILS_ATTRIBUTE11
, SLD.ATTRIBUTE12 ORDER_LINE_DETAILS_ATTRIBUTE12
, SLD.ATTRIBUTE13 ORDER_LINE_DETAILS_ATTRIBUTE13
, SLD.ATTRIBUTE14 ORDER_LINE_DETAILS_ATTRIBUTE14
, SLD.ATTRIBUTE15 ORDER_LINE_DETAILS_ATTRIBUTE15
, SLA.GLOBAL_ATTRIBUTE_CATEGORY ORDER_LINE_GLOBAL_CATEGORY
, SLA.GLOBAL_ATTRIBUTE1 ORDER_LINE_GLOBAL_ATTRIBUTE1
, SLA.GLOBAL_ATTRIBUTE2 ORDER_LINE_GLOBAL_ATTRIBUTE2
, SLA.GLOBAL_ATTRIBUTE3 ORDER_LINE_GLOBAL_ATTRIBUTE3
, SLA.GLOBAL_ATTRIBUTE4 ORDER_LINE_GLOBAL_ATTRIBUTE4
, SLA.GLOBAL_ATTRIBUTE5 ORDER_LINE_GLOBAL_ATTRIBUTE5
, SLA.GLOBAL_ATTRIBUTE6 ORDER_LINE_GLOBAL_ATTRIBUTE6
, SLA.GLOBAL_ATTRIBUTE7 ORDER_LINE_GLOBAL_ATTRIBUTE7
, SLA.GLOBAL_ATTRIBUTE8 ORDER_LINE_GLOBAL_ATTRIBUTE8
, SLA.GLOBAL_ATTRIBUTE9 ORDER_LINE_GLOBAL_ATTRIBUTE9
, SLA.GLOBAL_ATTRIBUTE10 ORDER_LINE_GLOBAL_ATTRIBUTE10
, SLA.GLOBAL_ATTRIBUTE11 ORDER_LINE_GLOBAL_ATTRIBUTE11
, SLA.GLOBAL_ATTRIBUTE12 ORDER_LINE_GLOBAL_ATTRIBUTE12
, SLA.GLOBAL_ATTRIBUTE13 ORDER_LINE_GLOBAL_ATTRIBUTE13
, SLA.GLOBAL_ATTRIBUTE14 ORDER_LINE_GLOBAL_ATTRIBUTE14
, SLA.GLOBAL_ATTRIBUTE15 ORDER_LINE_GLOBAL_ATTRIBUTE15
, SLA.GLOBAL_ATTRIBUTE16 ORDER_LINE_GLOBAL_ATTRIBUTE16
, SLA.GLOBAL_ATTRIBUTE17 ORDER_LINE_GLOBAL_ATTRIBUTE17
, SLA.GLOBAL_ATTRIBUTE18 ORDER_LINE_GLOBAL_ATTRIBUTE18
, SLA.GLOBAL_ATTRIBUTE19 ORDER_LINE_GLOBAL_ATTRIBUTE19
, SLA.GLOBAL_ATTRIBUTE20 ORDER_LINE_GLOBAL_ATTRIBUTE20
, SLDA.GLOBAL_ATTRIBUTE_CATEGORY OL_DETAIL_GLOBAL_CATEGORY
, SLDA.GLOBAL_ATTRIBUTE1 OL_DETAIL_GLOBAL_ATTRIBUTE1
, SLDA.GLOBAL_ATTRIBUTE2 OL_DETAIL_GLOBAL_ATTRIBUTE2
, SLDA.GLOBAL_ATTRIBUTE3 OL_DETAIL_GLOBAL_ATTRIBUTE3
, SLDA.GLOBAL_ATTRIBUTE4 OL_DETAIL_GLOBAL_ATTRIBUTE4
, SLDA.GLOBAL_ATTRIBUTE5 OL_DETAIL_GLOBAL_ATTRIBUTE5
, SLDA.GLOBAL_ATTRIBUTE6 OL_DETAIL_GLOBAL_ATTRIBUTE6
, SLDA.GLOBAL_ATTRIBUTE7 OL_DETAIL_GLOBAL_ATTRIBUTE7
, SLDA.GLOBAL_ATTRIBUTE8 OL_DETAIL_GLOBAL_ATTRIBUTE8
, SLDA.GLOBAL_ATTRIBUTE9 OL_DETAIL_GLOBAL_ATTRIBUTE9
, SLDA.GLOBAL_ATTRIBUTE10 OL_DETAIL_GLOBAL_ATTRIBUTE10
, SLDA.GLOBAL_ATTRIBUTE11 OL_DETAIL_GLOBAL_ATTRIBUTE11
, SLDA.GLOBAL_ATTRIBUTE12 OL_DETAIL_GLOBAL_ATTRIBUTE12
, SLDA.GLOBAL_ATTRIBUTE13 OL_DETAIL_GLOBAL_ATTRIBUTE13
, SLDA.GLOBAL_ATTRIBUTE14 OL_DETAIL_GLOBAL_ATTRIBUTE14
, SLDA.GLOBAL_ATTRIBUTE15 OL_DETAIL_GLOBAL_ATTRIBUTE15
, SLDA.GLOBAL_ATTRIBUTE16 OL_DETAIL_GLOBAL_ATTRIBUTE16
, SLDA.GLOBAL_ATTRIBUTE17 OL_DETAIL_GLOBAL_ATTRIBUTE17
, SLDA.GLOBAL_ATTRIBUTE18 OL_DETAIL_GLOBAL_ATTRIBUTE18
, SLDA.GLOBAL_ATTRIBUTE19 OL_DETAIL_GLOBAL_ATTRIBUTE19
, SLDA.GLOBAL_ATTRIBUTE20 OL_DETAIL_GLOBAL_ATTRIBUTE20
, SPL.CONTEXT PICKING_LINE_CONTEXT
, SPL.ATTRIBUTE1 PICKING_LINE_ATTRIBUTE1
, SPL.ATTRIBUTE2 PICKING_LINE_ATTRIBUTE2
, SPL.ATTRIBUTE3 PICKING_LINE_ATTRIBUTE3
, SPL.ATTRIBUTE4 PICKING_LINE_ATTRIBUTE4
, SPL.ATTRIBUTE5 PICKING_LINE_ATTRIBUTE5
, SPL.ATTRIBUTE6 PICKING_LINE_ATTRIBUTE6
, SPL.ATTRIBUTE7 PICKING_LINE_ATTRIBUTE7
, SPL.ATTRIBUTE8 PICKING_LINE_ATTRIBUTE8
, SPL.ATTRIBUTE9 PICKING_LINE_ATTRIBUTE9
, SPL.ATTRIBUTE10 PICKING_LINE_ATTRIBUTE10
, SPL.ATTRIBUTE11 PICKING_LINE_ATTRIBUTE11
, SPL.ATTRIBUTE12 PICKING_LINE_ATTRIBUTE12
, SPL.ATTRIBUTE13 PICKING_LINE_ATTRIBUTE13
, SPL.ATTRIBUTE14 PICKING_LINE_ATTRIBUTE14
, SPL.ATTRIBUTE15 PICKING_LINE_ATTRIBUTE15
, MIF.ATTRIBUTE_CATEGORY LINE_PART_CATEGORY
, MIF.ATTRIBUTE1 LINE_PART_ATTRIBUTE1
, MIF.ATTRIBUTE2 LINE_PART_ATTRIBUTE2
, MIF.ATTRIBUTE3 LINE_PART_ATTRIBUTE3
, MIF.ATTRIBUTE4 LINE_PART_ATTRIBUTE4
, MIF.ATTRIBUTE5 LINE_PART_ATTRIBUTE5
, MIF.ATTRIBUTE6 LINE_PART_ATTRIBUTE6
, MIF.ATTRIBUTE7 LINE_PART_ATTRIBUTE7
, MIF.ATTRIBUTE8 LINE_PART_ATTRIBUTE8
, MIF.ATTRIBUTE9 LINE_PART_ATTRIBUTE9
, MIF.ATTRIBUTE10 LINE_PART_ATTRIBUTE10
, MIF.ATTRIBUTE11 LINE_PART_ATTRIBUTE11
, MIF.ATTRIBUTE12 LINE_PART_ATTRIBUTE12
, MIF.ATTRIBUTE13 LINE_PART_ATTRIBUTE13
, MIF.ATTRIBUTE14 LINE_PART_ATTRIBUTE14
, MIF.ATTRIBUTE15 LINE_PART_ATTRIBUTE15
, SLA.INDUSTRY_CONTEXT OL_INDUSTRY_CONTEXT
, SLA.INDUSTRY_ATTRIBUTE1 OL_INDUSTRY_ATTRIBUTE1
, SLA.INDUSTRY_ATTRIBUTE2 OL_INDUSTRY_ATTRIBUTE2
, SLA.INDUSTRY_ATTRIBUTE3 OL_INDUSTRY_ATTRIBUTE3
, SLA.INDUSTRY_ATTRIBUTE4 OL_INDUSTRY_ATTRIBUTE4
, SLA.INDUSTRY_ATTRIBUTE5 OL_INDUSTRY_ATTRIBUTE5
, SLA.INDUSTRY_ATTRIBUTE6 OL_INDUSTRY_ATTRIBUTE6
, SLA.INDUSTRY_ATTRIBUTE7 OL_INDUSTRY_ATTRIBUTE7
, SLA.INDUSTRY_ATTRIBUTE8 OL_INDUSTRY_ATTRIBUTE8
, SLA.INDUSTRY_ATTRIBUTE9 OL_INDUSTRY_ATTRIBUTE9
, SLA.INDUSTRY_ATTRIBUTE10 OL_INDUSTRY_ATTRIBUTE10
, SLA.INDUSTRY_ATTRIBUTE11 OL_INDUSTRY_ATTRIBUTE11
, SLA.INDUSTRY_ATTRIBUTE12 OL_INDUSTRY_ATTRIBUTE12
, SLA.INDUSTRY_ATTRIBUTE13 OL_INDUSTRY_ATTRIBUTE13
, SLA.INDUSTRY_ATTRIBUTE14 OL_INDUSTRY_ATTRIBUTE14
, SLA.INDUSTRY_ATTRIBUTE15 OL_INDUSTRY_ATTRIBUTE15
FROM PO_HAZARD_CLASSES PHC
, MTL_SYSTEM_ITEMS MSI
, MTL_CUSTOMER_ITEMS_ALL_V MCI
, MTL_ITEM_FLEXFIELDS MIF
, RLA_DEMAND_LINES_ALL RDL
, SO_LINE_DETAIL_ATTRIBUTES SLDA
, SO_LINE_DETAILS SLD
, SO_LINE_ATTRIBUTES SLA
, SO_LINES_ALL SOL
, SO_LINES_ALL SOLA
, SO_PICKING_LINE_DETAILS SPLD
, SO_PICKING_LINES_ALL SPL
, WSH_DELIVERIES DLV
WHERE MSI.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+) AND SOLA.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID (+) AND DLV.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND SOLA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND DLV.ORGANIZATION_ID = MIF.ORGANIZATION_ID AND SOLA.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID AND SOLA.DEMAND_STREAM_ID = RDL.DEMAND_LINE_ID (+) AND SPL.LINE_DETAIL_ID = SLDA.LINE_DETAIL_ID (+) AND SPL.LINE_DETAIL_ID = SLD.LINE_DETAIL_ID AND SPL.ORDER_LINE_ID = SLA.LINE_ID (+) AND SPL.ORDER_LINE_ID = SOL.LINE_ID AND SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID AND SPLD.DELIVERY_ID = DLV.DELIVERY_ID AND NVL(SOLA.SHIPPED_QUANTITY
, 0) > 0
AND SOLA.ATO_LINE_ID = SOL.LINE_ID AND SOLA.ITEM_TYPE_CODE IN ('MODEL'
, 'STANDARD')

Columns