View: IGS_AS_GPC_UNIT_SETS_V

Product:	IGS - Student System
Description:	Grading period for Unit Sets
Implementation/DBA Data:	APPS.IGS_AS_GPC_UNIT_SETS_V

View Text

SELECT GUS.ROWID ROW_ID
, GUS.GPC_UNIT_SET_ID GPC_UNIT_SET_ID
, GUS.GRADING_PERIOD_CD GRADING_PERIOD_CD
, LKUP.MEANING GRADING_PERIOD
, GUS.UNIT_SET_CD UNIT_SET_CD
, GUS.UNIT_SET_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, USET.TITLE UNIT_SET_TITLE
, GUS.CREATED_BY CREATED_BY
, GUS.CREATION_DATE CREATION_DATE
, GUS.LAST_UPDATED_BY LAST_UPDATED_BY
, GUS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GUS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_GPC_UNIT_SETS GUS
, IGS_LOOKUPS_VIEW LKUP
, IGS_EN_UNIT_SET USET
WHERE GUS.GRADING_PERIOD_CD=LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE='AS_GRADING_PERIOD'
AND GUS.UNIT_SET_CD=USET.UNIT_SET_CD
AND GUS.UNIT_SET_VERSION_NUMBER=USET.VERSION_NUMBER

Columns