VIEW: APPS.HRI_OBI_MDS_WRKFC_MGRH_SMRY_V

Source

View Text - Preformatted

SELECT /*+ INDEX(wrkfc) */ wrkfc.sup_person_fk ,wrkfc.sup_mngrsc_fk ,wrkfc.sup_directs_only_flag ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.time_month_snp_fk ,wrkfc.ptyp_wrktyp_fk ,hri_oltp_view_wrkfrc_mgrh.get_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) headcount_start ,SUM(wrkfc.headcount_end) headcount_end ,SUM(wrkfc.headcount_hire) headcount_hire ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) headcount_trn_in ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) headcount_trn_out ,SUM(wrkfc.headcount_term) headcount_term ,SUM(wrkfc.headcount_sep_vol) headcount_sep_vol ,SUM(wrkfc.headcount_sep_invol) headcount_sep_invol ,hri_oltp_view_wrkfrc_mgrh.get_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind headcount_start_emp ,SUM(wrkfc.headcount_end) * wrkfc.employee_ind headcount_end_emp ,SUM(wrkfc.headcount_hire) * wrkfc.employee_ind headcount_hire_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind headcount_trn_in_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind headcount_trn_out_emp ,SUM(wrkfc.headcount_term) * wrkfc.employee_ind headcount_term_emp ,SUM(wrkfc.headcount_sep_vol) * wrkfc.employee_ind headcount_sep_vol_emp ,SUM(wrkfc.headcount_sep_invol) * wrkfc.employee_ind headcount_sep_invol_emp ,hri_oltp_view_wrkfrc_mgrh.get_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind headcount_start_cwk ,SUM(wrkfc.headcount_end) * wrkfc.contingent_ind headcount_end_cwk ,SUM(wrkfc.headcount_hire) * wrkfc.contingent_ind headcount_hire_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind headcount_trn_in_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_hdc (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind headcount_trn_out_cwk ,SUM(wrkfc.headcount_term) * wrkfc.contingent_ind headcount_term_cwk ,hri_oltp_view_wrkfrc_mgrh.get_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) fte_start ,SUM(wrkfc.fte_end) fte_end ,SUM(wrkfc.fte_hire) fte_hire ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) fte_trn_in ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) fte_trn_out ,SUM(wrkfc.fte_term) fte_term ,SUM(wrkfc.fte_sep_vol) fte_sep_vol ,SUM(wrkfc.fte_sep_invol) fte_sep_invol ,hri_oltp_view_wrkfrc_mgrh.get_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind fte_start_emp ,SUM(wrkfc.fte_end) * wrkfc.employee_ind fte_end_emp ,SUM(wrkfc.fte_hire) * wrkfc.employee_ind fte_hire_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind fte_trn_in_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind fte_trn_out_emp ,SUM(wrkfc.fte_term) * wrkfc.employee_ind fte_term_emp ,SUM(wrkfc.fte_sep_vol) * wrkfc.employee_ind fte_sep_vol_emp ,SUM(wrkfc.fte_sep_invol) * wrkfc.employee_ind fte_sep_invol_emp ,hri_oltp_view_wrkfrc_mgrh.get_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind fte_start_cwk ,SUM(wrkfc.fte_end) * wrkfc.contingent_ind fte_end_cwk ,SUM(wrkfc.fte_hire) * wrkfc.contingent_ind fte_hire_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind fte_trn_in_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_fte (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind fte_trn_out_cwk ,SUM(wrkfc.fte_term) * wrkfc.contingent_ind fte_term_cwk ,hri_oltp_view_wrkfrc_mgrh.get_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_pasg_start_emp ,SUM(wrkfc.count_pasg_end) * wrkfc.employee_ind count_pasg_end_emp ,SUM(wrkfc.count_pasg_hire) * wrkfc.employee_ind count_pasg_hire_emp ,SUM(wrkfc.count_pasg_term) * wrkfc.employee_ind count_pasg_term_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_pasg_trn_in_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_pasg_trn_out_emp ,hri_oltp_view_wrkfrc_mgrh.get_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_pasg_start_cwk ,SUM(wrkfc.count_pasg_end) * wrkfc.contingent_ind count_pasg_end_cwk ,SUM(wrkfc.count_pasg_hire) * wrkfc.contingent_ind count_pasg_hire_cwk ,SUM(wrkfc.count_pasg_term) * wrkfc.contingent_ind count_pasg_term_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_pasg_trn_in_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_pasg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_pasg_trn_out_cwk ,SUM(wrkfc.count_pasg_sep_vol) count_pasg_sep_vol ,SUM(wrkfc.count_pasg_sep_invol) count_pasg_sep_invol ,SUM(wrkfc.count_pasg_sep_vol) * wrkfc.employee_ind count_pasg_sep_vol_emp ,SUM(wrkfc.count_pasg_sep_invol) * wrkfc.employee_ind count_pasg_sep_invol_emp ,hri_oltp_view_wrkfrc_mgrh.get_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_asg_start_emp ,SUM(wrkfc.count_asg_end) * wrkfc.employee_ind count_asg_end_emp ,SUM(wrkfc.count_asg_hire) * wrkfc.employee_ind count_asg_hire_emp ,SUM(wrkfc.count_asg_term) * wrkfc.employee_ind count_asg_term_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_asg_trn_in_emp ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.employee_ind count_asg_trn_out_emp ,hri_oltp_view_wrkfrc_mgrh.get_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk - 1 ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_asg_start_cwk ,SUM(wrkfc.count_asg_end) * wrkfc.contingent_ind count_asg_end_cwk ,SUM(wrkfc.count_asg_hire) * wrkfc.contingent_ind count_asg_hire_cwk ,SUM(wrkfc.count_asg_term) * wrkfc.contingent_ind count_asg_term_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_in_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_asg_trn_in_cwk ,hri_oltp_view_wrkfrc_mgrh.get_trn_out_asg_cnt (wrkfc.sup_person_fk ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.sup_directs_only_flag) * wrkfc.contingent_ind count_asg_trn_out_cwk ,SUM(wrkfc.count_asg_sep_vol) count_asg_sep_vol ,SUM(wrkfc.count_asg_sep_invol) count_asg_sep_invol ,SUM(wrkfc.count_asg_sep_vol) * wrkfc.employee_ind count_asg_sep_vol_emp ,SUM(wrkfc.count_asg_sep_invol) * wrkfc.employee_ind count_asg_sep_invol_emp FROM hri_mds_wrkfc_mgrh_c01_ct wrkfc GROUP BY wrkfc.sup_person_fk ,wrkfc.sup_mngrsc_fk ,wrkfc.sup_directs_only_flag ,wrkfc.time_day_mnth_start_fk ,wrkfc.time_day_mnth_end_fk ,wrkfc.time_month_snp_fk ,wrkfc.ptyp_wrktyp_fk ,wrkfc.employee_ind ,wrkfc.contingent_ind

View Text - HTML Formatted

SELECT /*+ INDEX(WRKFC) */ WRKFC.SUP_PERSON_FK
, WRKFC.SUP_MNGRSC_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.TIME_MONTH_SNP_FK
, WRKFC.PTYP_WRKTYP_FK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) HEADCOUNT_START
, SUM(WRKFC.HEADCOUNT_END) HEADCOUNT_END
, SUM(WRKFC.HEADCOUNT_HIRE) HEADCOUNT_HIRE
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) HEADCOUNT_TRN_IN
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) HEADCOUNT_TRN_OUT
, SUM(WRKFC.HEADCOUNT_TERM) HEADCOUNT_TERM
, SUM(WRKFC.HEADCOUNT_SEP_VOL) HEADCOUNT_SEP_VOL
, SUM(WRKFC.HEADCOUNT_SEP_INVOL) HEADCOUNT_SEP_INVOL
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND HEADCOUNT_START_EMP
, SUM(WRKFC.HEADCOUNT_END) * WRKFC.EMPLOYEE_IND HEADCOUNT_END_EMP
, SUM(WRKFC.HEADCOUNT_HIRE) * WRKFC.EMPLOYEE_IND HEADCOUNT_HIRE_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND HEADCOUNT_TRN_IN_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND HEADCOUNT_TRN_OUT_EMP
, SUM(WRKFC.HEADCOUNT_TERM) * WRKFC.EMPLOYEE_IND HEADCOUNT_TERM_EMP
, SUM(WRKFC.HEADCOUNT_SEP_VOL) * WRKFC.EMPLOYEE_IND HEADCOUNT_SEP_VOL_EMP
, SUM(WRKFC.HEADCOUNT_SEP_INVOL) * WRKFC.EMPLOYEE_IND HEADCOUNT_SEP_INVOL_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND HEADCOUNT_START_CWK
, SUM(WRKFC.HEADCOUNT_END) * WRKFC.CONTINGENT_IND HEADCOUNT_END_CWK
, SUM(WRKFC.HEADCOUNT_HIRE) * WRKFC.CONTINGENT_IND HEADCOUNT_HIRE_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND HEADCOUNT_TRN_IN_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_HDC (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND HEADCOUNT_TRN_OUT_CWK
, SUM(WRKFC.HEADCOUNT_TERM) * WRKFC.CONTINGENT_IND HEADCOUNT_TERM_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) FTE_START
, SUM(WRKFC.FTE_END) FTE_END
, SUM(WRKFC.FTE_HIRE) FTE_HIRE
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) FTE_TRN_IN
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) FTE_TRN_OUT
, SUM(WRKFC.FTE_TERM) FTE_TERM
, SUM(WRKFC.FTE_SEP_VOL) FTE_SEP_VOL
, SUM(WRKFC.FTE_SEP_INVOL) FTE_SEP_INVOL
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND FTE_START_EMP
, SUM(WRKFC.FTE_END) * WRKFC.EMPLOYEE_IND FTE_END_EMP
, SUM(WRKFC.FTE_HIRE) * WRKFC.EMPLOYEE_IND FTE_HIRE_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND FTE_TRN_IN_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND FTE_TRN_OUT_EMP
, SUM(WRKFC.FTE_TERM) * WRKFC.EMPLOYEE_IND FTE_TERM_EMP
, SUM(WRKFC.FTE_SEP_VOL) * WRKFC.EMPLOYEE_IND FTE_SEP_VOL_EMP
, SUM(WRKFC.FTE_SEP_INVOL) * WRKFC.EMPLOYEE_IND FTE_SEP_INVOL_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND FTE_START_CWK
, SUM(WRKFC.FTE_END) * WRKFC.CONTINGENT_IND FTE_END_CWK
, SUM(WRKFC.FTE_HIRE) * WRKFC.CONTINGENT_IND FTE_HIRE_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND FTE_TRN_IN_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_FTE (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND FTE_TRN_OUT_CWK
, SUM(WRKFC.FTE_TERM) * WRKFC.CONTINGENT_IND FTE_TERM_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_PASG_START_EMP
, SUM(WRKFC.COUNT_PASG_END) * WRKFC.EMPLOYEE_IND COUNT_PASG_END_EMP
, SUM(WRKFC.COUNT_PASG_HIRE) * WRKFC.EMPLOYEE_IND COUNT_PASG_HIRE_EMP
, SUM(WRKFC.COUNT_PASG_TERM) * WRKFC.EMPLOYEE_IND COUNT_PASG_TERM_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_PASG_TRN_IN_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_PASG_TRN_OUT_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_PASG_START_CWK
, SUM(WRKFC.COUNT_PASG_END) * WRKFC.CONTINGENT_IND COUNT_PASG_END_CWK
, SUM(WRKFC.COUNT_PASG_HIRE) * WRKFC.CONTINGENT_IND COUNT_PASG_HIRE_CWK
, SUM(WRKFC.COUNT_PASG_TERM) * WRKFC.CONTINGENT_IND COUNT_PASG_TERM_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_PASG_TRN_IN_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_PASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_PASG_TRN_OUT_CWK
, SUM(WRKFC.COUNT_PASG_SEP_VOL) COUNT_PASG_SEP_VOL
, SUM(WRKFC.COUNT_PASG_SEP_INVOL) COUNT_PASG_SEP_INVOL
, SUM(WRKFC.COUNT_PASG_SEP_VOL) * WRKFC.EMPLOYEE_IND COUNT_PASG_SEP_VOL_EMP
, SUM(WRKFC.COUNT_PASG_SEP_INVOL) * WRKFC.EMPLOYEE_IND COUNT_PASG_SEP_INVOL_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_ASG_START_EMP
, SUM(WRKFC.COUNT_ASG_END) * WRKFC.EMPLOYEE_IND COUNT_ASG_END_EMP
, SUM(WRKFC.COUNT_ASG_HIRE) * WRKFC.EMPLOYEE_IND COUNT_ASG_HIRE_EMP
, SUM(WRKFC.COUNT_ASG_TERM) * WRKFC.EMPLOYEE_IND COUNT_ASG_TERM_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_ASG_TRN_IN_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.EMPLOYEE_IND COUNT_ASG_TRN_OUT_EMP
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK - 1
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_ASG_START_CWK
, SUM(WRKFC.COUNT_ASG_END) * WRKFC.CONTINGENT_IND COUNT_ASG_END_CWK
, SUM(WRKFC.COUNT_ASG_HIRE) * WRKFC.CONTINGENT_IND COUNT_ASG_HIRE_CWK
, SUM(WRKFC.COUNT_ASG_TERM) * WRKFC.CONTINGENT_IND COUNT_ASG_TERM_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_IN_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_ASG_TRN_IN_CWK
, HRI_OLTP_VIEW_WRKFRC_MGRH.GET_TRN_OUT_ASG_CNT (WRKFC.SUP_PERSON_FK
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG) * WRKFC.CONTINGENT_IND COUNT_ASG_TRN_OUT_CWK
, SUM(WRKFC.COUNT_ASG_SEP_VOL) COUNT_ASG_SEP_VOL
, SUM(WRKFC.COUNT_ASG_SEP_INVOL) COUNT_ASG_SEP_INVOL
, SUM(WRKFC.COUNT_ASG_SEP_VOL) * WRKFC.EMPLOYEE_IND COUNT_ASG_SEP_VOL_EMP
, SUM(WRKFC.COUNT_ASG_SEP_INVOL) * WRKFC.EMPLOYEE_IND COUNT_ASG_SEP_INVOL_EMP
FROM HRI_MDS_WRKFC_MGRH_C01_CT WRKFC GROUP BY WRKFC.SUP_PERSON_FK
, WRKFC.SUP_MNGRSC_FK
, WRKFC.SUP_DIRECTS_ONLY_FLAG
, WRKFC.TIME_DAY_MNTH_START_FK
, WRKFC.TIME_DAY_MNTH_END_FK
, WRKFC.TIME_MONTH_SNP_FK
, WRKFC.PTYP_WRKTYP_FK
, WRKFC.EMPLOYEE_IND
, WRKFC.CONTINGENT_IND