VIEW: APPS.IGS_PS_UNT_PRV_GRADE_V

Source

View Text - Preformatted

SELECT upg.rowid row_id, upg.unit_prev_grade_id unit_prev_grade_id, upg.unit_code unit_code, upg.unit_version_number unit_version_number, upg.grading_schema_code grading_schema_code, upg.grading_schema_version_number grading_schema_version_number, upg.grading_schema_value grading_schema_value, gsg.full_grade_name full_grade_name, upg.created_by created_by, upg.creation_date creation_date, upg.last_updated_by last_updated_by, upg.last_update_date last_update_date, upg.last_update_login last_update_login FROM igs_ps_unt_prv_grade upg, igs_as_grd_sch_grade gsg WHERE upg.grading_schema_code = gsg.grading_schema_cd AND upg.grading_schema_version_number = gsg.version_number AND upg.grading_schema_value = gsg.grade

View Text - HTML Formatted

SELECT UPG.ROWID ROW_ID
, UPG.UNIT_PREV_GRADE_ID UNIT_PREV_GRADE_ID
, UPG.UNIT_CODE UNIT_CODE
, UPG.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UPG.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, UPG.GRADING_SCHEMA_VERSION_NUMBER GRADING_SCHEMA_VERSION_NUMBER
, UPG.GRADING_SCHEMA_VALUE GRADING_SCHEMA_VALUE
, GSG.FULL_GRADE_NAME FULL_GRADE_NAME
, UPG.CREATED_BY CREATED_BY
, UPG.CREATION_DATE CREATION_DATE
, UPG.LAST_UPDATED_BY LAST_UPDATED_BY
, UPG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UPG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_PRV_GRADE UPG
, IGS_AS_GRD_SCH_GRADE GSG
WHERE UPG.GRADING_SCHEMA_CODE = GSG.GRADING_SCHEMA_CD
AND UPG.GRADING_SCHEMA_VERSION_NUMBER = GSG.VERSION_NUMBER
AND UPG.GRADING_SCHEMA_VALUE = GSG.GRADE