VIEW: APPS.PER_SUBJECTS_TAKEN_V

Source

View Text - Preformatted

SELECT SUB.ROWID ROW_ID , SUB.SUBJECTS_TAKEN_ID , SUB.START_DATE , SUB.MAJOR , HR_GENERAL.DECODE_LOOKUP('YES_NO',SUB.MAJOR) MAJOR_MEANING , SUB.SUBJECT_STATUS , HR_GENERAL.DECODE_LOOKUP('PER_SUBJECT_STATUSES', SUB.SUBJECT_STATUS) SUBJECT_STATUS_MEANING , SUB.SUBJECT , HR_GENERAL.DECODE_LOOKUP('PER_SUBJECTS',SUB.SUBJECT) SUBJECT_MEANING , SBT.GRADE_ATTAINED , SUB.END_DATE , SUB.QUALIFICATION_ID , SUB.OBJECT_VERSION_NUMBER , SUB.ATTRIBUTE_CATEGORY , SUB.ATTRIBUTE1 , SUB.ATTRIBUTE2 , SUB.ATTRIBUTE3 , SUB.ATTRIBUTE4 , SUB.ATTRIBUTE5 , SUB.ATTRIBUTE6 , SUB.ATTRIBUTE7 , SUB.ATTRIBUTE8 , SUB.ATTRIBUTE9 , SUB.ATTRIBUTE10 , SUB.ATTRIBUTE11 , SUB.ATTRIBUTE12 , SUB.ATTRIBUTE13 , SUB.ATTRIBUTE14 , SUB.ATTRIBUTE15 , SUB.ATTRIBUTE16 , SUB.ATTRIBUTE17 , SUB.ATTRIBUTE18 , SUB.ATTRIBUTE19 , SUB.ATTRIBUTE20 , 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 , SUB.LAST_UPDATE_DATE , SUB.LAST_UPDATED_BY , SUB.LAST_UPDATE_LOGIN , SUB.CREATED_BY , SUB.CREATION_DATE FROM PER_SUBJECTS_TAKEN SUB, PER_SUBJECTS_TAKEN_TL SBT WHERE SBT.SUBJECTS_TAKEN_ID = SUB.SUBJECTS_TAKEN_ID AND SBT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT SUB.ROWID ROW_ID
, SUB.SUBJECTS_TAKEN_ID
, SUB.START_DATE
, SUB.MAJOR
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SUB.MAJOR) MAJOR_MEANING
, SUB.SUBJECT_STATUS
, HR_GENERAL.DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, SUB.SUBJECT_STATUS) SUBJECT_STATUS_MEANING
, SUB.SUBJECT
, HR_GENERAL.DECODE_LOOKUP('PER_SUBJECTS'
, SUB.SUBJECT) SUBJECT_MEANING
, SBT.GRADE_ATTAINED
, SUB.END_DATE
, SUB.QUALIFICATION_ID
, SUB.OBJECT_VERSION_NUMBER
, SUB.ATTRIBUTE_CATEGORY
, SUB.ATTRIBUTE1
, SUB.ATTRIBUTE2
, SUB.ATTRIBUTE3
, SUB.ATTRIBUTE4
, SUB.ATTRIBUTE5
, SUB.ATTRIBUTE6
, SUB.ATTRIBUTE7
, SUB.ATTRIBUTE8
, SUB.ATTRIBUTE9
, SUB.ATTRIBUTE10
, SUB.ATTRIBUTE11
, SUB.ATTRIBUTE12
, SUB.ATTRIBUTE13
, SUB.ATTRIBUTE14
, SUB.ATTRIBUTE15
, SUB.ATTRIBUTE16
, SUB.ATTRIBUTE17
, SUB.ATTRIBUTE18
, SUB.ATTRIBUTE19
, SUB.ATTRIBUTE20
, 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
, SUB.LAST_UPDATE_DATE
, SUB.LAST_UPDATED_BY
, SUB.LAST_UPDATE_LOGIN
, SUB.CREATED_BY
, SUB.CREATION_DATE
FROM PER_SUBJECTS_TAKEN SUB
, PER_SUBJECTS_TAKEN_TL SBT
WHERE SBT.SUBJECTS_TAKEN_ID = SUB.SUBJECTS_TAKEN_ID
AND SBT.LANGUAGE = USERENV('LANG')