View: WSH_BIS_WAREHOUSE_DOCS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.WSH_BIS_WAREHOUSE_DOCS_V

View Text

SELECT PLD.PICK_SLIP_NUMBER
, MAX(PH.WAREHOUSE_ID) WAREHOUSE_ID
, MAX(PH.CREATION_DATE) DATE_PRINTED
, DECODE( SUM(DECODE(DEP.DATE_CLOSED(+)
, NULL
, 1
, 0))
, 0
, MAX(DEP.DATE_CLOSED(+))
, NULL) DATE_CLOSED
, SUM(1) NUMBER_OF_LINES
, SUM( NVL(SI.UNIT_WEIGHT
, 0) * WSH_WV_PVT.CONVERT_UOM(PL.UNIT_CODE
, SI.PRIMARY_UOM_CODE
, PLD.REQUESTED_QUANTITY
, PL.INVENTORY_ITEM_ID) ) WEIGHT
, SUM( NVL(SI.UNIT_VOLUME
, 0) * WSH_WV_PVT.CONVERT_UOM(PL.UNIT_CODE
, SI.PRIMARY_UOM_CODE
, PLD.REQUESTED_QUANTITY
, PL.INVENTORY_ITEM_ID) ) VOLUME
, SUM( DECODE(PL.INCLUDED_ITEM_FLAG
, 'Y'
, 0
, L.SELLING_PRICE * PLD.REQUESTED_QUANTITY)) VALUE
FROM SO_PICKING_BATCHES_ALL PB
, SO_PICKING_HEADERS_ALL PH
, SO_PICKING_LINES_ALL PL
, SO_PICKING_LINE_DETAILS PLD
, SO_LINES_ALL L
, WSH_DEPARTURES DEP
, MTL_SYSTEM_ITEMS SI
WHERE PB.BATCH_ID = PH.BATCH_ID
AND PH.PICKING_HEADER_ID = PL.PICKING_HEADER_ID
AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
AND PL.ORDER_LINE_ID = L.LINE_ID
AND PLD.DEPARTURE_ID = DEP.DEPARTURE_ID(+)
AND PLD.PICK_SLIP_NUMBER IS NOT NULL
AND PL.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND PH.WAREHOUSE_ID = SI.ORGANIZATION_ID GROUP BY PLD.PICK_SLIP_NUMBER

Columns