View: IGS_DA_CNFG_STAT_V

Product:	IGS - Student System
Description:	View is used for getting the GPA calculation setups.
Implementation/DBA Data:	APPS.IGS_DA_CNFG_STAT_V

View Text

SELECT DCS.ROWID ROW_ID
, DCS.REQUEST_TYPE_ID
, DCS.STAT_TYPE
, DCS.TIMEFRAME
, DCS.CREATION_DATE
, DCS.CREATED_BY
, DCS.LAST_UPDATE_LOGIN
, DCS.LAST_UPDATED_BY
, DCS.LAST_UPDATE_DATE
, PST.DESCRIPTION STAT_TYPE_MEANING
, LKUP.MEANING TIMEFRAME_MEANING
FROM IGS_DA_CNFG_STAT DCS
, IGS_PR_STAT_TYPE PST
, IGS_LOOKUP_VALUES LKUP
WHERE PST.STAT_TYPE = DCS.STAT_TYPE
AND DCS.TIMEFRAME = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'IGS_DA_STAT_TIME_FRAME'

Columns