Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_SUBJECTS_TAKEN_V |
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')