View: IGS_PR_PERIOD_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PR_PERIOD_V

View Text

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

Columns