VIEW: APPS.HRBV_MEDICAL_ASSESSMENTS_V

Source

View Text - Preformatted

SELECT MEA.EXAMINER_NAME, MEA.CONSULTATION_DATE, MEA.CONSULTATION_TYPE, HR_BIS.BIS_DECODE_LOOKUP('CONSULTATION_TYPE',MEA.CONSULTATION_TYPE), MEA.CONSULTATION_RESULT, HR_BIS.BIS_DECODE_LOOKUP('CONSULTATION_RESULT',MEA.CONSULTATION_RESULT), MEA.NEXT_CONSULTATION_DATE, MEA.DESCRIPTION, 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, '_DF:PER:PER_MEDICAL_ASSESSMENTS:MEA', MEA.MEDICAL_ASSESSMENT_ID, MEA.PERSON_ID, MEA.ORGANIZATION_ID, MEA.DISABILITY_ID, MEA.INCIDENT_ID, MEA.LAST_UPDATE_DATE, MEA.LAST_UPDATED_BY, MEA.CREATED_BY, MEA.CREATION_DATE FROM PER_MEDICAL_ASSESSMENTS MEA WITH READ ONLY

View Text - HTML Formatted

SELECT MEA.EXAMINER_NAME
, MEA.CONSULTATION_DATE
, MEA.CONSULTATION_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('CONSULTATION_TYPE'
, MEA.CONSULTATION_TYPE)
, MEA.CONSULTATION_RESULT
, HR_BIS.BIS_DECODE_LOOKUP('CONSULTATION_RESULT'
, MEA.CONSULTATION_RESULT)
, MEA.NEXT_CONSULTATION_DATE
, MEA.DESCRIPTION
, 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
, '_DF:PER:PER_MEDICAL_ASSESSMENTS:MEA'
, MEA.MEDICAL_ASSESSMENT_ID
, MEA.PERSON_ID
, MEA.ORGANIZATION_ID
, MEA.DISABILITY_ID
, MEA.INCIDENT_ID
, MEA.LAST_UPDATE_DATE
, MEA.LAST_UPDATED_BY
, MEA.CREATED_BY
, MEA.CREATION_DATE
FROM PER_MEDICAL_ASSESSMENTS MEA WITH READ ONLY