VIEW: APPS.PER_MEDICAL_ASSESSMENTS_V

Source

View Text - Preformatted

SELECT MEA.MEDICAL_ASSESSMENT_ID , MEA.PERSON_ID , MEA.EXAMINER_NAME , MEA.ORGANIZATION_ID , ORGTL.NAME, MEA.CONSULTATION_DATE , MEA.CONSULTATION_TYPE , SUBSTR(hr_general.decode_lookup('CONSULTATION_TYPE', mea.consultation_type), 1, 80) CONSULTATION_TYPE_DESC, MEA.INCIDENT_ID , INC.INCIDENT_REFERENCE, INC.INCIDENT_DATE, MEA.CONSULTATION_RESULT , SUBSTR(hr_general.decode_lookup('CONSULTATION_RESULT', mea.consultation_result), 1, 80) CONSULTATION_RESULT_DESC, MEA.DISABILITY_ID , MEA.NEXT_CONSULTATION_DATE , MEA.DESCRIPTION , MEA.ATTRIBUTE_CATEGORY, MEA.ATTRIBUTE1 , MEA.ATTRIBUTE2 , MEA.ATTRIBUTE3 , MEA.ATTRIBUTE4 , MEA.ATTRIBUTE5 , MEA.ATTRIBUTE6 , MEA.ATTRIBUTE7 , MEA.ATTRIBUTE8 , MEA.ATTRIBUTE9 , MEA.ATTRIBUTE10 , MEA.ATTRIBUTE11 , MEA.ATTRIBUTE12 , MEA.ATTRIBUTE13 , MEA.ATTRIBUTE14 , MEA.ATTRIBUTE15 , MEA.ATTRIBUTE16 , MEA.ATTRIBUTE17 , MEA.ATTRIBUTE18 , MEA.ATTRIBUTE19 , MEA.ATTRIBUTE20 , MEA.ATTRIBUTE21 , MEA.ATTRIBUTE22 , MEA.ATTRIBUTE23 , MEA.ATTRIBUTE24 , MEA.ATTRIBUTE25 , MEA.ATTRIBUTE26 , MEA.ATTRIBUTE27 , MEA.ATTRIBUTE28 , MEA.ATTRIBUTE29 , MEA.ATTRIBUTE30 , MEA.MEA_INFORMATION_CATEGORY , MEA.MEA_INFORMATION1 , MEA.MEA_INFORMATION2 , MEA.MEA_INFORMATION3 , MEA.MEA_INFORMATION4 , MEA.MEA_INFORMATION5 , MEA.MEA_INFORMATION6 , MEA.MEA_INFORMATION7 , MEA.MEA_INFORMATION8 , MEA.MEA_INFORMATION9 , MEA.MEA_INFORMATION10 , MEA.MEA_INFORMATION11 , MEA.MEA_INFORMATION12 , MEA.MEA_INFORMATION13 , MEA.MEA_INFORMATION14 , MEA.MEA_INFORMATION15 , MEA.MEA_INFORMATION16 , MEA.MEA_INFORMATION17 , MEA.MEA_INFORMATION18 , MEA.MEA_INFORMATION19 , MEA.MEA_INFORMATION20 , MEA.MEA_INFORMATION21 , MEA.MEA_INFORMATION22 , MEA.MEA_INFORMATION23 , MEA.MEA_INFORMATION24 , MEA.MEA_INFORMATION25 , MEA.MEA_INFORMATION26 , MEA.MEA_INFORMATION27 , MEA.MEA_INFORMATION28 , MEA.MEA_INFORMATION29 , MEA.MEA_INFORMATION30 , MEA.LAST_UPDATE_DATE , MEA.LAST_UPDATED_BY , MEA.LAST_UPDATE_LOGIN , MEA.CREATED_BY , MEA.CREATION_DATE , MEA.OBJECT_VERSION_NUMBER FROM per_medical_assessments mea, per_work_incidents inc, HR_ALL_ORGANIZATION_UNITS ORG, HR_ALL_ORGANIZATION_UNITS_TL ORGTL WHERE inc.incident_id (+) = mea.incident_id AND ORG.ORGANIZATION_ID (+) = MEA.ORGANIZATION_ID AND ORGTL.organization_id (+) = ORG.organization_id AND ORGTL.language (+) = userenv('LANG')

