DBA Data[Home] [Help]

VIEW: APPS.IGS_AS_APPR_GRD_SCH_V

Source

View Text - Preformatted

SELECT apgs.rowid, apgs.unit_cd , apgs.version_number , apgs.assessment_type , apgs.grading_schema_cd , apgs.gs_version_number , grd.description , apgs.default_ind, apgs.closed_ind, apgs.created_by , apgs.creation_date , apgs.last_updated_by , apgs.last_update_date , apgs.last_update_login FROM igs_as_appr_grd_sch apgs, igs_as_grd_schema grd WHERE apgs.grading_schema_cd = grd.grading_schema_cd AND apgs.gs_version_number = grd.version_number
View Text - HTML Formatted

SELECT APGS.ROWID
, APGS.UNIT_CD
, APGS.VERSION_NUMBER
, APGS.ASSESSMENT_TYPE
, APGS.GRADING_SCHEMA_CD
, APGS.GS_VERSION_NUMBER
, GRD.DESCRIPTION
, APGS.DEFAULT_IND
, APGS.CLOSED_IND
, APGS.CREATED_BY
, APGS.CREATION_DATE
, APGS.LAST_UPDATED_BY
, APGS.LAST_UPDATE_DATE
, APGS.LAST_UPDATE_LOGIN
FROM IGS_AS_APPR_GRD_SCH APGS
, IGS_AS_GRD_SCHEMA GRD
WHERE APGS.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND APGS.GS_VERSION_NUMBER = GRD.VERSION_NUMBER