VIEW: APPS.HRI_MD_WAC_GAIN_V

Source

View Text - Preformatted

SELECT wge.row_indicator , wge.gain_hire_indicator , wge.gain_asg_indicator , wge.gain_lta_indicator , 0 gain_org_indicator , 0 gain_sup_indicator , 0 gain_pos_indicator , 0 gain_prim_asg_indicator , wge.active_indicator active_indicator , wge.lta_indicator , wge.emp_indicator , wge.cwk_indicator , wge.prim_asg_indicator , wge.measure_calc_date , wge.event_date , wge.hire_reason_code , wge.change_reason_code , wge.person_id , wge.assignment_from_id , wge.business_group_from_id , wge.organization_from_id , wge.supervisor_person_from_id , wge.location_from_id , wge.job_from_id , wge.grade_from_id , wge.position_from_id , wge.primary_from_flag_code , wge.assignment_type_from_code , wge.assignment_status_type_from_id , wge.per_system_status_from_code , wge.pay_system_status_from_code , wge.assignment_to_id , wge.business_group_to_id , wge.organization_to_id , wge.supervisor_person_to_id , wge.location_to_id , wge.job_to_id , wge.grade_to_id , wge.position_to_id , wge.primary_to_flag_code , wge.assignment_type_to_code , wge.assignment_status_type_to_id , wge.per_system_status_to_code , wge.pay_system_status_to_code , wge.last_change_date , wge.hr_security_flag_code , wge.bg_security_flag_code FROM hri_mb_wac_gain_entrprs_v wge UNION ALL SELECT wca.row_indicator , 0 gain_hire_indicator , 0 gain_asg_indicator , 0 gain_lta_indicator , wca.change_org_indicator , wca.change_sup_indicator , wca.change_pos_indicator , wca.change_prim_asg_indicator , wca.active_to_indicator active_indicator , wca.lta_to_indicator lta_indicator , wca.emp_to_indicator emp_indicator , wca.cwk_to_indicator cwk_indicator , wca.prim_asg_to_indicator prim_asg_indicator , wca.measure_calc_date , wca.event_date , 'NA_EDW' hire_reason_code , wca.change_reason_code , wca.person_id , wca.assignment_from_id , wca.business_group_from_id , wca.organization_from_id , wca.supervisor_person_from_id , wca.location_from_id , wca.job_from_id , wca.grade_from_id , wca.position_from_id , wca.primary_from_flag_code , wca.assignment_type_from_code , wca.assignment_status_type_from_id , wca.per_system_status_from_code , wca.pay_system_status_from_code , wca.assignment_to_id , wca.business_group_to_id , wca.organization_to_id , wca.supervisor_person_to_id , wca.location_to_id , wca.job_to_id , wca.grade_to_id , wca.position_to_id , wca.primary_to_flag_code , wca.assignment_type_to_code , wca.assignment_status_type_to_id , wca.per_system_status_to_code , wca.pay_system_status_to_code , wca.last_change_date , wca.hr_security_flag_code , wca.bg_security_flag_code FROM hri_mb_wac_change_asg_v wca WITH READ ONLY

View Text - HTML Formatted

