[Home] [Help]
View: WSH_BIS_SHIPPED_BY_DAY_V
View Text
SELECT SUM(DECODE(TRUNC(SCHEDULE_DATE)
, TRUNC(DATE_CLOSED)
, 1
, 0)) NUMBER_FILLED
, COUNT(*) NUMBER_DUE
, TRUNC(SCHEDULE_DATE) DAY
, WAREHOUSE_ID
FROM WSH_BIS_FILL_RATE_V GROUP BY TRUNC(SCHEDULE_DATE)
, WAREHOUSE_ID
Columns
Name |
NUMBER_FILLED |
NUMBER_DUE |
DAY |
WAREHOUSE_ID |