VIEW: APPS.HRI_OBI_MDS_WRKFC_MGRH_C01_V

Source

View Text - Preformatted

SELECT sup_person_fk ,sup_mngrsc_fk ,sup_directs_only_flag ,time_day_mnth_start_fk ,time_day_mnth_end_fk ,time_month_snp_fk ,job_function_fk ,job_family_fk ,geo_country_fk ,ptyp_wrktyp_fk ,cur_currency_fk ,headcount_start ,headcount_end ,headcount_hire ,headcount_term ,headcount_sep_vol ,headcount_sep_invol ,headcount_prmtn ,headcount_start * employee_ind ,headcount_end * employee_ind ,headcount_hire * employee_ind ,headcount_term * employee_ind ,headcount_sep_vol * employee_ind ,headcount_sep_invol * employee_ind ,headcount_start * contingent_ind ,headcount_end * contingent_ind ,headcount_hire * contingent_ind ,headcount_term * contingent_ind ,fte_start ,fte_end ,fte_hire ,fte_term ,fte_sep_vol ,fte_sep_invol ,fte_prmtn ,fte_start * employee_ind ,fte_end * employee_ind ,fte_hire * employee_ind ,fte_term * employee_ind ,fte_sep_vol * employee_ind ,fte_sep_invol * employee_ind ,fte_start * contingent_ind ,fte_end * contingent_ind ,fte_hire * contingent_ind ,fte_term * contingent_ind ,count_pasg_end * employee_ind ,count_pasg_hire * employee_ind ,count_pasg_term * employee_ind ,count_asg_end * employee_ind ,count_asg_hire * employee_ind ,count_asg_term * employee_ind ,count_pasg_end * contingent_ind ,count_pasg_hire * contingent_ind ,count_pasg_term * contingent_ind ,count_asg_end * contingent_ind ,count_asg_hire * contingent_ind ,count_asg_term * contingent_ind ,count_pasg_sep_vol ,count_pasg_sep_invol ,count_pasg_sep_vol * employee_ind ,count_pasg_sep_invol * employee_ind ,count_asg_sep_vol ,count_asg_sep_invol ,count_asg_sep_vol * employee_ind ,count_asg_sep_invol * employee_ind ,count_asg_prmtn ,pow_days_on_end_date * employee_ind ,pow_months_on_end_date * employee_ind ,(pow_months_on_end_date / 12) * employee_ind ,pow_days_on_end_date * contingent_ind ,pow_months_on_end_date * contingent_ind ,(pow_months_on_end_date / 12) * contingent_ind ,days_since_last_prmtn ,months_since_last_prmtn ,months_since_last_prmtn / 12 years_since_last_prmtn ,anl_slry_start ,anl_slry_end ,hri_oltp_view_currency.convert_to_primary_crnc (cur_currency_fk, anl_slry_start) anl_slry_start_prm ,hri_oltp_view_currency.convert_to_primary_crnc (cur_currency_fk, anl_slry_end) anl_slry_end_prm ,hri_oltp_view_currency.convert_to_secondary_crnc (cur_currency_fk, anl_slry_start) anl_slry_start_sec ,hri_oltp_view_currency.convert_to_secondary_crnc (cur_currency_fk, anl_slry_end) anl_slry_end_sec FROM hri_mds_wrkfc_mgrh_c01_ct WITH READ ONLY

View Text - HTML Formatted

