View: WSH_BIS_FILL_RATE_V

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

View Text

SELECT PH.WAREHOUSE_ID WAREHOUSE_ID
, PH.CREATION_DATE DATE_PRINTED
, DEP.DATE_CLOSED(+) DATE_CLOSED
, L.DATE_REQUESTED_CURRENT REQUEST_DATE
, PL.SCHEDULE_DATE SCHEDULE_DATE
, L.PROMISE_DATE PROMISE_DATE
, DECODE(PL.INCLUDED_ITEM_FLAG
, 'Y'
, 0
, NVL(PLD.SHIPPED_QUANTITY
, 0) * L.SELLING_PRICE) SHIPMENT_VALUE
, H.CUSTOMER_ID CUSTOMER_ID
, H.CURRENCY_CODE LINE_CURRENCY
, L.ORG_ID OU_ID
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
, SO_HEADERS_ALL H
, 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
AND L.HEADER_ID = H.HEADER_ID

Columns