Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT GT.ROWID ROW_ID
, GT.CONV_GS_TYPES_ID CONV_GS_TYPES_ID
, CC1.NAME FROM_GRADING_SCALE
, CC1.DESCRIPTION FROM_GRADING_SCALE_DESC
, GT.FROM_CODE_ID FROM_CODE_ID
, CC2.NAME TO_GRADING_SCALE
, CC2.DESCRIPTION TO_GRADING_SCALE_DESC
, GT.TO_CODE_ID TO_CODE_ID
, GT.CREATED_BY CREATED_BY
, GT.CREATION_DATE CREATION_DATE
, GT.LAST_UPDATED_BY LAST_UPDATED_BY
, GT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_CONV_GS_TYPES GT
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE CC1.CODE_ID = GT.FROM_CODE_ID AND CC2.CODE_ID = GT.TO_CODE_ID