SELECT SUP_PERSON_FK
, SUP_MNGRSC_FK
, SUP_DIRECTS_ONLY_FLAG
, TIME_DAY_MNTH_START_FK
, TIME_DAY_MNTH_END_FK
, TIME_MONTH_SNP_FK
, JOB_FUNCTION_FK
, JOB_FAMILY_FK
, GEO_COUNTRY_FK
, PTYP_WRKTYP_FK
, CUR_CURRENCY_FK
, HEADCOUNT_START
, HEADCOUNT_END
, HEADCOUNT_HIRE
, HEADCOUNT_TERM
, HEADCOUNT_SEP_VOL
, HEADCOUNT_SEP_INVOL
, HEADCOUNT_PRMTN
, HEADCOUNT_START * EMPLOYEE_IND
, HEADCOUNT_END * EMPLOYEE_IND
, HEADCOUNT_HIRE * EMPLOYEE_IND
, HEADCOUNT_TERM * EMPLOYEE_IND
, HEADCOUNT_SEP_VOL * EMPLOYEE_IND
, HEADCOUNT_SEP_INVOL * EMPLOYEE_IND
, HEADCOUNT_START * CONTINGENT_IND
, HEADCOUNT_END * CONTINGENT_IND
, HEADCOUNT_HIRE * CONTINGENT_IND
, HEADCOUNT_TERM * CONTINGENT_IND
, FTE_START
, FTE_END
, FTE_HIRE
, FTE_TERM
, FTE_SEP_VOL
, FTE_SEP_INVOL
, FTE_PRMTN
, FTE_START * EMPLOYEE_IND
, FTE_END * EMPLOYEE_IND
, FTE_HIRE * EMPLOYEE_IND
, FTE_TERM * EMPLOYEE_IND
, FTE_SEP_VOL * EMPLOYEE_IND
, FTE_SEP_INVOL * EMPLOYEE_IND
, FTE_START * CONTINGENT_IND
, FTE_END * CONTINGENT_IND
, FTE_HIRE * CONTINGENT_IND
, FTE_TERM * CONTINGENT_IND
, COUNT_PASG_END * EMPLOYEE_IND
, COUNT_PASG_HIRE * EMPLOYEE_IND
, COUNT_PASG_TERM * EMPLOYEE_IND
, COUNT_ASG_END * EMPLOYEE_IND
, COUNT_ASG_HIRE * EMPLOYEE_IND
, COUNT_ASG_TERM * EMPLOYEE_IND
, COUNT_PASG_END * CONTINGENT_IND
, COUNT_PASG_HIRE * CONTINGENT_IND
, COUNT_PASG_TERM * CONTINGENT_IND
, COUNT_ASG_END * CONTINGENT_IND
, COUNT_ASG_HIRE * CONTINGENT_IND
, COUNT_ASG_TERM * CONTINGENT_IND
, COUNT_PASG_SEP_VOL
, COUNT_PASG_SEP_INVOL
, COUNT_PASG_SEP_VOL * EMPLOYEE_IND
, COUNT_PASG_SEP_INVOL * EMPLOYEE_IND
, COUNT_ASG_SEP_VOL
, COUNT_ASG_SEP_INVOL
, COUNT_ASG_SEP_VOL * EMPLOYEE_IND
, COUNT_ASG_SEP_INVOL * EMPLOYEE_IND
, COUNT_ASG_PRMTN
, POW_DAYS_ON_END_DATE * EMPLOYEE_IND
, POW_MONTHS_ON_END_DATE * EMPLOYEE_IND
, (POW_MONTHS_ON_END_DATE / 12) * EMPLOYEE_IND
, POW_DAYS_ON_END_DATE * CONTINGENT_IND
, POW_MONTHS_ON_END_DATE * CONTINGENT_IND
, (POW_MONTHS_ON_END_DATE / 12) * CONTINGENT_IND
, DAYS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN / 12 YEARS_SINCE_LAST_PRMTN
, ANL_SLRY_START
, ANL_SLRY_END
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_PRIMARY_CRNC (CUR_CURRENCY_FK
, ANL_SLRY_START) ANL_SLRY_START_PRM
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_PRIMARY_CRNC (CUR_CURRENCY_FK
, ANL_SLRY_END) ANL_SLRY_END_PRM
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_SECONDARY_CRNC (CUR_CURRENCY_FK
, ANL_SLRY_START) ANL_SLRY_START_SEC
, HRI_OLTP_VIEW_CURRENCY.CONVERT_TO_SECONDARY_CRNC (CUR_CURRENCY_FK
, ANL_SLRY_END) ANL_SLRY_END_SEC
FROM HRI_MDS_WRKFC_MGRH_C01_CT WITH READ ONLY