Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_MEDICAL_ASSESSMENTS_V |
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')