VIEW: APPS.IGS_CA_DA_INST_OFST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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