View: PER_DISABILITIES_V

Product:	PER - Human Resources
Description:	Date effective view that brings back all disabilities for a person
Implementation/DBA Data:	APPS.PER_DISABILITIES_V

View Text

SELECT DIS.DISABILITY_ID
, DIS.EFFECTIVE_START_DATE
, DIS.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
, DIS.PERSON_ID
, DIS.INCIDENT_ID
, INC.INCIDENT_REFERENCE
, INC.INCIDENT_DATE
, MEA.MEDICAL_ASSESSMENT_ID
, MEA.CONSULTATION_DATE
, DIS.ORGANIZATION_ID
, ORG.NAME
, DIS.REGISTRATION_ID
, DIS.REGISTRATION_DATE
, DIS.REGISTRATION_EXP_DATE
, DIS.CATEGORY
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_CATEGORY'
, DIS.CATEGORY)
, 1
, 80)
, DIS.DESCRIPTION
, DIS.DEGREE
, DIS.STATUS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_STATUS'
, DIS.STATUS)
, 1
, 80)
, DIS.QUOTA_FTE
, DIS.REASON
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DISABILITY_REASON'
, DIS.REASON)
, 1
, 80)
, DIS.PRE_REGISTRATION_JOB
, DIS.WORK_RESTRICTION
, DIS.DIS_INFORMATION_CATEGORY
, DIS.DIS_INFORMATION1
, DIS.DIS_INFORMATION2
, DIS.DIS_INFORMATION3
, DIS.DIS_INFORMATION4
, DIS.DIS_INFORMATION5
, DIS.DIS_INFORMATION6
, DIS.DIS_INFORMATION7
, DIS.DIS_INFORMATION8
, DIS.DIS_INFORMATION9
, DIS.DIS_INFORMATION10
, DIS.DIS_INFORMATION11
, DIS.DIS_INFORMATION12
, DIS.DIS_INFORMATION13
, DIS.DIS_INFORMATION14
, DIS.DIS_INFORMATION15
, DIS.DIS_INFORMATION16
, DIS.DIS_INFORMATION17
, DIS.DIS_INFORMATION18
, DIS.DIS_INFORMATION19
, DIS.DIS_INFORMATION20
, DIS.DIS_INFORMATION21
, DIS.DIS_INFORMATION22
, DIS.DIS_INFORMATION23
, DIS.DIS_INFORMATION24
, DIS.DIS_INFORMATION25
, DIS.DIS_INFORMATION26
, DIS.DIS_INFORMATION27
, DIS.DIS_INFORMATION28
, DIS.DIS_INFORMATION29
, DIS.DIS_INFORMATION30
, DIS.ATTRIBUTE_CATEGORY
, DIS.ATTRIBUTE1
, DIS.ATTRIBUTE2
, DIS.ATTRIBUTE3
, DIS.ATTRIBUTE4
, DIS.ATTRIBUTE5
, DIS.ATTRIBUTE6
, DIS.ATTRIBUTE7
, DIS.ATTRIBUTE8
, DIS.ATTRIBUTE9
, DIS.ATTRIBUTE10
, DIS.ATTRIBUTE11
, DIS.ATTRIBUTE12
, DIS.ATTRIBUTE13
, DIS.ATTRIBUTE14
, DIS.ATTRIBUTE15
, DIS.ATTRIBUTE16
, DIS.ATTRIBUTE17
, DIS.ATTRIBUTE18
, DIS.ATTRIBUTE19
, DIS.ATTRIBUTE20
, DIS.ATTRIBUTE21
, DIS.ATTRIBUTE22
, DIS.ATTRIBUTE23
, DIS.ATTRIBUTE24
, DIS.ATTRIBUTE25
, DIS.ATTRIBUTE26
, DIS.ATTRIBUTE27
, DIS.ATTRIBUTE28
, DIS.ATTRIBUTE29
, DIS.ATTRIBUTE30
, DIS.LAST_UPDATE_DATE
, DIS.LAST_UPDATED_BY
, DIS.LAST_UPDATE_LOGIN
, DIS.CREATED_BY
, DIS.CREATION_DATE
, DIS.OBJECT_VERSION_NUMBER
FROM PER_DISABILITIES_F DIS
, PER_PEOPLE_F PER
, PER_WORK_INCIDENTS INC
, PER_MEDICAL_ASSESSMENTS MEA
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_SESSIONS SES
WHERE DIS.PERSON_ID = PER.PERSON_ID
AND DIS.INCIDENT_ID = INC.INCIDENT_ID (+)
AND DIS.DISABILITY_ID = MEA.DISABILITY_ID (+)
AND MEA.CONSULTATION_RESULT (+) = 'DI'
AND DIS.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN DIS.EFFECTIVE_START_DATE
AND DIS.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE

Columns