VIEW: APPS.IGS_EN_EFFECTIVE_TERMS_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))