View: WSHFV_CONTAINERS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Containers
Implementation/DBA Data:	APPS.WSHFV_CONTAINERS

View Text

SELECT WDD.DELIVERY_DETAIL_ID CONTAINER_ID
, WDA.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, 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
, PDD.CONTAINER_NAME PARENT_CONTAINER_NAME
, WDD.GROSS_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HAOU.NAME ORGANIZATION_NAME
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, 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'
, SUBINV.DESCRIPTION SUBINVENTORY_DESCRIPTION
, WDD.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS WDA
, MTL_SYSTEM_ITEMS MSI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_DETAILS PDD
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_SECONDARY_INVENTORIES SUBINV
, MTL_ITEM_LOCATIONS MIL
WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WDD.ORGANIZATION_ID =MP.ORGANIZATION_ID(+)
AND WDD.ORGANIZATION_ID =HAOU.ORGANIZATION_ID(+)
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND PDD.DELIVERY_DETAIL_ID(+)=WDA.PARENT_DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID (+)
AND WDD.SUBINVENTORY = SUBINV.SECONDARY_INVENTORY_NAME(+)
AND WDD.ORGANIZATION_ID = SUBINV.ORGANIZATION_ID(+)
AND WDD.CONTAINER_FLAG='Y'
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') --AND WDD.SOURCE_CODE='WSH'
AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+)
AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+)
AND '_SEC:WDD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns