View: HRFV_ABSENCES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_ABSENCES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PPF.FULL_NAME PERSON_NAME
, ATT.DATE_START DATE_START
, ATT.TIME_START TIME_START
, ATT.DATE_END DATE_END
, ATT.TIME_END TIME_END
, ATT.ABSENCE_DAYS ABSENCE_DAYS
, ATT.ABSENCE_HOURS ABSENCE_HOURS
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, TYP.NAME ABSENCE_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ABSENCE_REASON'
, REA.NAME) ABSENCE_REASON
, HR_BIS.BIS_DECODE_LOOKUP('ABSENCE_CATEGORY'
, TYP.ABSENCE_CATEGORY) ABSENCE_CATEGORY
, AUT.FULL_NAME AUTHORISING_PERSON_NAME
, REP.FULL_NAME REPLACEMENT_PERSON_NAME
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_ABSENCE_ATTENDANCES:ATT'
, '_DF:PER:PER_ABSENCE_ATTENDANCE_TYPES:TYP'
, REA.ABS_ATTENDANCE_REASON_ID ABS_ATTENDANCE_REASON_ID
, ATT.ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID
, TYP.ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
, ASS.ASSIGNMENT_ID ASSIGNMENT_ID
, ATT.AUTHORISING_PERSON_ID AUTHORISING_PERSON_ID
, ATT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASS.PERSON_ID PERSON_ID
, ATT.REPLACEMENT_PERSON_ID REPLACEMENT_PERSON_ID
FROM HR_LOCATIONS_ALL_TL LOCT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, PER_ABS_ATTENDANCE_REASONS REA
, PER_ABSENCE_ATTENDANCE_TYPES TYP
, PER_ALL_PEOPLE_F PPF
, PER_ALL_PEOPLE_F AUT
, PER_ALL_PEOPLE_F REP
, PER_ASSIGNMENTS_F ASS
, PER_ABSENCE_ATTENDANCES ATT
WHERE ATT.ABSENCE_ATTENDANCE_TYPE_ID = TYP.ABSENCE_ATTENDANCE_TYPE_ID
AND ATT.ABS_ATTENDANCE_REASON_ID = REA.ABS_ATTENDANCE_REASON_ID (+)
AND ATT.PERSON_ID = PPF.PERSON_ID
AND ATT.DATE_START BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND ATT.AUTHORISING_PERSON_ID = AUT.PERSON_ID(+)
AND ATT.DATE_START BETWEEN AUT.EFFECTIVE_START_DATE(+)
AND AUT.EFFECTIVE_END_DATE(+)
AND ATT.REPLACEMENT_PERSON_ID = REP.PERSON_ID(+)
AND ATT.DATE_START BETWEEN REP.EFFECTIVE_START_DATE(+)
AND REP.EFFECTIVE_END_DATE(+)
AND ATT.DATE_START IS NOT NULL
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND ASS.JOB_ID = JOB.JOB_ID(+)
AND ASS.POSITION_ID = POS.POSITION_ID(+)
AND ASS.GRADE_ID = GRD.GRADE_ID(+)
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ATT.DATE_START BETWEEN ASS.EFFECTIVE_START_DATE
AND ASS.EFFECTIVE_END_DATE
AND ASS.PERSON_ID = ATT.PERSON_ID
AND ASS.ASSIGNMENT_TYPE = 'E'
AND ASS.PRIMARY_FLAG = 'Y'
AND ASS.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ATT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ATT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns