[Home] [Help]
View: IGS_PS_OFR_VERSION_V
Product: | IGS - Student System (Obsolete) |
Description: | Manually created |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CRV.COURSE_TYPE
, CO.COURSE_CD
, CO.VERSION_NUMBER
, CO.CAL_TYPE
, CRV.COURSE_STATUS
, CRV.RESPONSIBLE_ORG_UNIT_CD
, CO.CREATED_BY
, CO.CREATION_DATE
, CO.LAST_UPDATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATE_LOGIN
FROM IGS_PS_OFR CO
, IGS_PS_VER CRV
, IGS_PS_STAT CRST
, IGS_CA_TYPE CAT
WHERE (CO.COURSE_CD = CRV.COURSE_CD
AND CO.VERSION_NUMBER = CRV.VERSION_NUMBER
AND CRV.COURSE_STATUS = CRST.COURSE_STATUS
AND CRST.S_COURSE_STATUS != 'INACTIVE')
AND (CO.CAL_TYPE = CAT.CAL_TYPE
AND CAT.S_CAL_CAT = 'ACADEMIC')
Columns
Name |
COURSE_TYPE |
COURSE_CD |
VERSION_NUMBER |
CAL_TYPE |
COURSE_STATUS |
RESPONSIBLE_ORG_UNIT_CD |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |