VIEW: APPS.WSHBV_CONTAINERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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