APPS.HRI_EDW_DIM_SIZING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

  SELECT avg(nvl(vsize(age_band_pk),0))
  FROM edw_hr_age_age_band_lcv;

Line: 35

  SELECT avg(nvl(vsize(asg_change_pk),0))
  FROM edw_hr_asch_asg_chng_lcv;

Line: 57

  SELECT avg(nvl(vsize(assignment_pk),0))
  FROM edw_hr_asgn_assgnmnt_lcv;

Line: 79

  SELECT avg(nvl(vsize(grade_pk),0))
  FROM edw_hr_grd_grades_lcv;

Line: 101

  SELECT avg(nvl(vsize(job_pk),0))
  FROM edw_hr_job_jobs_lcv;

Line: 123

  SELECT avg(nvl(vsize(service_band_pk),0))
  FROM edw_hr_srvc_srv_band_lcv;

Line: 145

  SELECT avg(nvl(vsize(movement_pk),0))
  FROM edw_hr_mvmt_mvmnts_lcv;

Line: 167

  SELECT avg(nvl(vsize(person_type_pk),0))
  FROM edw_hr_ptyp_prsn_typ_lcv;

Line: 189

  SELECT avg(nvl(vsize(position_pk),0))
  FROM edw_hr_pstn_position_lcv;

Line: 211

  SELECT avg(nvl(vsize(assignment_pk),0))
  FROM edw_hr_perm_assign_lcv;

Line: 233

  SELECT avg(nvl(vsize(organization_pk),0))
  FROM edw_orga_org_lcv;

Line: 255

  SELECT avg(nvl(vsize(reason_pk),0))
  FROM edw_hr_rson_reasons_lcv;

Line: 277

  SELECT avg(nvl(vsize(vacancy_pk),0))
  FROM edw_hr_rqvc_vacancy_lcv;

Line: 299

  SELECT avg(nvl(vsize(rec_activity_pk),0))
  FROM edw_hr_ract_activity_lcv;

Line: 321

  SELECT avg(nvl(vsize(location_pk),0))
  FROM edw_geog_location_lcv;