VIEW: APPS.PAY_NZ_ASG_LEAVE_TAKEN_V

Source

View Text - Preformatted

SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_DURATION","PAYMENT","DATE_EARNED" FROM pay_nz_asg_leave_taken_v1 UNION SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_DURATION","PAYMENT","DATE_EARNED" FROM pay_nz_asg_leave_taken_v2 UNION SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_DURATION","PAYMENT","DATE_EARNED" FROM pay_nz_asg_leave_taken_v3 UNION ALL SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_DURATION","PAYMENT","DATE_EARNED" FROM pay_nz_asg_leave_taken_v4

View Text - HTML Formatted

SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V1 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V2 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V3 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V4