MATERIALIZED VIEW: APPS.HRI_MDP_BEN_ELCTN_PGMV_MV

Source

(
SELECT /* 12.0: bug#4526784 */  enrl_evt.rec_type,
       enrl_evt.asnd_lf_evt_dt,
	   enrl_evt.pgm_id,
	   enrl_evt.cnt_all
FROM (
 select 'ELIG' rec_type, asnd_lf_evt_dt, pgm_id, elig_count cnt_all
  from hri_mdp_ben_elctn_pgm_mv
 UNION
 select 'ENRT' rec_type, asnd_lf_evt_dt, pgm_id, enrt_count cnt_all
  from hri_mdp_ben_elctn_pgm_mv
 UNION
 select 'DFLT' rec_type, asnd_lf_evt_dt, pgm_id, dflt_count cnt_all
  from hri_mdp_ben_elctn_pgm_mv
 UNION
 select 'NOT_ENRT' rec_type, asnd_lf_evt_dt, pgm_id, not_enrt_count cnt_all
  from hri_mdp_ben_elctn_pgm_mv
 ) enrl_evt
)