VIEW: APPS.CLN_XML_CONTAINERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')