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_tl.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 ,hr_all_organization_units_tl org_tl 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 AND org.organization_id = org_tl.organization_id (+) AND org_tl.language(+) = userenv('LANG')

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_TL.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
, HR_ALL_ORGANIZATION_UNITS_TL ORG_TL
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
AND ORG.ORGANIZATION_ID = ORG_TL.ORGANIZATION_ID (+)
AND ORG_TL.LANGUAGE(+) = USERENV('LANG')