View: IGS_CA_INST_ALT_V

Product:	IGS - Student System
Description:	View of cal_instance table with alternate code as the primary key. Incorporates s_cal_cat and s_cal_status.
Implementation/DBA Data:	APPS.IGS_CA_INST_ALT_V

View Text

SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, CS.S_CAL_STATUS
, CI.ALTERNATE_CODE
, CAT.DESCRIPTION
, CAT.S_CAL_CAT
, CAT.ABBREVIATION
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN FROM IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CAT.CAL_TYPE = CI.CAL_TYPE
AND CS.CAL_STATUS = CI.CAL_STATUS

Columns