View: CLN_XML_CONTAINERS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for SHIPUNIT containers section in OAG SHOW_SHIPMENT_005 XML payload
Implementation/DBA Data:	APPS.CLN_XML_CONTAINERS_V

View Text

SELECT DISTINCT WCI.DELIVERY_DETAIL_ID CONTAINER_INSTANCE_ID
, WCI.SERIAL_NUMBER CONTAINER_SERIAL_NUMBER
, WCI.CONTAINER_TYPE_CODE CONTAINER_TYPE_INT
, WCI.VOLUME CONTAINER_VOLUME
, WCI.VOLUME_UOM_CODE CONTAINER_VOLUME_UOM_CODE_INT
, WCI.NET_WEIGHT CONTAINER_NET_WEIGHT
, WCI.SEAL_CODE CONTAINER_SEAL_CODE
, WCI.TRACKING_NUMBER CONTAINER_TRACKING_NUMBER
, WDA.DELIVERY_ID
, MTI.UNIT_HEIGHT
, MTI.UNIT_LENGTH
, MTI.UNIT_WIDTH
, WDA.PARENT_DELIVERY_DETAIL_ID
, WCI.LPN_ID LPN_ID
FROM WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WCI
, MTL_SYSTEM_ITEMS MTI
WHERE 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.LINE_DIRECTION IS NULL OR WCI.LINE_DIRECTION = 'O')

Columns