[Home] [Help]
MATERIALIZED VIEW: APPS.HRI_MDP_BEN_LESTAT_PGM_MV
Source
(
SELECT /* 12.0: bug#4526784 */ asnd_lf_evt_dt,
pgm_id,
ler_status_cd,
COUNT(DISTINCT person_id) per_count
FROM hri_mb_ben_elctn_evnt_ct pelc
GROUP BY asnd_lf_evt_dt, pgm_id, ler_status_cd
)