Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USXGM.ROWID ROW_ID
, SUBSTR (UOOV.UNIT_CD || ' - ' || UOOV.VERSION_NUMBER || ' - ' || UOOV.LOCATION_CD || ' - ' || UOOV.UNIT_CLASS || ' - ' || UC.UNIT_MODE || ' - ' || CA.ALTERNATE_CODE
, 1
, 2000) UNIT_SECTION
, USXGM.USEC_X_LISTED_GROUP_MEM_ID USEC_X_LISTED_GROUP_MEM_ID
, USXGM.USEC_X_LISTED_GROUP_ID USEC_X_LISTED_GROUP_ID
, USXGM.UOO_ID UOO_ID
, USXGM.PARENT PARENT
, DECODE(USXG.MAX_ENR_GROUP
, NULL
, NVL(NVL(ULW.ENROLLMENT_MAXIMUM
, UV.ENROLLMENT_MAXIMUM)
, 0)
, NULL) ENROLLMENT_MAXIMUM
, USXGM.CREATED_BY CREATED_BY
, USXGM.CREATION_DATE CREATION_DATE
, USXGM.LAST_UPDATED_BY LAST_UPDATED_BY
, USXGM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USXGM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(USXG.MAX_OVR_GROUP
, NULL
, NVL(NVL(ULW.OVERRIDE_ENROLLMENT_MAX
, UV.OVERRIDE_ENROLLMENT_MAX)
, 0)
, NULL) OVERRIDE_MAXIMUM
, NVL(UOOV.ENROLLMENT_ACTUAL
, 0) ENROLLMENT_ACTUAL
FROM IGS_PS_USEC_X_GRPMEM USXGM
, IGS_PS_UNIT_OFR_OPT UOOV
, IGS_PS_UNIT_VER UV
, IGS_PS_USEC_LIM_WLST ULW
, IGS_PS_USEC_X_GRP USXG
, IGS_CA_INST CA
, IGS_AS_UNIT_CLASS UC
WHERE UOOV.UOO_ID = ULW.UOO_ID (+)
AND UOOV.UOO_ID = USXGM.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 USXGM.USEC_X_LISTED_GROUP_ID = USXG.USEC_X_LISTED_GROUP_ID