View: WSHBV_CONTAINERS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_CONTAINERS

View Text

SELECT WDD.DELIVERY_DETAIL_ID CONTAINER_ID
, WDA.DELIVERY_ID
, WDD.REQUESTED_QUANTITY PACKED_QUANTITY
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, WDD.NET_WEIGHT
, WDD.FILL_PERCENT
, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_CONTAINER_ID
, WDD.GROSS_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.ORGANIZATION_ID
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, WDD.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, WDD.SUBINVENTORY
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.SERIAL_NUMBER
, WDD.MASTER_SERIAL_NUMBER
, WDD.CREATION_DATE
, WDD.CREATED_BY
, WDD.LAST_UPDATE_DATE
, WDD.LAST_UPDATED_BY
, WDD.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS WDA
, MTL_SYSTEM_ITEMS MSI
, MTL_ITEM_LOCATIONS MIL
WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDD.CONTAINER_FLAG='Y'
AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+)
AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+)
AND '_SEC:WDD.ORGANIZATION_ID' IS NOT NULL
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns