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.

[Home] [Help]

View: ECE_DSNO_CONTAINERS_V

Product:	EC - e-Commerce Gateway
Description:	No longer used
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT WPC.DELIVERY_ID DELIVERY_ID
, DLV.ACTUAL_DEPARTURE_ID DEPARTURE_ID
, WPC.CONTAINER_ID CONTAINER_ID
, WPC.CONTAINER_INVENTORY_ITEM_ID CONTAINER_ITEM_ID
, NVL(WPC.MASTER_SERIAL_NUMBER
, WPCM.MASTER_SERIAL_NUMBER) MASTER_SERIAL_NUMBER
, WPC.SERIAL_NUMBER CONTAINER_SERIAL_NUMBER
, WPC.LOT_NUMBER LOT_NUMBER
, WPCP.SEQUENCE_NUMBER PARENT_SEQUENCE_NUMBER
, WPC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, WPC.QUANTITY CONTAINER_QUANTITY
, MSI.CONTAINER_TYPE_CODE CONTAINER_TYPE_INT
, WPC.GROSS_WEIGHT CONTAINER_GROSS_WEIGHT
, WPC.WEIGHT_UOM_CODE CONTAINER_GROSS_WEIGHT_UOM_INT
, WPC.ATTRIBUTE_CATEGORY CONTAINER_CATEGORY
, WPC.ATTRIBUTE1 CONTAINER_ATTRIBUTE1
, WPC.ATTRIBUTE2 CONTAINER_ATTRIBUTE2
, WPC.ATTRIBUTE3 CONTAINER_ATTRIBUTE3
, WPC.ATTRIBUTE4 CONTAINER_ATTRIBUTE4
, WPC.ATTRIBUTE5 CONTAINER_ATTRIBUTE5
, WPC.ATTRIBUTE6 CONTAINER_ATTRIBUTE6
, WPC.ATTRIBUTE7 CONTAINER_ATTRIBUTE7
, WPC.ATTRIBUTE8 CONTAINER_ATTRIBUTE8
, WPC.ATTRIBUTE9 CONTAINER_ATTRIBUTE9
, WPC.ATTRIBUTE10 CONTAINER_ATTRIBUTE10
, WPC.ATTRIBUTE11 CONTAINER_ATTRIBUTE11
, WPC.ATTRIBUTE12 CONTAINER_ATTRIBUTE12
, WPC.ATTRIBUTE13 CONTAINER_ATTRIBUTE13
, WPC.ATTRIBUTE14 CONTAINER_ATTRIBUTE14
, WPC.ATTRIBUTE15 CONTAINER_ATTRIBUTE15
, WPC.VOLUME CONTAINER_VOLUME
, WPC.VOLUME_UOM_CODE CONTAINER_VOLUME_UOM_CODE_INT
, WPC.NET_WEIGHT CONTAINER_NET_WEIGHT
, WPC.FILL_PERCENT CONTAINER_FILL_PERCENT
, WPC.PARENT_CONTAINER_ID PARENT_CONTAINER_ID
, WPC.MASTER_CONTAINER_ID MASTER_CONTAINER_ID
, MSI.INTERNAL_VOLUME CONTAINER_MAXIMUM_VOLUME
, MSI.MAXIMUM_LOAD_WEIGHT CONTAINER_MAXIMUM_LOAD_WEIGHT
, MSI.MINIMUM_FILL_PERCENT CONTAINER_MINIMUM_FILL_PERCENT
, WPC.GROSS_WEIGHT - WPC.NET_WEIGHT CONTAINER_TARE_WEIGHT
FROM WSH_PACKED_CONTAINERS WPCP
, WSH_PACKED_CONTAINERS WPCM
, MTL_SYSTEM_ITEMS MSI
, WSH_DELIVERIES DLV
, WSH_PACKED_CONTAINERS WPC
WHERE WPC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WPC.PARENT_CONTAINER_ID = WPCP.CONTAINER_ID (+) AND WPC.PARENT_CONTAINER_ID = WPCM.CONTAINER_ID (+) AND DLV.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND WPC.DELIVERY_ID = DLV.DELIVERY_ID
AND EXISTS (SELECT DELIVERY_ID
FROM SO_PICKING_LINE_DETAILS PLD
WHERE DLV.DELIVERY_ID = PLD.DELIVERY_ID
AND NVL(PLD.SHIPPED_QUANTITY
, 0) > 0)

Columns

Name
DELIVERY_ID
DEPARTURE_ID
CONTAINER_ID
CONTAINER_ITEM_ID
MASTER_SERIAL_NUMBER
CONTAINER_SERIAL_NUMBER
LOT_NUMBER
PARENT_SEQUENCE_NUMBER
SEQUENCE_NUMBER
CONTAINER_QUANTITY
CONTAINER_TYPE_INT
CONTAINER_GROSS_WEIGHT
CONTAINER_GROSS_WEIGHT_UOM_INT
CONTAINER_CATEGORY
CONTAINER_ATTRIBUTE1
CONTAINER_ATTRIBUTE2
CONTAINER_ATTRIBUTE3
CONTAINER_ATTRIBUTE4
CONTAINER_ATTRIBUTE5
CONTAINER_ATTRIBUTE6
CONTAINER_ATTRIBUTE7
CONTAINER_ATTRIBUTE8
CONTAINER_ATTRIBUTE9
CONTAINER_ATTRIBUTE10
CONTAINER_ATTRIBUTE11
CONTAINER_ATTRIBUTE12
CONTAINER_ATTRIBUTE13
CONTAINER_ATTRIBUTE14
CONTAINER_ATTRIBUTE15
CONTAINER_VOLUME
CONTAINER_VOLUME_UOM_CODE_INT
CONTAINER_NET_WEIGHT
CONTAINER_FILL_PERCENT
PARENT_CONTAINER_ID
MASTER_CONTAINER_ID
CONTAINER_MAXIMUM_VOLUME
CONTAINER_MAXIMUM_LOAD_WEIGHT
CONTAINER_MINIMUM_FILL_PERCENT
CONTAINER_TARE_WEIGHT