View: WSHBV_CONTAINER_CONTENTS

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

View Text

SELECT WDA.DELIVERY_DETAIL_ID
, WDA.PARENT_DELIVERY_DETAIL_ID CONTAINER_ID
, WDA.DELIVERY_ID
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_LINE_NUMBER
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, WDD.ITEM_DESCRIPTION
, WDD.REQUESTED_QUANTITY PACKED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM UOM
FROM WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WDD
, MTL_SYSTEM_ITEMS MSI
WHERE WDA.PARENT_DELIVERY_DETAIL_ID IS NOT NULL
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns