VIEW: APPS.WSH_DSNO_CONTAINERS_V

Source

View Text - Preformatted

SELECT DISTINCT WCI.DELIVERY_DETAIL_ID CONTAINER_INSTANCE_ID, WCI.CONTAINER_NAME LPN, WCI.INVENTORY_ITEM_ID CONTAINER_ITEM_ID, WCI.MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER, WCI.SERIAL_NUMBER CONTAINER_SERIAL_NUMBER, WCI.LOT_NUMBER LOT_NUMBER, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_CONTAINER_INSTANCE_ID, WCIP.CONTAINER_NAME PARENT_LPN, WCI.REQUESTED_QUANTITY CONTAINER_QUANTITY, WCI.CONTAINER_TYPE_CODE CONTAINER_TYPE_INT, WCI.GROSS_WEIGHT CONTAINER_GROSS_WEIGHT, WCI.WEIGHT_UOM_CODE CONTAINER_GROSS_WEIGHT_UOM_INT, WCI.TP_ATTRIBUTE_CATEGORY CONTAINER_TP_CATEGORY, WCI.TP_ATTRIBUTE1 CONTAINER_TP_ATTRIBUTE1, WCI.TP_ATTRIBUTE2 CONTAINER_TP_ATTRIBUTE2, WCI.TP_ATTRIBUTE3 CONTAINER_TP_ATTRIBUTE3, WCI.TP_ATTRIBUTE4 CONTAINER_TP_ATTRIBUTE4, WCI.TP_ATTRIBUTE5 CONTAINER_TP_ATTRIBUTE5, WCI.TP_ATTRIBUTE6 CONTAINER_TP_ATTRIBUTE6, WCI.TP_ATTRIBUTE7 CONTAINER_TP_ATTRIBUTE7, WCI.TP_ATTRIBUTE8 CONTAINER_TP_ATTRIBUTE8, WCI.TP_ATTRIBUTE9 CONTAINER_TP_ATTRIBUTE9, WCI.TP_ATTRIBUTE10 CONTAINER_TP_ATTRIBUTE10, WCI.TP_ATTRIBUTE11 CONTAINER_TP_ATTRIBUTE11, WCI.TP_ATTRIBUTE12 CONTAINER_TP_ATTRIBUTE12, WCI.TP_ATTRIBUTE13 CONTAINER_TP_ATTRIBUTE13, WCI.TP_ATTRIBUTE14 CONTAINER_TP_ATTRIBUTE14, WCI.TP_ATTRIBUTE15 CONTAINER_TP_ATTRIBUTE15, WCI.ATTRIBUTE_CATEGORY CONTAINER_CATEGORY, WCI.ATTRIBUTE1 CONTAINER_ATTRIBUTE1, WCI.ATTRIBUTE2 CONTAINER_ATTRIBUTE2, WCI.ATTRIBUTE3 CONTAINER_ATTRIBUTE3, WCI.ATTRIBUTE4 CONTAINER_ATTRIBUTE4, WCI.ATTRIBUTE5 CONTAINER_ATTRIBUTE5, WCI.ATTRIBUTE6 CONTAINER_ATTRIBUTE6, WCI.ATTRIBUTE7 CONTAINER_ATTRIBUTE7, WCI.ATTRIBUTE8 CONTAINER_ATTRIBUTE8, WCI.ATTRIBUTE9 CONTAINER_ATTRIBUTE9, WCI.ATTRIBUTE10 CONTAINER_ATTRIBUTE10, WCI.ATTRIBUTE11 CONTAINER_ATTRIBUTE11, WCI.ATTRIBUTE12 CONTAINER_ATTRIBUTE12, WCI.ATTRIBUTE13 CONTAINER_ATTRIBUTE13, WCI.ATTRIBUTE14 CONTAINER_ATTRIBUTE14, WCI.ATTRIBUTE15 CONTAINER_ATTRIBUTE15, WCI.VOLUME CONTAINER_VOLUME, WCI.VOLUME_UOM_CODE CONTAINER_VOLUME_UOM_CODE_INT, WCI.NET_WEIGHT CONTAINER_NET_WEIGHT, WCI.FILL_PERCENT CONTAINER_FILL_PERCENT, WCI.MAXIMUM_VOLUME CONTAINER_MAXIMUM_VOLUME, WCI.MAXIMUM_LOAD_WEIGHT CONTAINER_MAXIMUM_LOAD_WEIGHT, WCI.MINIMUM_FILL_PERCENT CONTAINER_MINIMUM_FILL_PERCENT, WCI.GROSS_WEIGHT - WCI.NET_WEIGHT CONTAINER_TARE_WEIGHT , MTI.SEGMENT1 CONTAINER_ITEM_NAME, MTI.ITEM_TYPE CONTAINER_ITEM_TYPE_INT, WCI.SEAL_CODE CONTAINER_SEAL_CODE, WCI.TRACKING_NUMBER CONTAINER_TRACKING_NUMBER, WEPC.EPC CONTAINER_EPC FROM WSH_DELIVERY_DETAILS WCIP, WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_DELIVERY_DETAILS WCI, MTL_SYSTEM_ITEMS MTI, WMS_EPC WEPC WHERE NVL(WDA.PARENT_DELIVERY_DETAIL_ID, '-99999') = WCIP.DELIVERY_DETAIL_ID (+) AND WDA.DELIVERY_DETAIL_ID = WCI.DELIVERY_DETAIL_ID AND WCI.CONTAINER_FLAG = 'Y' AND WCI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID(+) AND WCI.ORGANIZATION_ID = MTI.ORGANIZATION_ID(+) AND WCI.LPN_ID = WEPC.LPN_ID(+) AND WEPC.CROSS_REF_TYPE(+) = 1

View Text - HTML Formatted

