Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CMG.ROWID ROW_ID
, CMG.CLASS_MEET_GROUP_ID CLASS_MEET_GROUP_ID
, CMG.CLASS_MEET_GROUP_NAME CLASS_MEET_GROUP_NAME
, CMG.CAL_TYPE CAL_TYPE
, CMG.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.START_DT START_DT
, CI.END_DT END_DT
, CMG.CREATED_BY CREATED_BY
, CMG.CREATION_DATE CREATION_DATE
, CMG.LAST_UPDATED_BY LAST_UPDATED_BY
, CMG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CMG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CMG.MAX_ENR_GROUP
, CMG.MAX_OVR_GROUP
FROM IGS_PS_USO_CM_GRP CMG
, IGS_CA_INST CI
WHERE CMG.CAL_TYPE = CI.CAL_TYPE
AND CMG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER