VIEW: APPS.HRBV_DISABILITIES_V

Source

View Text - Preformatted

SELECT DIS.EFFECTIVE_START_DATE, DIS.EFFECTIVE_END_DATE, DIS.REGISTRATION_DATE, DIS.REGISTRATION_EXP_DATE, DIS.CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_CATEGORY', DIS.CATEGORY), DIS.DESCRIPTION, DIS.DEGREE, DIS.QUOTA_FTE, DIS.REASON, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_REASON', DIS.REASON), 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, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_STATUS', DIS.STATUS), DIS.STATUS, '_DF:PER:PER_DISABILITIES:DIS', DIS.DISABILITY_ID, DIS.PERSON_ID, DIS.INCIDENT_ID, DIS.ORGANIZATION_ID, DIS.REGISTRATION_ID, DIS.LAST_UPDATE_DATE, DIS.LAST_UPDATED_BY, DIS.CREATED_BY, DIS.CREATION_DATE FROM PER_DISABILITIES_F DIS WITH READ ONLY

View Text - HTML Formatted

SELECT DIS.EFFECTIVE_START_DATE
, DIS.EFFECTIVE_END_DATE
, DIS.REGISTRATION_DATE
, DIS.REGISTRATION_EXP_DATE
, DIS.CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_CATEGORY'
, DIS.CATEGORY)
, DIS.DESCRIPTION
, DIS.DEGREE
, DIS.QUOTA_FTE
, DIS.REASON
, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_REASON'
, DIS.REASON)
, 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
, HR_BIS.BIS_DECODE_LOOKUP('DISABILITY_STATUS'
, DIS.STATUS)
, DIS.STATUS
, '_DF:PER:PER_DISABILITIES:DIS'
, DIS.DISABILITY_ID
, DIS.PERSON_ID
, DIS.INCIDENT_ID
, DIS.ORGANIZATION_ID
, DIS.REGISTRATION_ID
, DIS.LAST_UPDATE_DATE
, DIS.LAST_UPDATED_BY
, DIS.CREATED_BY
, DIS.CREATION_DATE
FROM PER_DISABILITIES_F DIS WITH READ ONLY