View Text - HTML Formatted

SELECT MEA.MEDICAL_ASSESSMENT_ID
, MEA.PERSON_ID
, MEA.EXAMINER_NAME
, MEA.ORGANIZATION_ID
, ORGTL.NAME
, MEA.CONSULTATION_DATE
, MEA.CONSULTATION_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CONSULTATION_TYPE'
, MEA.CONSULTATION_TYPE)
, 1
, 80) CONSULTATION_TYPE_DESC
, MEA.INCIDENT_ID
, INC.INCIDENT_REFERENCE
, INC.INCIDENT_DATE
, MEA.CONSULTATION_RESULT
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CONSULTATION_RESULT'
, MEA.CONSULTATION_RESULT)
, 1
, 80) CONSULTATION_RESULT_DESC
, MEA.DISABILITY_ID
, MEA.NEXT_CONSULTATION_DATE
, MEA.DESCRIPTION
, MEA.ATTRIBUTE_CATEGORY
, MEA.ATTRIBUTE1
, MEA.ATTRIBUTE2
, MEA.ATTRIBUTE3
, MEA.ATTRIBUTE4
, MEA.ATTRIBUTE5
, MEA.ATTRIBUTE6
, MEA.ATTRIBUTE7
, MEA.ATTRIBUTE8
, MEA.ATTRIBUTE9
, MEA.ATTRIBUTE10
, MEA.ATTRIBUTE11
, MEA.ATTRIBUTE12
, MEA.ATTRIBUTE13
, MEA.ATTRIBUTE14
, MEA.ATTRIBUTE15
, MEA.ATTRIBUTE16
, MEA.ATTRIBUTE17
, MEA.ATTRIBUTE18
, MEA.ATTRIBUTE19
, MEA.ATTRIBUTE20
, MEA.ATTRIBUTE21
, MEA.ATTRIBUTE22
, MEA.ATTRIBUTE23
, MEA.ATTRIBUTE24
, MEA.ATTRIBUTE25
, MEA.ATTRIBUTE26
, MEA.ATTRIBUTE27
, MEA.ATTRIBUTE28
, MEA.ATTRIBUTE29
, MEA.ATTRIBUTE30
, MEA.MEA_INFORMATION_CATEGORY
, MEA.MEA_INFORMATION1
, MEA.MEA_INFORMATION2
, MEA.MEA_INFORMATION3
, MEA.MEA_INFORMATION4
, MEA.MEA_INFORMATION5
, MEA.MEA_INFORMATION6
, MEA.MEA_INFORMATION7
, MEA.MEA_INFORMATION8
, MEA.MEA_INFORMATION9
, MEA.MEA_INFORMATION10
, MEA.MEA_INFORMATION11
, MEA.MEA_INFORMATION12
, MEA.MEA_INFORMATION13
, MEA.MEA_INFORMATION14
, MEA.MEA_INFORMATION15
, MEA.MEA_INFORMATION16
, MEA.MEA_INFORMATION17
, MEA.MEA_INFORMATION18
, MEA.MEA_INFORMATION19
, MEA.MEA_INFORMATION20
, MEA.MEA_INFORMATION21
, MEA.MEA_INFORMATION22
, MEA.MEA_INFORMATION23
, MEA.MEA_INFORMATION24
, MEA.MEA_INFORMATION25
, MEA.MEA_INFORMATION26
, MEA.MEA_INFORMATION27
, MEA.MEA_INFORMATION28
, MEA.MEA_INFORMATION29
, MEA.MEA_INFORMATION30
, MEA.LAST_UPDATE_DATE
, MEA.LAST_UPDATED_BY
, MEA.LAST_UPDATE_LOGIN
, MEA.CREATED_BY
, MEA.CREATION_DATE
, MEA.OBJECT_VERSION_NUMBER
FROM PER_MEDICAL_ASSESSMENTS MEA
, PER_WORK_INCIDENTS INC
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
WHERE INC.INCIDENT_ID (+) = MEA.INCIDENT_ID
AND ORG.ORGANIZATION_ID (+) = MEA.ORGANIZATION_ID
AND ORGTL.ORGANIZATION_ID (+) = ORG.ORGANIZATION_ID
AND ORGTL.LANGUAGE (+) = USERENV('LANG')