VIEW: APPS.HRI_OBI_MDP_WRKFC_ORGH_TRN_V

Source

View Text - Preformatted

SELECT trn.org_sup_organztn_fk ,trn.per_person_fk ,trn.asg_assgnmnt_fk ,trn.ptyp_wrktyp_fk ,trn.time_day_evt_fk ,trn.transfer_in_ind ,trn.transfer_out_ind ,trn.transfer_in_ind * wevt.headcount headcount_trn_in ,trn.transfer_out_ind * wevt.headcount headcount_trn_out ,trn.transfer_in_ind * wevt.headcount * wevt.employee_ind headcount_trn_in_emp ,trn.transfer_out_ind * wevt.headcount * wevt.employee_ind headcount_trn_out_emp ,trn.transfer_in_ind * wevt.headcount * wevt.contingent_ind headcount_trn_in_cwk ,trn.transfer_out_ind * wevt.headcount * wevt.contingent_ind headcount_trn_out_cwk ,trn.transfer_in_ind * wevt.fte fte_trn_in ,trn.transfer_out_ind * wevt.fte fte_trn_out ,trn.transfer_in_ind * wevt.fte * wevt.employee_ind fte_trn_in_emp ,trn.transfer_out_ind * wevt.fte * wevt.employee_ind fte_trn_out_emp ,trn.transfer_in_ind * wevt.fte * wevt.contingent_ind fte_trn_in_cwk ,trn.transfer_out_ind * wevt.fte * wevt.contingent_ind fte_trn_out_cwk FROM hri_mdp_orgh_transfers_ct trn ,hri_mb_wrkfc_evt_ct wevt WHERE wevt.asg_assgnmnt_fk = trn.asg_assgnmnt_fk AND trn.time_day_evt_fk BETWEEN wevt.time_day_evt_fk AND wevt.time_day_evt_end_fk

View Text - HTML Formatted

SELECT TRN.ORG_SUP_ORGANZTN_FK
, TRN.PER_PERSON_FK
, TRN.ASG_ASSGNMNT_FK
, TRN.PTYP_WRKTYP_FK
, TRN.TIME_DAY_EVT_FK
, TRN.TRANSFER_IN_IND
, TRN.TRANSFER_OUT_IND
, TRN.TRANSFER_IN_IND * WEVT.HEADCOUNT HEADCOUNT_TRN_IN
, TRN.TRANSFER_OUT_IND * WEVT.HEADCOUNT HEADCOUNT_TRN_OUT
, TRN.TRANSFER_IN_IND * WEVT.HEADCOUNT * WEVT.EMPLOYEE_IND HEADCOUNT_TRN_IN_EMP
, TRN.TRANSFER_OUT_IND * WEVT.HEADCOUNT * WEVT.EMPLOYEE_IND HEADCOUNT_TRN_OUT_EMP
, TRN.TRANSFER_IN_IND * WEVT.HEADCOUNT * WEVT.CONTINGENT_IND HEADCOUNT_TRN_IN_CWK
, TRN.TRANSFER_OUT_IND * WEVT.HEADCOUNT * WEVT.CONTINGENT_IND HEADCOUNT_TRN_OUT_CWK
, TRN.TRANSFER_IN_IND * WEVT.FTE FTE_TRN_IN
, TRN.TRANSFER_OUT_IND * WEVT.FTE FTE_TRN_OUT
, TRN.TRANSFER_IN_IND * WEVT.FTE * WEVT.EMPLOYEE_IND FTE_TRN_IN_EMP
, TRN.TRANSFER_OUT_IND * WEVT.FTE * WEVT.EMPLOYEE_IND FTE_TRN_OUT_EMP
, TRN.TRANSFER_IN_IND * WEVT.FTE * WEVT.CONTINGENT_IND FTE_TRN_IN_CWK
, TRN.TRANSFER_OUT_IND * WEVT.FTE * WEVT.CONTINGENT_IND FTE_TRN_OUT_CWK
FROM HRI_MDP_ORGH_TRANSFERS_CT TRN
, HRI_MB_WRKFC_EVT_CT WEVT
WHERE WEVT.ASG_ASSGNMNT_FK = TRN.ASG_ASSGNMNT_FK
AND TRN.TIME_DAY_EVT_FK BETWEEN WEVT.TIME_DAY_EVT_FK
AND WEVT.TIME_DAY_EVT_END_FK