eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_ITM_SHIPITEMS_V

Source

View Text - Preformatted


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.INVENTORY_ITEM_ID INVENTORY_ITEM_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.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.SOURCE_LINE_NUMBER, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, 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.ATTRIBUTE1 SHIPITEM_ATTRIBUTE1, WDD.ATTRIBUTE2 SHIPITEM_ATTRIBUTE2, WDD.ATTRIBUTE3 SHIPITEM_ATTRIBUTE3, WDD.ATTRIBUTE4 SHIPITEM_ATTRIBUTE4, WDD.ATTRIBUTE_CATEGORY SHIPITEM_ATTRIBUTE_CATEGORY, 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_V 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, TO_NUMBER(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, 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

View Text - HTML Formatted

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.INVENTORY_ITEM_ID INVENTORY_ITEM_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.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.SOURCE_LINE_NUMBER
, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER
, 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.ATTRIBUTE1 SHIPITEM_ATTRIBUTE1
, WDD.ATTRIBUTE2 SHIPITEM_ATTRIBUTE2
, WDD.ATTRIBUTE3 SHIPITEM_ATTRIBUTE3
, WDD.ATTRIBUTE4 SHIPITEM_ATTRIBUTE4
, WDD.ATTRIBUTE_CATEGORY SHIPITEM_ATTRIBUTE_CATEGORY
, 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_V 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
, TO_NUMBER(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
, 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