Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CDI.ROWID ROW_ID
, CI.START_DT DSP_START_DT
, CI.END_DT DSP_END_DT
, CI.CAL_STATUS DSP_CAL_STATUS
, CAT.DESCRIPTION DSP_DESCRIPTION
, CDI.DT_ALIAS DT_ALIAS
, CDI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CDI.CAL_TYPE CAL_TYPE
, CDI.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CDI.ABSOLUTE_VAL ABSOLUTE_VAL
, CDI.LAST_UPDATED_BY LAST_UPDATED_BY
, CDI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CDI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CDI.CREATED_BY CREATED_BY
, CDI.CREATION_DATE CREATION_DATE
FROM IGS_CA_DA_INST CDI
, IGS_CA_INST CI
, IGS_CA_TYPE CAT
WHERE CI.CAL_TYPE = CDI.CAL_TYPE
AND CI.SEQUENCE_NUMBER = CDI.CI_SEQUENCE_NUMBER
AND CAT.CAL_TYPE = CI.CAL_TYPE