View: IGS_EN_EFFECTIVE_TERMS_V

Product:	IGS - Student System
Description:	View fetches the current term, one previous term and one next term for the academic calendar.
Implementation/DBA Data:	APPS.IGS_EN_EFFECTIVE_TERMS_V

View Text

SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_CURR_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_CURR_TERM(CT.CAL_TYPE)
, 1
, 6)) UNION ALL SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_PREV_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_PREV_TERM(CT.CAL_TYPE)
, 1
, 6)) UNION ALL SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, CT.CAL_TYPE ACAD_CAL_TYPE
, CT1.ABBREVIATION
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_TYPE CT1
WHERE CI.CAL_TYPE = CT1.CAL_TYPE
AND CI.CAL_TYPE = SUBSTR(IGS_EN_SPA_TERMS_API.GET_NEXT_TERM(CT.CAL_TYPE)
, 7)
AND CI.SEQUENCE_NUMBER = RTRIM(SUBSTR(IGS_EN_SPA_TERMS_API.GET_NEXT_TERM(CT.CAL_TYPE)
, 1
, 6))

Columns