VIEW: APPS.HRBV_SUBJECTS_TAKEN_V

Source

View Text - Preformatted

SELECT SUB.START_DATE, SUB.MAJOR, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',SUB.MAJOR), SUB.SUBJECT_STATUS, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES',SUB.SUBJECT_STATUS), SUB.SUBJECT, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECTS',SUB.SUBJECT), SUB.GRADE_ATTAINED, SUB.END_DATE, SUB.SUB_INFORMATION_CATEGORY, SUB.SUB_INFORMATION1, SUB.SUB_INFORMATION2, SUB.SUB_INFORMATION3, SUB.SUB_INFORMATION4, SUB.SUB_INFORMATION5, SUB.SUB_INFORMATION6, SUB.SUB_INFORMATION7, SUB.SUB_INFORMATION8, SUB.SUB_INFORMATION9, SUB.SUB_INFORMATION10, SUB.SUB_INFORMATION11, SUB.SUB_INFORMATION12, SUB.SUB_INFORMATION13, SUB.SUB_INFORMATION14, SUB.SUB_INFORMATION15, SUB.SUB_INFORMATION16, SUB.SUB_INFORMATION17, SUB.SUB_INFORMATION18, SUB.SUB_INFORMATION19, SUB.SUB_INFORMATION20, '_DF:PER:PER_SUBJECTS_TAKEN:SUB', SUB.SUBJECTS_TAKEN_ID, SUB.QUALIFICATION_ID, SUB.LAST_UPDATE_DATE, SUB.LAST_UPDATED_BY, SUB.CREATED_BY, SUB.CREATION_DATE FROM PER_SUBJECTS_TAKEN SUB WITH READ ONLY

View Text - HTML Formatted

SELECT SUB.START_DATE
, SUB.MAJOR
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SUB.MAJOR)
, SUB.SUBJECT_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, SUB.SUBJECT_STATUS)
, SUB.SUBJECT
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECTS'
, SUB.SUBJECT)
, SUB.GRADE_ATTAINED
, SUB.END_DATE
, SUB.SUB_INFORMATION_CATEGORY
, SUB.SUB_INFORMATION1
, SUB.SUB_INFORMATION2
, SUB.SUB_INFORMATION3
, SUB.SUB_INFORMATION4
, SUB.SUB_INFORMATION5
, SUB.SUB_INFORMATION6
, SUB.SUB_INFORMATION7
, SUB.SUB_INFORMATION8
, SUB.SUB_INFORMATION9
, SUB.SUB_INFORMATION10
, SUB.SUB_INFORMATION11
, SUB.SUB_INFORMATION12
, SUB.SUB_INFORMATION13
, SUB.SUB_INFORMATION14
, SUB.SUB_INFORMATION15
, SUB.SUB_INFORMATION16
, SUB.SUB_INFORMATION17
, SUB.SUB_INFORMATION18
, SUB.SUB_INFORMATION19
, SUB.SUB_INFORMATION20
, '_DF:PER:PER_SUBJECTS_TAKEN:SUB'
, SUB.SUBJECTS_TAKEN_ID
, SUB.QUALIFICATION_ID
, SUB.LAST_UPDATE_DATE
, SUB.LAST_UPDATED_BY
, SUB.CREATED_BY
, SUB.CREATION_DATE
FROM PER_SUBJECTS_TAKEN SUB WITH READ ONLY