View: IGSBV_UNIT_GRADING_SCHEMAS

Product:	IGS - Student System
Description:	This is the base view, which describes the relation between units and grading schemas.
Implementation/DBA Data:	APPS.IGSBV_UNIT_GRADING_SCHEMAS

View Text

SELECT UN.UNIT_GRADING_SCHEMA_ID
, UN.UNIT_CODE
, UN.UNIT_VERSION_NUMBER
, UN.GRADING_SCHEMA_CODE
, UN.GRD_SCHM_VERSION_NUMBER
, UN.DEFAULT_FLAG
, UNV.TITLE
, GR.DESCRIPTION
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_GRD_SCHM UN
, IGS_AS_GRD_SCHEMA GR
, IGS_PS_UNIT_VER_ALL UNV
WHERE UN.UNIT_CODE = UNV.UNIT_CD
AND UN.UNIT_VERSION_NUMBER = UNV.VERSION_NUMBER
AND UN.GRADING_SCHEMA_CODE = GR.GRADING_SCHEMA_CD
AND UN.GRD_SCHM_VERSION_NUMBER = GR.VERSION_NUMBER WITH READ ONLY

Columns