Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity store information of units that are offered for a calendar, they should also have an offering option and an offering pattern. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOO.ROWID ROW_ID
, UOO.UNIT_CD UNIT_CD
, UOO.VERSION_NUMBER VERSION_NUMBER
, UOO.CAL_TYPE CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD LOCATION_CD
, UOO.UNIT_CLASS UNIT_CLASS
, UOO.UOO_ID UOO_ID
, CI.START_DT DSP_CI_START_DT
, CI.END_DT DSP_CI_END_DT
, UV.UNIT_STATUS DSP_UNIT_STATUS
, UV.TITLE DSP_TITLE
, UOO.CREATED_BY CREATED_BY
, UOO.CREATION_DATE CREATION_DATE
, UOO.LAST_UPDATED_BY LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOO
, IGS_CA_INST CI
, IGS_PS_UNIT_VER UV
WHERE UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER