[Home] [Help]
View: IGS_HE_POO_DTLS_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.ROWID ROW_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, B.COURSE_STATUS
, B.SHORT_TITLE
, A.CAL_TYPE
, C.DESCRIPTION
, A.LOCATION_CD
, A.ATTENDANCE_MODE
, A.ATTENDANCE_TYPE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, B.TITLE
FROM IGS_PS_OFR_OPT A
, IGS_PS_VER B
, IGS_CA_TYPE C
WHERE A.COURSE_CD = B.COURSE_CD
AND A.VERSION_NUMBER = B.VERSION_NUMBER
AND A.CAL_TYPE = C.CAL_TYPE
AND A.DELETE_FLAG='N'
Columns
Name |
ROW_ID |
COURSE_CD |
VERSION_NUMBER |
COURSE_STATUS |
SHORT_TITLE |
CAL_TYPE |
CAL_DESCRIPTION |
LOCATION_CD |
ATTENDANCE_MODE |
ATTENDANCE_TYPE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
COURSE_TITLE |