MATERIALIZED VIEW: APPS.HRI_MDP_SUP_GAIN_HIRE_MV

Source

SELECT  /* 12.0: bug#4526784 */
 nh.supervisor_person_id          supervisor_id
,nh.job_id                        job_id
,nh.effective_date                effective_date
,nh.anl_slry_currency             currency
,SUM(NVL(nh.headcount_value,0))   headcount_value
,SUM(NVL(nh.fte_value,0))         fte_value
,SUM(NVL(nh.anl_slry_value,0))    salary
,COUNT(NVL(nh.headcount_value,0)) cnt1
,COUNT(NVL(nh.fte_value,0))       cnt2
,COUNT(NVL(nh.anl_slry_value,0))  cnt3
,COUNT(*)                         cnt
FROM HRI.HRI_MAP_SUP_WRKFC_ASG            nh
WHERE nh.worker_hire_ind = 1
AND nh.wkth_wktyp_code = 'EMP'
GROUP BY
 nh.supervisor_person_id
,nh.job_id
,nh.effective_date
,nh.anl_slry_currency