VIEW: APPS.PER_SUBJECTS_TAKEN_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.subjects_taken_id , B.start_date , B.major , B.subject_status , B.subject , T.grade_attained , B.end_date , B.qualification_id , B.object_version_number , B.attribute_category , B.attribute1 , B.attribute2 , B.attribute3 , B.attribute4 , B.attribute5 , B.attribute6 , B.attribute7 , B.attribute8 , B.attribute9 , B.attribute10 , B.attribute11 , B.attribute12 , B.attribute13 , B.attribute14 , B.attribute15 , B.attribute16 , B.attribute17 , B.attribute18 , B.attribute19 , B.attribute20 , B.last_update_date , B.last_updated_by , B.last_update_login , B.created_by , B.creation_date , B.sub_information_category , B.sub_information1 , B.sub_information2 , B.sub_information3 , B.sub_information4 , B.sub_information5 , B.sub_information6 , B.sub_information7 , B.sub_information8 , B.sub_information9 , B.sub_information10 , B.sub_information11 , B.sub_information12 , B.sub_information13 , B.sub_information14 , B.sub_information15 , B.sub_information16 , B.sub_information17 , B.sub_information18 , B.sub_information19 , B.sub_information20 from per_subjects_taken B , per_subjects_taken_tl T WHERE B.subjects_taken_id = T.subjects_taken_id and T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SUBJECTS_TAKEN_ID
, B.START_DATE
, B.MAJOR
, B.SUBJECT_STATUS
, B.SUBJECT
, T.GRADE_ATTAINED
, B.END_DATE
, B.QUALIFICATION_ID
, B.OBJECT_VERSION_NUMBER
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.SUB_INFORMATION_CATEGORY
, B.SUB_INFORMATION1
, B.SUB_INFORMATION2
, B.SUB_INFORMATION3
, B.SUB_INFORMATION4
, B.SUB_INFORMATION5
, B.SUB_INFORMATION6
, B.SUB_INFORMATION7
, B.SUB_INFORMATION8
, B.SUB_INFORMATION9
, B.SUB_INFORMATION10
, B.SUB_INFORMATION11
, B.SUB_INFORMATION12
, B.SUB_INFORMATION13
, B.SUB_INFORMATION14
, B.SUB_INFORMATION15
, B.SUB_INFORMATION16
, B.SUB_INFORMATION17
, B.SUB_INFORMATION18
, B.SUB_INFORMATION19
, B.SUB_INFORMATION20
FROM PER_SUBJECTS_TAKEN B
, PER_SUBJECTS_TAKEN_TL T
WHERE B.SUBJECTS_TAKEN_ID = T.SUBJECTS_TAKEN_ID
AND T.LANGUAGE = USERENV('LANG')