View: CLN_WSH_SS_SHIPITEMS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of delivery line details
Implementation/DBA Data:	APPS.CLN_WSH_SS_SHIPITEMS_V

View Text

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, WDD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDD.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, WDD.REQUESTED_QUANTITY REQUESTED_QTY
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QTY_UOM
, WDD.SRC_REQUESTED_QUANTITY
, WDD.GROSS_WEIGHT
, WDD.CONTAINER_TYPE_CODE
, WDD.CONTAINER_NAME
, WDD.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, MCSV1.CATEGORY_SET_NAME FREIGHT_CLASS_CAT
, PHCV.HAZARD_CLASS HAZARD_CLASS
, PHCV.HAZARD_CLASS_ID HAZARD_CLASS_ID
, WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD.REVISION REVISION
, MCI.CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM_NUMBER
, WDD.PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, WDD.FOB_CODE OWNERSHIP_CODE
, DECODE (WDD.SHIP_SET_ID
, NULL
, 0
, 1) PARTIAL_SHIPMENT
, NVL(WDD.REQUESTED_QUANTITY
, 0) - NVL (WDD.SHIPPED_QUANTITY
, 0) BACKORDERED_QTY
, WDD.SRC_REQUESTED_QUANTITY ORDERED_QTY
, WDD.SRC_REQUESTED_QUANTITY_UOM ORDERED_QTY_UOM
, WDD.SHIPPED_QUANTITY SHIPPED_QTY
, WDD.VOLUME VOLUME
, WDD.VOLUME_UOM_CODE VOLUME_UOM_CODE
, WDD.NET_WEIGHT NET_WEIGHT
, WDD.WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, WDD.GROSS_WEIGHT GROSS_WEIGHT
, WDD.SHIPPING_INSTRUCTIONS SHIP_NOTES
, WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SOURCE_LINE_ID SOURCE_LINE_ID
, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_DELIVERY_DETAIL_ID
, WDA.DELIVERY_ID DELIVERY_ID
, WDD.SHIP_TOLERANCE_BELOW TOLERANCE_BELOW
, WDD.SHIP_TOLERANCE_ABOVE TOLERANCE_ABOVE
, WDD.LOAD_SEQ_NUMBER LOAD_SEQUENCE_NUMBER
, WDD.SHIP_SET_ID SHIP_SET_ID
, WDD.SUBINVENTORY SUBINVENTORY
, WDD.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, WDD.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, WDD.DELIVER_TO_LOCATION_ID
, WDD.ORG_ID
, WDD.CUSTOMER_ID
, MCSV2.CATEGORY_SET_NAME COMMODITY_CODE_CAT
, DECODE (WDD.SHIPMENT_PRIORITY_CODE
, 'STANDARD'
, '01'
, 'NORMAL'
, '02'
, 'HIGH'
, '03') SHIPMENT_PRIORITY_CODE
, WDD.LOT_NUMBER LOT_NUMBER
, WDD.SUBLOT_NUMBER SUBLOT_NUMBER
, NVL(WSN.FM_SERIAL_NUMBER
, WDD.SERIAL_NUMBER) FROM_SERIAL_NUMBER
, NVL(WSN.TO_SERIAL_NUMBER
, WDD.TO_SERIAL_NUMBER) TO_SERIAL_NUMBER
, WDD.PREFERRED_GRADE PREFERRED_GRADE
, WDD.CUST_PO_NUMBER CUST_PO_NUMBER
, ROWIDTOCHAR(WSN.ROWID) WSN_ROWID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_NEW_DELIVERIES WND
, MTL_CUSTOMER_ITEMS MCI
, MTL_SYSTEM_ITEMS_KFV MSIK
, PO_HAZARD_CLASSES_VL PHCV
, MTL_CATEGORY_SETS_VL MCSV1
, MTL_CATEGORY_SETS_VL MCSV2
, WSH_SERIAL_NUMBERS WSN
WHERE WDD.CONTAINER_FLAG = 'N'
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WDD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND WDD.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID (+)
AND WDD.HAZARD_CLASS_ID = PHCV.HAZARD_CLASS_ID (+)
AND WDD.FREIGHT_CLASS_CAT_ID = MCSV1.CATEGORY_SET_ID (+)
AND WDD.COMMODITY_CODE_CAT_ID = MCSV2.CATEGORY_SET_ID (+)
AND WDD.DELIVERY_DETAIL_ID = WSN.DELIVERY_DETAIL_ID (+)

Columns