VIEW: APPS.WSHFV_CONTAINER_CONTENTS

Source

View Text - Preformatted

SELECT WDA.DELIVERY_DETAIL_ID ,WDA.PARENT_DELIVERY_DETAIL_ID CONTAINER_ID ,DD1.ITEM_DESCRIPTION CONTAINER_DESCRIPTION ,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 ,WSH_DELIVERY_DETAILS DD1 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 WDA.PARENT_DELIVERY_DETAIL_ID = DD1.DELIVERY_DETAIL_ID(+) AND NVL(WDD.LINE_DIRECTION, 'O') IN ('O', 'IO') WITH READ ONLY

View Text - HTML Formatted

SELECT WDA.DELIVERY_DETAIL_ID
, WDA.PARENT_DELIVERY_DETAIL_ID CONTAINER_ID
, DD1.ITEM_DESCRIPTION CONTAINER_DESCRIPTION
, 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
, WSH_DELIVERY_DETAILS DD1
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 WDA.PARENT_DELIVERY_DETAIL_ID = DD1.DELIVERY_DETAIL_ID(+)
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY