Product: | ICX - Oracle iProcurement |
---|---|
Description: | Order Entry Picking Lines View |
Implementation/DBA Data: | Not implemented in this database |
SELECT SPH.PICKING_HEADER_ID
, SPH.BATCH_ID
, SPH.ORDER_HEADER_ID
, SPH.STATUS_CODE
, SPH.PICK_SLIP_NUMBER
, SPH.WAYBILL_NUM
, SPH.PICKED_BY_ID
, SPH.PACKED_BY_ID
, SPH.WEIGHT
, SPH.WEIGHT_UNIT_CODE
, SPH.NUMBER_OF_BOXES
, SPH.SHIP_METHOD_CODE
, SPH.DATE_RELEASED
, SPH.DATE_SHIPPED
, SPH.DATE_CONFIRMED
, SPH.EXPECTED_ARRIVAL_DATE
, SPL.PICKING_LINE_ID
, SPL.SEQUENCE_NUMBER
, SPL.ORDER_LINE_ID
, SPL.COMPONENT_CODE
, SPL.LINE_DETAIL_ID
, SPL.COMPONENT_RATIO
, SPL.REQUESTED_QUANTITY
, SPL.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SPL.INCLUDED_ITEM_FLAG
, SPL.DATE_REQUESTED
, SPL.ORIGINAL_REQUESTED_QUANTITY
, SPL.WAREHOUSE_ID
, SPL.SHIPPED_QUANTITY
, SPL.CANCELLED_QUANTITY
, SPL.SHIP_TO_SITE_USE_ID
, SPL.SHIP_TO_CONTACT_ID
, SPL.SHIPMENT_PRIORITY_CODE
, SPL.RA_INTERFACE_STATUS
, SPL.INVOICED_QUANTITY
, SPL.INVENTORY_STATUS
, SPL.UNIT_CODE
, MSI.PRIMARY_UOM_CODE
, SPL.SCHEDULE_DATE
, SPL.DEMAND_CLASS_CODE
, SPL.CONFIGURATION_ITEM_FLAG
, SPL.LATEST_ACCEPTABLE_DATE
, SPL.MOVEMENT_ID
, MSI.ATTRIBUTE14 ITEM_URL
, FRT.ATTRIBUTE14 SHIP_METHOD_URL
FROM ORG_FREIGHT FRT
, MTL_SYSTEM_ITEMS MSI
, SO_PICKING_LINES_ALL SPL
, SO_PICKING_HEADERS_ALL SPH
WHERE MSI.INVENTORY_ITEM_ID(+) = SPL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = NVL(SPL.WAREHOUSE_ID
, SPH.WAREHOUSE_ID)
AND SPH.PICKING_HEADER_ID = SPL.PICKING_HEADER_ID
AND MSI.ORGANIZATION_ID = FRT.ORGANIZATION_ID
AND FRT.FREIGHT_CODE = SPH.SHIP_METHOD_CODE