SELECT DISTINCT WCI.DELIVERY_DETAIL_ID CONTAINER_INSTANCE_ID
, WCI.CONTAINER_NAME LPN
, WCI.INVENTORY_ITEM_ID CONTAINER_ITEM_ID
, WCI.MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER
, WCI.SERIAL_NUMBER CONTAINER_SERIAL_NUMBER
, WCI.LOT_NUMBER LOT_NUMBER
, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_CONTAINER_INSTANCE_ID
, WCIP.CONTAINER_NAME PARENT_LPN
, WCI.REQUESTED_QUANTITY CONTAINER_QUANTITY
, WCI.CONTAINER_TYPE_CODE CONTAINER_TYPE_INT
, WCI.GROSS_WEIGHT CONTAINER_GROSS_WEIGHT
, WCI.WEIGHT_UOM_CODE CONTAINER_GROSS_WEIGHT_UOM_INT
, WCI.TP_ATTRIBUTE_CATEGORY CONTAINER_TP_CATEGORY
, WCI.TP_ATTRIBUTE1 CONTAINER_TP_ATTRIBUTE1
, WCI.TP_ATTRIBUTE2 CONTAINER_TP_ATTRIBUTE2
, WCI.TP_ATTRIBUTE3 CONTAINER_TP_ATTRIBUTE3
, WCI.TP_ATTRIBUTE4 CONTAINER_TP_ATTRIBUTE4
, WCI.TP_ATTRIBUTE5 CONTAINER_TP_ATTRIBUTE5
, WCI.TP_ATTRIBUTE6 CONTAINER_TP_ATTRIBUTE6
, WCI.TP_ATTRIBUTE7 CONTAINER_TP_ATTRIBUTE7
, WCI.TP_ATTRIBUTE8 CONTAINER_TP_ATTRIBUTE8
, WCI.TP_ATTRIBUTE9 CONTAINER_TP_ATTRIBUTE9
, WCI.TP_ATTRIBUTE10 CONTAINER_TP_ATTRIBUTE10
, WCI.TP_ATTRIBUTE11 CONTAINER_TP_ATTRIBUTE11
, WCI.TP_ATTRIBUTE12 CONTAINER_TP_ATTRIBUTE12
, WCI.TP_ATTRIBUTE13 CONTAINER_TP_ATTRIBUTE13
, WCI.TP_ATTRIBUTE14 CONTAINER_TP_ATTRIBUTE14
, WCI.TP_ATTRIBUTE15 CONTAINER_TP_ATTRIBUTE15
, WCI.ATTRIBUTE_CATEGORY CONTAINER_CATEGORY
, WCI.ATTRIBUTE1 CONTAINER_ATTRIBUTE1
, WCI.ATTRIBUTE2 CONTAINER_ATTRIBUTE2
, WCI.ATTRIBUTE3 CONTAINER_ATTRIBUTE3
, WCI.ATTRIBUTE4 CONTAINER_ATTRIBUTE4
, WCI.ATTRIBUTE5 CONTAINER_ATTRIBUTE5
, WCI.ATTRIBUTE6 CONTAINER_ATTRIBUTE6
, WCI.ATTRIBUTE7 CONTAINER_ATTRIBUTE7
, WCI.ATTRIBUTE8 CONTAINER_ATTRIBUTE8
, WCI.ATTRIBUTE9 CONTAINER_ATTRIBUTE9
, WCI.ATTRIBUTE10 CONTAINER_ATTRIBUTE10
, WCI.ATTRIBUTE11 CONTAINER_ATTRIBUTE11
, WCI.ATTRIBUTE12 CONTAINER_ATTRIBUTE12
, WCI.ATTRIBUTE13 CONTAINER_ATTRIBUTE13
, WCI.ATTRIBUTE14 CONTAINER_ATTRIBUTE14
, WCI.ATTRIBUTE15 CONTAINER_ATTRIBUTE15
, WCI.VOLUME CONTAINER_VOLUME
, WCI.VOLUME_UOM_CODE CONTAINER_VOLUME_UOM_CODE_INT
, WCI.NET_WEIGHT CONTAINER_NET_WEIGHT
, WCI.FILL_PERCENT CONTAINER_FILL_PERCENT
, WCI.MAXIMUM_VOLUME CONTAINER_MAXIMUM_VOLUME
, WCI.MAXIMUM_LOAD_WEIGHT CONTAINER_MAXIMUM_LOAD_WEIGHT
, WCI.MINIMUM_FILL_PERCENT CONTAINER_MINIMUM_FILL_PERCENT
, WCI.GROSS_WEIGHT - WCI.NET_WEIGHT CONTAINER_TARE_WEIGHT
, MTI.SEGMENT1 CONTAINER_ITEM_NAME
, MTI.ITEM_TYPE CONTAINER_ITEM_TYPE_INT
, WCI.SEAL_CODE CONTAINER_SEAL_CODE
, WCI.TRACKING_NUMBER CONTAINER_TRACKING_NUMBER
, WEPC.EPC CONTAINER_EPC
FROM WSH_DELIVERY_DETAILS WCIP
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_DELIVERY_DETAILS WCI
, MTL_SYSTEM_ITEMS MTI
, WMS_EPC WEPC
WHERE NVL(WDA.PARENT_DELIVERY_DETAIL_ID
, '-99999') = WCIP.DELIVERY_DETAIL_ID (+)
AND WDA.DELIVERY_DETAIL_ID = WCI.DELIVERY_DETAIL_ID
AND WCI.CONTAINER_FLAG = 'Y'
AND WCI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID(+)
AND WCI.ORGANIZATION_ID = MTI.ORGANIZATION_ID(+)
AND WCI.LPN_ID = WEPC.LPN_ID(+)
AND WEPC.CROSS_REF_TYPE(+) = 1