VIEW: APPS.IGS_PS_USEC_PRV_GRAD_V

Source

View Text - Preformatted

SELECT uspg.rowid row_id, uspg.unit_section_prev_grade_id unit_section_prev_grade_id, uspg.uoo_id uoo_id, uspg.grading_schema_code grading_schema_code, uspg.grading_schema_version_number grading_schema_version_number, uspg.grading_schema_value grading_schema_value, gsg.full_grade_name full_grade_name, uspg.created_by created_by, uspg.creation_date creation_date, uspg.last_updated_by last_updated_by, uspg.last_update_date last_update_date, uspg.last_update_login last_update_login FROM igs_ps_usec_prv_grad uspg, igs_as_grd_sch_grade gsg WHERE uspg.grading_schema_code = gsg.grading_schema_cd AND uspg.grading_schema_version_number = gsg.version_number AND uspg.grading_schema_value = gsg.grade

View Text - HTML Formatted

SELECT USPG.ROWID ROW_ID
, USPG.UNIT_SECTION_PREV_GRADE_ID UNIT_SECTION_PREV_GRADE_ID
, USPG.UOO_ID UOO_ID
, USPG.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, USPG.GRADING_SCHEMA_VERSION_NUMBER GRADING_SCHEMA_VERSION_NUMBER
, USPG.GRADING_SCHEMA_VALUE GRADING_SCHEMA_VALUE
, GSG.FULL_GRADE_NAME FULL_GRADE_NAME
, USPG.CREATED_BY CREATED_BY
, USPG.CREATION_DATE CREATION_DATE
, USPG.LAST_UPDATED_BY LAST_UPDATED_BY
, USPG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USPG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_PRV_GRAD USPG
, IGS_AS_GRD_SCH_GRADE GSG
WHERE USPG.GRADING_SCHEMA_CODE = GSG.GRADING_SCHEMA_CD
AND USPG.GRADING_SCHEMA_VERSION_NUMBER = GSG.VERSION_NUMBER
AND USPG.GRADING_SCHEMA_VALUE = GSG.GRADE