VIEW: APPS.HRI_OBI_MDS_WRKFC_MNTH_V

Source

View Text - Preformatted

SELECT wevt_evtypcmb_fk ,asg_assgnmnt_fk ,per_person_fk ,per_person_mgr_fk ,per_person_mgr_prv_fk ,mgr_mngrsc_fk ,mgr_mngrsc_prv_fk ,org_organztn_fk ,org_organztn_prv_fk ,job_job_fk ,job_job_prv_fk ,grd_grade_fk ,grd_grade_prv_fk ,pos_position_fk ,pos_position_prv_fk ,geo_location_fk ,geo_location_prv_fk ,asgrsn_asgrsn_fk ,sprn_sprtnrsn_fk ,scat_spcatgry_fk ,ptyp_pertyp_fk ,prfm_perfband_fk ,pow_powband_fk ,cur_currency_fk ,time_month_snp_fk ,time_day_mnth_start_fk ,time_day_mnth_end_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 ,employee_ind ,contingent_ind FROM hri_mds_wrkfc_mnth_ct WITH READ ONLY

View Text - HTML Formatted

SELECT WEVT_EVTYPCMB_FK
, ASG_ASSGNMNT_FK
, PER_PERSON_FK
, PER_PERSON_MGR_FK
, PER_PERSON_MGR_PRV_FK
, MGR_MNGRSC_FK
, MGR_MNGRSC_PRV_FK
, ORG_ORGANZTN_FK
, ORG_ORGANZTN_PRV_FK
, JOB_JOB_FK
, JOB_JOB_PRV_FK
, GRD_GRADE_FK
, GRD_GRADE_PRV_FK
, POS_POSITION_FK
, POS_POSITION_PRV_FK
, GEO_LOCATION_FK
, GEO_LOCATION_PRV_FK
, ASGRSN_ASGRSN_FK
, SPRN_SPRTNRSN_FK
, SCAT_SPCATGRY_FK
, PTYP_PERTYP_FK
, PRFM_PERFBAND_FK
, POW_POWBAND_FK
, CUR_CURRENCY_FK
, TIME_MONTH_SNP_FK
, TIME_DAY_MNTH_START_FK
, TIME_DAY_MNTH_END_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
, EMPLOYEE_IND
, CONTINGENT_IND
FROM HRI_MDS_WRKFC_MNTH_CT WITH READ ONLY