VIEW: APPS.IGS_PR_PERIOD_V

Source

View Text - Preformatted

SELECT PRG_CI.CAL_TYPE, PRG_CI.SEQUENCE_NUMBER, PRG_CI.START_DT, PRG_CI.END_DT, ACAD_CI.ALTERNATE_CODE || '/' || PRG_CI.ALTERNATE_CODE, PRG_CI.CAL_STATUS, PRG_CS.S_CAL_STATUS, PRG_CI.CREATED_BY, PRG_CI.CREATION_DATE, PRG_CI.LAST_UPDATED_BY, PRG_CI.LAST_UPDATE_DATE, PRG_CI.LAST_UPDATE_LOGIN FROM IGS_CA_TYPE prg_cat, IGS_CA_INST prg_ci, IGS_CA_STAT prg_cs, IGS_CA_INST_REL cir, IGS_CA_INST acad_ci, IGS_CA_TYPE acad_cat WHERE PRG_CAT.S_CAL_CAT = 'PROGRESS' AND PRG_CAT.CAL_TYPE = PRG_CI.CAL_TYPE AND CIR.SUB_CAL_TYPE = PRG_CI.CAL_TYPE AND CIR.SUB_CI_SEQUENCE_NUMBER = PRG_CI.SEQUENCE_NUMBER AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC' AND ACAD_CAT.CAL_TYPE = ACAD_CI.CAL_TYPE AND CIR.SUP_CAL_TYPE = ACAD_CI.CAL_TYPE AND CIR.SUP_CI_SEQUENCE_NUMBER = ACAD_CI.SEQUENCE_NUMBER AND PRG_CI.CAL_STATUS = PRG_CS.CAL_STATUS

View Text - HTML Formatted

SELECT PRG_CI.CAL_TYPE
, PRG_CI.SEQUENCE_NUMBER
, PRG_CI.START_DT
, PRG_CI.END_DT
, ACAD_CI.ALTERNATE_CODE || '/' || PRG_CI.ALTERNATE_CODE
, PRG_CI.CAL_STATUS
, PRG_CS.S_CAL_STATUS
, PRG_CI.CREATED_BY
, PRG_CI.CREATION_DATE
, PRG_CI.LAST_UPDATED_BY
, PRG_CI.LAST_UPDATE_DATE
, PRG_CI.LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE PRG_CAT
, IGS_CA_INST PRG_CI
, IGS_CA_STAT PRG_CS
, IGS_CA_INST_REL CIR
, IGS_CA_INST ACAD_CI
, IGS_CA_TYPE ACAD_CAT
WHERE PRG_CAT.S_CAL_CAT = 'PROGRESS'
AND PRG_CAT.CAL_TYPE = PRG_CI.CAL_TYPE
AND CIR.SUB_CAL_TYPE = PRG_CI.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER = PRG_CI.SEQUENCE_NUMBER
AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC'
AND ACAD_CAT.CAL_TYPE = ACAD_CI.CAL_TYPE
AND CIR.SUP_CAL_TYPE = ACAD_CI.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = ACAD_CI.SEQUENCE_NUMBER
AND PRG_CI.CAL_STATUS = PRG_CS.CAL_STATUS