VIEW: APPS.PER_DISABILITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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