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.

VIEW: APPS.IGS_CA_TEACH_TO_LOAD_V

Source

View Text - Preformatted


SELECT AP1.CAL_TYPE LOAD_CAL_TYPE , AP1.CI_SEQUENCE_NUMBER LOAD_CI_SEQUENCE_NUMBER, CI.START_DT LOAD_START_DT, CI.END_DT LOAD_END_DT, CI.ALTERNATE_CODE LOAD_ALTERNATE_CODE, CI.description, CI1.CAL_TYPE TEACH_CAL_TYPE, CI1.SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER, CI1.START_DT TEACH_START_DT, CI1.END_DT TEACH_END_DT , CI1.ALTERNATE_CODE TEACH_ALTERNATE_CODE , CI1.description FROM IGS_ST_DFT_LOAD_APPO AP1, IGS_CA_INST CI1, IGS_CA_INST CI WHERE CI.CAL_TYPE = AP1.CAL_TYPE AND CI. SEQUENCE_NUMBER = AP1.CI_SEQUENCE_NUMBER AND CI1.CAL_TYPE = AP1.TEACH_CAL_TYPE AND (AP1.CAL_TYPE, AP1.CI_SEQUENCE_NUMBER) IN (SELECT SUB_CAL_TYPE, SUB_CI_SEQUENCE_NUMBER FROM IGS_CA_INST_REL R2, IGS_CA_TYPE CT1 WHERE CT1.CAL_TYPE = R2.SUB_CAL_TYPE AND CT1.S_CAL_CAT = 'LOAD' AND (SUP_CAL_TYPE, SUP_CI_SEQUENCE_NUMBER) IN (SELECT SUP_CAL_TYPE, SUP_CI_SEQUENCE_NUMBER FROM IGS_CA_INST_REL R1, IGS_CA_TYPE CT WHERE SUB_CAL_TYPE = AP1.TEACH_CAL_TYPE AND R1.SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER AND CT.CAL_TYPE = R1.SUP_CAL_TYPE AND CT.S_CAL_CAT = 'ACADEMIC'))

View Text - HTML Formatted

SELECT AP1.CAL_TYPE LOAD_CAL_TYPE
, AP1.CI_SEQUENCE_NUMBER LOAD_CI_SEQUENCE_NUMBER
, CI.START_DT LOAD_START_DT
, CI.END_DT LOAD_END_DT
, CI.ALTERNATE_CODE LOAD_ALTERNATE_CODE
, CI.DESCRIPTION
, CI1.CAL_TYPE TEACH_CAL_TYPE
, CI1.SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER
, CI1.START_DT TEACH_START_DT
, CI1.END_DT TEACH_END_DT
, CI1.ALTERNATE_CODE TEACH_ALTERNATE_CODE
, CI1.DESCRIPTION
FROM IGS_ST_DFT_LOAD_APPO AP1
, IGS_CA_INST CI1
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = AP1.CAL_TYPE
AND CI. SEQUENCE_NUMBER = AP1.CI_SEQUENCE_NUMBER
AND CI1.CAL_TYPE = AP1.TEACH_CAL_TYPE
AND (AP1.CAL_TYPE
, AP1.CI_SEQUENCE_NUMBER) IN (SELECT SUB_CAL_TYPE
, SUB_CI_SEQUENCE_NUMBER
FROM IGS_CA_INST_REL R2
, IGS_CA_TYPE CT1
WHERE CT1.CAL_TYPE = R2.SUB_CAL_TYPE
AND CT1.S_CAL_CAT = 'LOAD'
AND (SUP_CAL_TYPE
, SUP_CI_SEQUENCE_NUMBER) IN (SELECT SUP_CAL_TYPE
, SUP_CI_SEQUENCE_NUMBER
FROM IGS_CA_INST_REL R1
, IGS_CA_TYPE CT
WHERE SUB_CAL_TYPE = AP1.TEACH_CAL_TYPE
AND R1.SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CT.CAL_TYPE = R1.SUP_CAL_TYPE
AND CT.S_CAL_CAT = 'ACADEMIC'))