View: OE_BIS_CUSTOMER_DELIVERIES_V

View Text

SELECT SUM(DECODE(TRUNC(PROMISE_DATE)
, TRUNC(DATE_CLOSED)
, 1
, 0))/ COUNT(*) * 100 DELIVERY_PERCENT
, TRUNC(PROMISE_DATE) DAY
FROM WSH_BIS_FILL_RATE_V
WHERE CUSTOMER_ID IN (SELECT CUSTOMER_ID
FROM OE_BIS_TOP_CUSTOMERS)
AND PROMISE_DATE IS NOT NULL GROUP BY TRUNC(PROMISE_DATE)

Columns