VIEW: APPS.WSH_BIS_SHIPPED_BY_DAY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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