[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CM.ROWID ROW_ID
, CM.CLASS_MEET_ID CLASS_MEET_ID
, CM.CLASS_MEET_GROUP_ID CLASS_MEET_GROUP_ID
, NULL UNIT_SECTION_OCCURRENCE_ID
, NULL UNIT_SECTION_OCCURRENCE
, DECODE(CMG.MAX_ENR_GROUP
, NULL
, NVL (NVL (ULW.ENROLLMENT_MAXIMUM
, UV.ENROLLMENT_MAXIMUM)
, 0)
, NULL) ENROLLMENT_MAXIMUM
, CM.HOST HOST
, CM.CREATED_BY CREATED_BY
, CM.CREATION_DATE CREATION_DATE
, CM.LAST_UPDATED_BY LAST_UPDATED_BY
, CM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUBSTR(UOOV.UNIT_CD||'-'||UOOV.VERSION_NUMBER||'-'||UOOV.LOCATION_CD||'-'||UOOV.UNIT_CLASS||'-'||UC.UNIT_MODE||'-'||CA.ALTERNATE_CODE
, 1
, 2000) UNIT_SECTION
, DECODE(CMG.MAX_OVR_GROUP
, NULL
, NVL(NVL(ULW.OVERRIDE_ENROLLMENT_MAX
, UV.OVERRIDE_ENROLLMENT_MAX)
, 0)
, NULL) OVERRIDE_MAXIMUM
, CM.UOO_ID UOO_ID
, NVL(UOOV.ENROLLMENT_ACTUAL
, 0) ENROLLMENT_ACTUAL
FROM IGS_PS_USO_CLAS_MEET CM
, IGS_PS_USO_CM_GRP CMG
, IGS_PS_USEC_LIM_WLST ULW
, IGS_PS_UNIT_OFR_OPT UOOV
, IGS_PS_UNIT_VER UV
, IGS_CA_INST CA
, IGS_AS_UNIT_CLASS UC
WHERE UOOV.UOO_ID = ULW.UOO_ID(+)
AND UOOV.UOO_ID = CM.UOO_ID
AND UOOV.CAL_TYPE=CA.CAL_TYPE
AND UOOV.CI_SEQUENCE_NUMBER=CA.SEQUENCE_NUMBER
AND UOOV.UNIT_CLASS=UC.UNIT_CLASS
AND UOOV.UNIT_CD = UV.UNIT_CD
AND UOOV.VERSION_NUMBER = UV.VERSION_NUMBER
AND CMG.CLASS_MEET_GROUP_ID = CM.CLASS_MEET_GROUP_ID