Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View over Degree Audit What-if Request |
Implementation/DBA Data: | Not implemented in this database |
SELECT DRW.ROWID
, DRW.BATCH_ID
, DRW.WIF_ID
, DRW.PROGRAM_CODE
, PV.TITLE
, DRW.CATALOG_CAL_TYPE
, DRW.CATALOG_CI_SEQ_NUM
, CI.DESCRIPTION
, CI.ALTERNATE_CODE
, DRW.MAJOR_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD1)
, DRW.MAJOR_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD2)
, DRW.MAJOR_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MAJOR_UNIT_SET_CD3)
, DRW.MINOR_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD1)
, DRW.MINOR_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD2)
, DRW.MINOR_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.MINOR_UNIT_SET_CD3)
, DRW.TRACK_UNIT_SET_CD1
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD1)
, DRW.TRACK_UNIT_SET_CD2
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD2)
, DRW.TRACK_UNIT_SET_CD3
, IGS_GE_GEN_004.GET_UNIT_SET_TITLE (DRW.TRACK_UNIT_SET_CD3)
, DRW.CREATION_DATE
, DRW.CREATED_BY
, DRW.LAST_UPDATED_BY
, DRW.LAST_UPDATE_LOGIN
, DRW.LAST_UPDATE_DATE
FROM IGS_DA_REQ_WIF DRW
, IGS_PS_VER PV
, IGS_CA_INST CI
WHERE DRW.PROGRAM_CODE = PV.COURSE_CD
AND PV.VERSION_NUMBER = (SELECT VERSION_NUMBER
FROM IGS_PS_VER PV_IN
, IGS_PS_STAT PS
WHERE PS.COURSE_STATUS = PV_IN.COURSE_STATUS
AND PS.S_COURSE_STATUS = 'ACTIVE'
AND PV_IN.COURSE_CD = PV.COURSE_CD
AND ROWNUM < 2)
AND CI.CAL_TYPE = DRW.CATALOG_CAL_TYPE
AND CI.SEQUENCE_NUMBER = DRW.CATALOG_CI_SEQ_NUM