MATERIALIZED VIEW: APPS.HRI_DBI_WMV_COUNT_MV

Source

SELECT /* 12.0: bug#4526784 */ 
  hsc.supervisor_person_id   supervisor_id ,
  hsc.effective_start_date   effective_date ,
  hsc.total_headcount        wmv_count ,
  'TOTAL_WMV_COUNT'          count_type
FROM
  hri_mdp_sup_wcnt_sup_mv     hsc
WHERE hsc.wkth_wktyp_code = 'EMP'