VIEW: APPS.PER_ABSENCE_ATTENDANCES_V3

Source

View Text - Preformatted

SELECT ABA.ABSENCE_ATTENDANCE_ID , ABA.BUSINESS_GROUP_ID , ABA.ABSENCE_ATTENDANCE_TYPE_ID , ABA.ABS_ATTENDANCE_REASON_ID , ABA.PERSON_ID , ABA.AUTHORISING_PERSON_ID , ABA.REPLACEMENT_PERSON_ID , ABA.PERIOD_OF_INCAPACITY_ID , ABA.ABSENCE_DAYS , ABA.ABSENCE_HOURS , ABA.COMMENTS , ABA.DATE_END , ABA.DATE_NOTIFICATION , ABA.DATE_PROJECTED_END , ABA.DATE_PROJECTED_START , ABA.DATE_START , ABA.OCCURRENCE , ABA.SSP1_ISSUED , ABA.TIME_END , ABA.TIME_PROJECTED_END , ABA.TIME_PROJECTED_START , ABA.TIME_START , ABA.ATTRIBUTE_CATEGORY , ABA.ATTRIBUTE1 , ABA.ATTRIBUTE2 , ABA.ATTRIBUTE3 , ABA.ATTRIBUTE4 , ABA.ATTRIBUTE5 , ABA.ATTRIBUTE6 , ABA.ATTRIBUTE7 , ABA.ATTRIBUTE8 , ABA.ATTRIBUTE9 , ABA.ATTRIBUTE10 , ABA.ATTRIBUTE11 , ABA.ATTRIBUTE12 , ABA.ATTRIBUTE13 , ABA.ATTRIBUTE14 , ABA.ATTRIBUTE15 , ABA.ATTRIBUTE16 , ABA.ATTRIBUTE17 , ABA.ATTRIBUTE18 , ABA.ATTRIBUTE19 , ABA.ATTRIBUTE20 , ABA.LAST_UPDATE_DATE , ABA.LAST_UPDATED_BY , ABA.LAST_UPDATE_LOGIN , ABA.CREATED_BY , ABA.CREATION_DATE , ABT.NAME , PEP.FULL_NAME , PEP.EMPLOYEE_NUMBER , PEP2.FULL_NAME , PEP2.EMPLOYEE_NUMBER , REAS.MEANING , CAT.MEANING , ABA.ABSENCE_CASE_ID ,ABA.APPROVAL_STATUS ,ABA.CONFIRMED_UNTIL ,ABA.SOURCE ,ABA.ADVANCE_PAY FROM PER_ABSENCE_ATTENDANCES ABA, PER_ABS_ATTENDANCE_TYPES_VL ABT, PER_ABS_ATTENDANCE_REASONS ABR, PER_ALL_PEOPLE_F PEP, PER_ALL_PEOPLE_F PEP2, HR_LOOKUPS REAS, HR_LOOKUPS CAT WHERE ABA.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID AND ABA.AUTHORISING_PERSON_ID = PEP.PERSON_ID (+) AND ABA.REPLACEMENT_PERSON_ID = PEP2.PERSON_ID (+) AND ABA.ABS_ATTENDANCE_REASON_ID = ABR.ABS_ATTENDANCE_REASON_ID (+) AND ABR.NAME = REAS.LOOKUP_CODE (+) AND REAS.LOOKUP_TYPE (+) = 'ABSENCE_REASON' AND ABT.ABSENCE_CATEGORY = CAT.LOOKUP_CODE (+) AND CAT.LOOKUP_TYPE (+) = 'ABSENCE_CATEGORY' AND NVL(ABA.DATE_NOTIFICATION,ABA.DATE_START) BETWEEN PEP.EFFECTIVE_START_DATE(+) AND PEP.EFFECTIVE_END_DATE(+) AND NVL(ABA.DATE_NOTIFICATION,ABA.DATE_START) BETWEEN PEP2.EFFECTIVE_START_DATE(+) AND PEP2.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT ABA.ABSENCE_ATTENDANCE_ID
, ABA.BUSINESS_GROUP_ID
, ABA.ABSENCE_ATTENDANCE_TYPE_ID
, ABA.ABS_ATTENDANCE_REASON_ID
, ABA.PERSON_ID
, ABA.AUTHORISING_PERSON_ID
, ABA.REPLACEMENT_PERSON_ID
, ABA.PERIOD_OF_INCAPACITY_ID
, ABA.ABSENCE_DAYS
, ABA.ABSENCE_HOURS
, ABA.COMMENTS
, ABA.DATE_END
, ABA.DATE_NOTIFICATION
, ABA.DATE_PROJECTED_END
, ABA.DATE_PROJECTED_START
, ABA.DATE_START
, ABA.OCCURRENCE
, ABA.SSP1_ISSUED
, ABA.TIME_END
, ABA.TIME_PROJECTED_END
, ABA.TIME_PROJECTED_START
, ABA.TIME_START
, ABA.ATTRIBUTE_CATEGORY
, ABA.ATTRIBUTE1
, ABA.ATTRIBUTE2
, ABA.ATTRIBUTE3
, ABA.ATTRIBUTE4
, ABA.ATTRIBUTE5
, ABA.ATTRIBUTE6
, ABA.ATTRIBUTE7
, ABA.ATTRIBUTE8
, ABA.ATTRIBUTE9
, ABA.ATTRIBUTE10
, ABA.ATTRIBUTE11
, ABA.ATTRIBUTE12
, ABA.ATTRIBUTE13
, ABA.ATTRIBUTE14
, ABA.ATTRIBUTE15
, ABA.ATTRIBUTE16
, ABA.ATTRIBUTE17
, ABA.ATTRIBUTE18
, ABA.ATTRIBUTE19
, ABA.ATTRIBUTE20
, ABA.LAST_UPDATE_DATE
, ABA.LAST_UPDATED_BY
, ABA.LAST_UPDATE_LOGIN
, ABA.CREATED_BY
, ABA.CREATION_DATE
, ABT.NAME
, PEP.FULL_NAME
, PEP.EMPLOYEE_NUMBER
, PEP2.FULL_NAME
, PEP2.EMPLOYEE_NUMBER
, REAS.MEANING
, CAT.MEANING
, ABA.ABSENCE_CASE_ID
, ABA.APPROVAL_STATUS
, ABA.CONFIRMED_UNTIL
, ABA.SOURCE
, ABA.ADVANCE_PAY
FROM PER_ABSENCE_ATTENDANCES ABA
, PER_ABS_ATTENDANCE_TYPES_VL ABT
, PER_ABS_ATTENDANCE_REASONS ABR
, PER_ALL_PEOPLE_F PEP
, PER_ALL_PEOPLE_F PEP2
, HR_LOOKUPS REAS
, HR_LOOKUPS CAT
WHERE ABA.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABA.AUTHORISING_PERSON_ID = PEP.PERSON_ID (+)
AND ABA.REPLACEMENT_PERSON_ID = PEP2.PERSON_ID (+)
AND ABA.ABS_ATTENDANCE_REASON_ID = ABR.ABS_ATTENDANCE_REASON_ID (+)
AND ABR.NAME = REAS.LOOKUP_CODE (+)
AND REAS.LOOKUP_TYPE (+) = 'ABSENCE_REASON'
AND ABT.ABSENCE_CATEGORY = CAT.LOOKUP_CODE (+)
AND CAT.LOOKUP_TYPE (+) = 'ABSENCE_CATEGORY'
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN PEP.EFFECTIVE_START_DATE(+)
AND PEP.EFFECTIVE_END_DATE(+)
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN PEP2.EFFECTIVE_START_DATE(+)
AND PEP2.EFFECTIVE_END_DATE(+)