VIEW: APPS.IGS_CA_INST_ADM_PERD_V

Source

View Text - Preformatted

SELECT ci1.CAL_TYPE, ci1.sequence_number, cat1.description, ci1.start_dt, ci1.end_dt, ci1.CAL_STATUS, ci1.alternate_code, ci1.prior_ci_sequence_number, cir.sup_cal_type, cir.sup_ci_sequence_number, ci2.start_dt, ci2.end_dt, ci2.alternate_code, ci2.alternate_code || '/' || ci1.alternate_code, ci1.created_by, ci1.creation_date, ci1.last_updated_by, ci1.last_update_date , ci1.last_update_login FROM IGS_CA_INST ci1, IGS_CA_INST_REL cir, IGS_CA_INST ci2, IGS_CA_TYPE cat1, IGS_CA_TYPE cat2 WHERE cir.sub_cal_type (+) = ci1.CAL_TYPE AND cir.sub_ci_sequence_number (+) = ci1.sequence_number AND ci2.CAL_TYPE (+) = cir.sup_cal_type AND ci2.sequence_number (+) = cir.sup_ci_sequence_number AND cat1.CAL_TYPE = ci1.CAL_TYPE AND cat1.S_CAL_CAT = 'ADMISSION' AND cat2.CAL_TYPE (+) = ci2.CAL_TYPE AND cat2.S_CAL_CAT = 'ACADEMIC'

View Text - HTML Formatted

SELECT CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, CAT1.DESCRIPTION
, CI1.START_DT
, CI1.END_DT
, CI1.CAL_STATUS
, CI1.ALTERNATE_CODE
, CI1.PRIOR_CI_SEQUENCE_NUMBER
, CIR.SUP_CAL_TYPE
, CIR.SUP_CI_SEQUENCE_NUMBER
, CI2.START_DT
, CI2.END_DT
, CI2.ALTERNATE_CODE
, CI2.ALTERNATE_CODE || '/' || CI1.ALTERNATE_CODE
, CI1.CREATED_BY
, CI1.CREATION_DATE
, CI1.LAST_UPDATED_BY
, CI1.LAST_UPDATE_DATE
, CI1.LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI1
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI2
, IGS_CA_TYPE CAT1
, IGS_CA_TYPE CAT2
WHERE CIR.SUB_CAL_TYPE (+) = CI1.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER (+) = CI1.SEQUENCE_NUMBER
AND CI2.CAL_TYPE (+) = CIR.SUP_CAL_TYPE
AND CI2.SEQUENCE_NUMBER (+) = CIR.SUP_CI_SEQUENCE_NUMBER
AND CAT1.CAL_TYPE = CI1.CAL_TYPE
AND CAT1.S_CAL_CAT = 'ADMISSION'
AND CAT2.CAL_TYPE (+) = CI2.CAL_TYPE
AND CAT2.S_CAL_CAT = 'ACADEMIC'