SELECT WGE.ROW_INDICATOR
, WGE.GAIN_HIRE_INDICATOR
, WGE.GAIN_ASG_INDICATOR
, WGE.GAIN_LTA_INDICATOR
, 0 GAIN_ORG_INDICATOR
, 0 GAIN_SUP_INDICATOR
, 0 GAIN_POS_INDICATOR
, 0 GAIN_PRIM_ASG_INDICATOR
, WGE.ACTIVE_INDICATOR ACTIVE_INDICATOR
, WGE.LTA_INDICATOR
, WGE.EMP_INDICATOR
, WGE.CWK_INDICATOR
, WGE.PRIM_ASG_INDICATOR
, WGE.MEASURE_CALC_DATE
, WGE.EVENT_DATE
, WGE.HIRE_REASON_CODE
, WGE.CHANGE_REASON_CODE
, WGE.PERSON_ID
, WGE.ASSIGNMENT_FROM_ID
, WGE.BUSINESS_GROUP_FROM_ID
, WGE.ORGANIZATION_FROM_ID
, WGE.SUPERVISOR_PERSON_FROM_ID
, WGE.LOCATION_FROM_ID
, WGE.JOB_FROM_ID
, WGE.GRADE_FROM_ID
, WGE.POSITION_FROM_ID
, WGE.PRIMARY_FROM_FLAG_CODE
, WGE.ASSIGNMENT_TYPE_FROM_CODE
, WGE.ASSIGNMENT_STATUS_TYPE_FROM_ID
, WGE.PER_SYSTEM_STATUS_FROM_CODE
, WGE.PAY_SYSTEM_STATUS_FROM_CODE
, WGE.ASSIGNMENT_TO_ID
, WGE.BUSINESS_GROUP_TO_ID
, WGE.ORGANIZATION_TO_ID
, WGE.SUPERVISOR_PERSON_TO_ID
, WGE.LOCATION_TO_ID
, WGE.JOB_TO_ID
, WGE.GRADE_TO_ID
, WGE.POSITION_TO_ID
, WGE.PRIMARY_TO_FLAG_CODE
, WGE.ASSIGNMENT_TYPE_TO_CODE
, WGE.ASSIGNMENT_STATUS_TYPE_TO_ID
, WGE.PER_SYSTEM_STATUS_TO_CODE
, WGE.PAY_SYSTEM_STATUS_TO_CODE
, WGE.LAST_CHANGE_DATE
, WGE.HR_SECURITY_FLAG_CODE
, WGE.BG_SECURITY_FLAG_CODE
FROM HRI_MB_WAC_GAIN_ENTRPRS_V WGE UNION ALL SELECT WCA.ROW_INDICATOR
, 0 GAIN_HIRE_INDICATOR
, 0 GAIN_ASG_INDICATOR
, 0 GAIN_LTA_INDICATOR
, WCA.CHANGE_ORG_INDICATOR
, WCA.CHANGE_SUP_INDICATOR
, WCA.CHANGE_POS_INDICATOR
, WCA.CHANGE_PRIM_ASG_INDICATOR
, WCA.ACTIVE_TO_INDICATOR ACTIVE_INDICATOR
, WCA.LTA_TO_INDICATOR LTA_INDICATOR
, WCA.EMP_TO_INDICATOR EMP_INDICATOR
, WCA.CWK_TO_INDICATOR CWK_INDICATOR
, WCA.PRIM_ASG_TO_INDICATOR PRIM_ASG_INDICATOR
, WCA.MEASURE_CALC_DATE
, WCA.EVENT_DATE
, 'NA_EDW' HIRE_REASON_CODE
, WCA.CHANGE_REASON_CODE
, WCA.PERSON_ID
, WCA.ASSIGNMENT_FROM_ID
, WCA.BUSINESS_GROUP_FROM_ID
, WCA.ORGANIZATION_FROM_ID
, WCA.SUPERVISOR_PERSON_FROM_ID
, WCA.LOCATION_FROM_ID
, WCA.JOB_FROM_ID
, WCA.GRADE_FROM_ID
, WCA.POSITION_FROM_ID
, WCA.PRIMARY_FROM_FLAG_CODE
, WCA.ASSIGNMENT_TYPE_FROM_CODE
, WCA.ASSIGNMENT_STATUS_TYPE_FROM_ID
, WCA.PER_SYSTEM_STATUS_FROM_CODE
, WCA.PAY_SYSTEM_STATUS_FROM_CODE
, WCA.ASSIGNMENT_TO_ID
, WCA.BUSINESS_GROUP_TO_ID
, WCA.ORGANIZATION_TO_ID
, WCA.SUPERVISOR_PERSON_TO_ID
, WCA.LOCATION_TO_ID
, WCA.JOB_TO_ID
, WCA.GRADE_TO_ID
, WCA.POSITION_TO_ID
, WCA.PRIMARY_TO_FLAG_CODE
, WCA.ASSIGNMENT_TYPE_TO_CODE
, WCA.ASSIGNMENT_STATUS_TYPE_TO_ID
, WCA.PER_SYSTEM_STATUS_TO_CODE
, WCA.PAY_SYSTEM_STATUS_TO_CODE
, WCA.LAST_CHANGE_DATE
, WCA.HR_SECURITY_FLAG_CODE
, WCA.BG_SECURITY_FLAG_CODE
FROM HRI_MB_WAC_CHANGE_ASG_V WCA WITH READ ONLY