VIEW: APPS.WSH_BIS_BACKORDERED_SUM_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)