VIEW: APPS.IGS_PS_UNIT_GRD_SCHM_V

Source

View Text - Preformatted

SELECT ugs.rowid row_id, ugs.unit_grading_schema_id unit_grading_schema_id, ugs.unit_code unit_code, ugs.unit_version_number unit_version_number, ugs.grading_schema_code grading_schema_code, ugs.grd_schm_version_number grd_schm_version_number, ugs.default_flag default_flag, gs.description grd_schm_description, ugs.created_by created_by, ugs.creation_date creation_date, ugs.last_updated_by last_updated_by, ugs.last_update_date last_update_date, ugs.last_update_login last_update_login FROM igs_ps_unit_grd_schm ugs, igs_as_grd_schema gs WHERE ugs.grading_schema_code = gs.grading_schema_cd AND ugs.grd_schm_version_number = gs.version_number

View Text - HTML Formatted

SELECT UGS.ROWID ROW_ID
, UGS.UNIT_GRADING_SCHEMA_ID UNIT_GRADING_SCHEMA_ID
, UGS.UNIT_CODE UNIT_CODE
, UGS.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UGS.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, UGS.GRD_SCHM_VERSION_NUMBER GRD_SCHM_VERSION_NUMBER
, UGS.DEFAULT_FLAG DEFAULT_FLAG
, GS.DESCRIPTION GRD_SCHM_DESCRIPTION
, UGS.CREATED_BY CREATED_BY
, UGS.CREATION_DATE CREATION_DATE
, UGS.LAST_UPDATED_BY LAST_UPDATED_BY
, UGS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UGS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_GRD_SCHM UGS
, IGS_AS_GRD_SCHEMA GS
WHERE UGS.GRADING_SCHEMA_CODE = GS.GRADING_SCHEMA_CD
AND UGS.GRD_SCHM_VERSION_NUMBER = GS.VERSION_NUMBER