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