VIEW: APPS.IGS_CA_DA_INST_TYPE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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