View: WSH_BIS_BACKORDERED_SUM_V

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

View Text

SELECT TRUNC(PL.CREATION_DATE) DAY
, COUNT(PLD.PICKING_LINE_DETAIL_ID) LINES
, MAX(PL.WAREHOUSE_ID) WAREHOUSE_ID
FROM SO_PICKING_LINES_ALL PL
, SO_PICKING_LINE_DETAILS PLD
WHERE PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
AND PL.PICKING_HEADER_ID IN (-1
, 0) GROUP BY TRUNC(PL.CREATION_DATE)

Columns