Product: | IGS - Student System |
---|---|
Description: | The view displays the grading schema details in the system |
Implementation/DBA Data: | APPS.IGS_AS_GRD_SCHEMA_V |
SELECT AGSC.ROWID
, AGSC.GRADING_SCHEMA_CD
, AGSC.VERSION_NUMBER
, AGSC.DESCRIPTION
, AGSC.START_DT
, AGSC.END_DT
, AGSC.COMMENTS
, AGSC.GRADING_SCHEMA_TYPE
, LKV.MEANING
, AGSC.CREATED_BY
, AGSC.CREATION_DATE
, AGSC.LAST_UPDATED_BY
, AGSC.LAST_UPDATE_DATE
, AGSC.LAST_UPDATE_LOGIN
, AGSC.ATTRIBUTE_CATEGORY
, AGSC.ATTRIBUTE1
, AGSC.ATTRIBUTE2
, AGSC.ATTRIBUTE3
, AGSC.ATTRIBUTE4
, AGSC.ATTRIBUTE5
, AGSC.ATTRIBUTE6
, AGSC.ATTRIBUTE7
, AGSC.ATTRIBUTE8
, AGSC.ATTRIBUTE9
, AGSC.ATTRIBUTE10
, AGSC.ATTRIBUTE11
, AGSC.ATTRIBUTE12
, AGSC.ATTRIBUTE13
, AGSC.ATTRIBUTE14
, AGSC.ATTRIBUTE15
, AGSC.ATTRIBUTE16
, AGSC.ATTRIBUTE17
, AGSC.ATTRIBUTE18
, AGSC.ATTRIBUTE19
, AGSC.ATTRIBUTE20
FROM IGS_AS_GRD_SCHEMA AGSC
, IGS_LOOKUPS_VIEW LKV
WHERE AGSC.GRADING_SCHEMA_TYPE = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'GRADING_SCHEMA_TYPES'