[Home] [Help]
View: IGSFV_UNIT_CAL_TYPE_OFFERINGS
Product: | IGS - Student System (Obsolete) |
Description: | This is a full view, which describes an offering of a unit within a calendar type. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UI.TITLE
, TY.DESCRIPTION
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_OFR UN
, IGS_CA_TYPE TY
, IGS_PS_UNIT_VER_ALL UI
WHERE UN.CAL_TYPE =TY.CAL_TYPE
AND UN.UNIT_CD = UI.UNIT_CD
AND UN.VERSION_NUMBER = UI.VERSION_NUMBER WITH READ ONLY
Columns
Name |
UNIT_CODE |
VERSION_NUMBER |
CALENDAR_TYPE |
UNIT_TITLE |
CALENDAR_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |