Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DAIO.ROWID ROW_ID
, DAIO.DT_ALIAS DT_ALIAS
, DAIO.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, DAIO.CAL_TYPE CAL_TYPE
, DAIO.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, DAIO.OFFSET_DT_ALIAS OFFSET_DT_ALIAS
, DAIO.OFFSET_DAI_SEQUENCE_NUMBER OFFSET_DAI_SEQUENCE_NUMBER
, DAIO.OFFSET_CAL_TYPE OFFSET_CAL_TYPE
, DAIO.OFFSET_CI_SEQUENCE_NUMBER OFFSET_CI_SEQUENCE_NUMBER
, DAIO.DAY_OFFSET DAY_OFFSET
, DAIO.WEEK_OFFSET WEEK_OFFSET
, DAIO.MONTH_OFFSET MONTH_OFFSET
, DAIO.YEAR_OFFSET YEAR_OFFSET
, DAIO.OFST_OVERRIDE OFST_OVERRIDE
, DAIO.LAST_UPDATED_BY LAST_UPDATED_BY
, DAIO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DAIO.CREATED_BY CREATED_BY
, DAIO.CREATION_DATE CREATION_DATE
, DAIO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DAI3.ABSOLUTE_VAL DSP_ABSOLUTE_VAL
, CI1.START_DT DSP_START_DT
, CI1.END_DT DSP_END_DT
FROM IGS_CA_DA_INST_OFST DAIO
, IGS_CA_DA_INST DAI3
, IGS_CA_INST CI1
WHERE DAI3.DT_ALIAS = DAIO.OFFSET_DT_ALIAS
AND DAI3.SEQUENCE_NUMBER = DAIO.OFFSET_DAI_SEQUENCE_NUMBER
AND (DAI3.CAL_TYPE = DAIO.OFFSET_CAL_TYPE OR (DAI3.CAL_TYPE IS NULL
AND DAIO.OFFSET_CAL_TYPE IS NULL ))
AND DAI3.CI_SEQUENCE_NUMBER = DAIO.OFFSET_CI_SEQUENCE_NUMBER
AND CI1.CAL_TYPE = DAI3.CAL_TYPE
AND CI1.SEQUENCE_NUMBER = DAI3.CI_SEQUENCE_NUMBER