Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UXGM.ROWID ROW_ID
, UV.UNIT_CD || ' - ' || UV.VERSION_NUMBER || ' - ' || UV.TITLE UNIT
, UXGM.UNIT_X_LISTED_GROUP_MEM_ID UNIT_X_LISTED_GROUP_MEM_ID
, UXGM.UNIT_X_LISTED_GROUP_ID UNIT_X_LISTED_GROUP_ID
, UXGM.UNIT_CD UNIT_CD
, UXGM.VERSION_NUMBER VERSION_NUMBER
, UXGM.PARENT PARENT
, DECODE(UXG.MAX_ENR_GROUP
, NULL
, NVL(UV.ENROLLMENT_MAXIMUM
, 0)
, NULL) ENROLLMENT_MAXIMUM
, UXGM.CREATED_BY CREATED_BY
, UXGM.CREATION_DATE CREATION_DATE
, UXGM.LAST_UPDATED_BY LAST_UPDATED_BY
, UXGM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UXGM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(UXG.MAX_OVR_GROUP
, NULL
, NVL(UV.OVERRIDE_ENROLLMENT_MAX
, 0)
, NULL) OVERRIDE_MAXIMUM
FROM IGS_PS_UNIT_X_GRPMEM UXGM
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_X_GRP UXG
WHERE UV.UNIT_CD = UXGM.UNIT_CD
AND UV.VERSION_NUMBER = UXGM.VERSION_NUMBER
AND UXGM.UNIT_X_LISTED_GROUP_ID = UXG.UNIT_X_LISTED_GROUP_ID