DBA Data[Home] [Help]

MATERIALIZED VIEW: APPS.IBE_BI_CUST_MV

Source


SELECT CUSTOMER_ID,
             MIN (BOOKED_DATE)             BOOKED_DATE,
             COUNT(*)                      D_TOTAL_CNT
             FROM IBE_BI_CUST_INTM_MV
             GROUP BY CUSTOMER_ID