VIEW: APPS.ICX_SO_PICKING_HDRS_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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