VIEW: APPS.PAY_AU_ASG_LEAVE_TAKEN_V

Source

View Text - Preformatted

SELECT row_id, assignment_id, time_period_id, element_reporting_name, start_date, end_date, absence_hours, payment, action_type from (SELECT * FROM pay_au_asg_leave_taken_v1 UNION SELECT * FROM pay_au_asg_leave_taken_v2 UNION SELECT * FROM pay_au_asg_leave_taken_v3 UNION ALL SELECT * FROM pay_au_asg_leave_taken_v4 UNION ALL SELECT * FROM pay_au_asg_leave_taken_v5 UNION SELECT * FROM pay_au_asg_leave_taken_v6 UNION ALL SELECT * FROM pay_au_asg_leave_taken_v7) order by element_reporting_name, start_date

View Text - HTML Formatted

SELECT ROW_ID
, ASSIGNMENT_ID
, TIME_PERIOD_ID
, ELEMENT_REPORTING_NAME
, START_DATE
, END_DATE
, ABSENCE_HOURS
, PAYMENT
, ACTION_TYPE
FROM (SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V1 UNION SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V2 UNION SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V3 UNION ALL SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V4 UNION ALL SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V5 UNION SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V6 UNION ALL SELECT *
FROM PAY_AU_ASG_LEAVE_TAKEN_V7) ORDER BY ELEMENT_REPORTING_NAME
, START_DATE