View: IGS_EN_INST_WLST_OPT_V

Product:	IGS - Student System
Description:	This view incorporates the waitlist options based on the calendar type, institution wait list allowed indicator so that appropriate wait list options are applied to a calendar instance.
Implementation/DBA Data:	APPS.IGS_EN_INST_WLST_OPT_V

View Text

SELECT IWO.ROWID ROW_ID
, IWO.INST_WAITLIST_ID INST_WAITLIST_ID
, IWO.CAL_TYPE CAL_TYPE
, NULL SEQUENCE_NUMBER
, CT.DESCRIPTION
, NULL
, NULL
, NULL
, IWO.WAITLIST_ALWD WAITLIST_ALWD
, IWO.SMLNES_WAITLIST_ALWD SMLNES_WAITLIST_ALWD
, IWO.CREATED_BY CREATED_BY
, IWO.CREATION_DATE CREATION_DATE
, IWO.LAST_UPDATED_BY LAST_UPDATED_BY
, IWO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IWO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CT
, IGS_EN_INST_WLST_OPT IWO
WHERE IWO.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'

Columns