eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_CA_DA_INST_PAIR_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CDI.ROWID ROW_ID
, CDI.DT_ALIAS DT_ALIAS
, CDI.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, CDI.CAL_TYPE CAL_TYPE
, CDI.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CDI.RELATED_DT_ALIAS RELATED_DT_ALIAS
, CDI.RELATED_DAI_SEQUENCE_NUMBER RELATED_DAI_SEQUENCE_NUMBER
, CDI.RELATED_CAL_TYPE RELATED_CAL_TYPE
, CDI.RELATED_CI_SEQUENCE_NUMBER RELATED_CI_SEQUENCE_NUMBER
, CI.START_DT DSP_START_DT
, CI.END_DT DSP_END_DT
, CDI.CREATED_BY CREATED_BY
, CDI.CREATION_DATE CREATION_DATE
, CDI.LAST_UPDATED_BY LAST_UPDATED_BY
, CDI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CDI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_DA_INST_PAIR CDI
, IGS_CA_DA_INST DAI1
, IGS_CA_INST CI
WHERE DAI1.DT_ALIAS = CDI.RELATED_DT_ALIAS
AND DAI1.SEQUENCE_NUMBER = CDI.RELATED_DAI_SEQUENCE_NUMBER
AND DAI1.CAL_TYPE = CDI.RELATED_CAL_TYPE
AND DAI1.CI_SEQUENCE_NUMBER = CDI.RELATED_CI_SEQUENCE_NUMBER
AND ( DAI1.DT_ALIAS != CDI.DT_ALIAS OR DAI1.SEQUENCE_NUMBER != CDI.DAI_SEQUENCE_NUMBER OR DAI1.CAL_TYPE != CDI.CAL_TYPE OR DAI1.CI_SEQUENCE_NUMBER != CDI.CI_SEQUENCE_NUMBER)
AND CI.CAL_TYPE = DAI1.CAL_TYPE
AND CI.SEQUENCE_NUMBER = DAI1.CI_SEQUENCE_NUMBER

Columns

Name
ROW_ID
DT_ALIAS
DAI_SEQUENCE_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
RELATED_DT_ALIAS
RELATED_DAI_SEQUENCE_NUMBER
RELATED_CAL_TYPE
RELATED_CI_SEQUENCE_NUMBER
DSP_START_DT
DSP_END_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN