VIEW: APPS.HRI_OBI_MDP_WRKFC_MGRH_TRN_V

Source

View Text - Preformatted

SELECT trn.mgr_sup_person_fk ,trn.mgr_sup_mngrsc_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 ,DECODE(trn.direct_ind, 0, 'N', 'Y') sup_direct_mngr_flag ,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_mgrh_transfers_ct trn ,hri_mb_wrkfc_evt_ct wevt WHERE wevt.asg_assgnmnt_fk = trn.asg_assgnmnt_fk AND trn.direct_record_ind = 0 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.MGR_SUP_PERSON_FK
, TRN.MGR_SUP_MNGRSC_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
, DECODE(TRN.DIRECT_IND
, 0
, 'N'
, 'Y') SUP_DIRECT_MNGR_FLAG
, 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_MGRH_TRANSFERS_CT TRN
, HRI_MB_WRKFC_EVT_CT WEVT
WHERE WEVT.ASG_ASSGNMNT_FK = TRN.ASG_ASSGNMNT_FK
AND TRN.DIRECT_RECORD_IND = 0
AND TRN.TIME_DAY_EVT_FK BETWEEN WEVT.TIME_DAY_EVT_FK
AND WEVT.TIME_DAY_EVT_END_FK