FND Design Data [Home] [Help]

View: WSH_ITM_SHIPITEMS_V

Product: WSH - Shipping Execution
Description: Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
Implementation/DBA Data: ViewAPPS.WSH_ITM_SHIPITEMS_V
View Text

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, WDD.REQUESTED_QUANTITY REQUESTED_QTY
, WDD.REQUESTED_QUANTITY_UOM REQUESTED_QTY_UOM
, WDD.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, MCSV1.CATEGORY_SET_NAME FREIGHT_CLASS_CAT
, PHCV.HAZARD_CLASS HAZARD_CLASS
, 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.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.ATTRIBUTE_CATEGORY SHIPITEM_ATTRIBUTE_CATEGORY
, WDD.ATTRIBUTE1 SHIPITEM_ATTRIBUTE1
, WDD.ATTRIBUTE2 SHIPITEM_ATTRIBUTE2
, WDD.ATTRIBUTE3 SHIPITEM_ATTRIBUTE3
, WDD.ATTRIBUTE4 SHIPITEM_ATTRIBUTE4
, WDD.ATTRIBUTE5 SHIPITEM_ATTRIBUTE5
, WDD.ATTRIBUTE6 SHIPITEM_ATTRIBUTE6
, WDD.ATTRIBUTE7 SHIPITEM_ATTRIBUTE7
, WDD.ATTRIBUTE8 SHIPITEM_ATTRIBUTE8
, WDD.ATTRIBUTE9 SHIPITEM_ATTRIBUTE9
, WDD.ATTRIBUTE10 SHIPITEM_ATTRIBUTE10
, WDD.ATTRIBUTE11 SHIPITEM_ATTRIBUTE11
, WDD.ATTRIBUTE12 SHIPITEM_ATTRIBUTE12
, WDD.ATTRIBUTE13 SHIPITEM_ATTRIBUTE13
, WDD.ATTRIBUTE14 SHIPITEM_ATTRIBUTE14
, WDD.ATTRIBUTE15 SHIPITEM_ATTRIBUTE15
, 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 (+) UNION SELECT NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, -999
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, WND.DELIVERY_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM WSH_NEW_DELIVERIES WND

Columns

Name
ITEM_NUMBER
REQUESTED_QTY
REQUESTED_QTY_UOM
COUNTRY_OF_ORIGIN
FREIGHT_CLASS_CAT
HAZARD_CLASS
ITEM_DESCRIPTION
REVISION
CUSTOMER_ITEM_NUMBER
PACKING_INSTRUCTIONS
OWNERSHIP_CODE
PARTIAL_SHIPMENT
BACKORDERED_QTY
ORDERED_QTY
ORDERED_QTY_UOM
SHIPPED_QTY
VOLUME
VOLUME_UOM_CODE
NET_WEIGHT
WEIGHT_UOM_CODE
SHIP_NOTES
DELIVERY_DETAIL_ID
SOURCE_LINE_ID
PARENT_DELIVERY_DETAIL_ID
DELIVERY_ID
TOLERANCE_BELOW
TOLERANCE_ABOVE
LOAD_SEQUENCE_NUMBER
SHIP_SET_ID
SUBINVENTORY
TOP_MODEL_LINE_ID
SHIP_MODEL_COMPLETE_FLAG
DELIVER_TO_LOCATION_ID
ORG_ID
CUSTOMER_ID
COMMODITY_CODE_CAT
SHIPMENT_PRIORITY_CODE
LOT_NUMBER
SUBLOT_NUMBER
FROM_SERIAL_NUMBER
TO_SERIAL_NUMBER
PREFERRED_GRADE
SHIPITEM_ATTRIBUTE1
SHIPITEM_ATTRIBUTE2
SHIPITEM_ATTRIBUTE3
SHIPITEM_ATTRIBUTE4
SHIPITEM_ATTRIBUTE_CATEGORY
SHIPITEM_ATTRIBUTE5
SHIPITEM_ATTRIBUTE6
SHIPITEM_ATTRIBUTE7
SHIPITEM_ATTRIBUTE8
SHIPITEM_ATTRIBUTE9
SHIPITEM_ATTRIBUTE10
SHIPITEM_ATTRIBUTE11
SHIPITEM_ATTRIBUTE12
SHIPITEM_ATTRIBUTE13
SHIPITEM_ATTRIBUTE14
SHIPITEM_ATTRIBUTE15
CUST_PO_NUMBER
WSN_ROWID