MATERIALIZED VIEW: APPS.HRI_MDP_BEN_ELCTN_PGM_MV

Source

(
SELECT /* 12.0: bug#4526784 */  asnd_lf_evt_dt,
       pgm_id,
       SUM(elig_ind) elig_count,
       SUM(enrt_ind) enrt_count,
       SUM(elig_ind) - (SUM(enrt_ind) + SUM(dflt_ind)) not_enrt_count ,
       SUM(dflt_ind) dflt_count
  FROM hri_mb_ben_elctn_evnt_ct pelc
 GROUP BY asnd_lf_evt_dt, pgm_id
 )