[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POO.ROWID ROW_ID
, POO.COURSE_CD COURSE_CD
, POO.VERSION_NUMBER VERSION_NUMBER
, POO.CAL_TYPE CAL_TYPE
, POO.LOCATION_CD LOCATION_CD
, POO.ATTENDANCE_MODE ATTENDANCE_MODE
, POO.ATTENDANCE_TYPE ATTENDANCE_TYPE
, POO.COO_ID COO_ID
, POO.FORCED_LOCATION_IND FORCED_LOCATION_IND
, POO.FORCED_ATT_MODE_IND FORCED_ATT_MODE_IND
, POO.FORCED_ATT_TYPE_IND FORCED_ATT_TYPE_IND
, POO.TIME_LIMITATION TIME_LIMITATION
, POO.ENR_OFFICER_PERSON_ID ENR_OFFICER_PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, POO.CREATED_BY CREATED_BY
, POO.CREATION_DATE CREATION_DATE
, POO.LAST_UPDATED_BY LAST_UPDATED_BY
, POO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, POO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, POO.ATTRIBUTE1 ATTRIBUTE1
, POO.ATTRIBUTE14 ATTRIBUTE14
, POO.ATTRIBUTE2 ATTRIBUTE2
, POO.ATTRIBUTE3 ATTRIBUTE3
, POO.ATTRIBUTE4 ATTRIBUTE4
, POO.ATTRIBUTE5 ATTRIBUTE5
, POO.ATTRIBUTE6 ATTRIBUTE6
, POO.ATTRIBUTE7 ATTRIBUTE7
, POO.ATTRIBUTE8 ATTRIBUTE8
, POO.ATTRIBUTE9 ATTRIBUTE9
, POO.ATTRIBUTE10 ATTRIBUTE10
, POO.ATTRIBUTE11 ATTRIBUTE11
, POO.ATTRIBUTE12 ATTRIBUTE12
, POO.ATTRIBUTE13 ATTRIBUTE13
, POO.ATTRIBUTE15 ATTRIBUTE15
, POO.ATTRIBUTE16 ATTRIBUTE16
, POO.ATTRIBUTE17 ATTRIBUTE17
, POO.ATTRIBUTE18 ATTRIBUTE18
, POO.ATTRIBUTE19 ATTRIBUTE19
, POO.ATTRIBUTE20 ATTRIBUTE20
, POO.PROGRAM_LENGTH PROGRAM_LENGTH
, POO.PROGRAM_LENGTH_MEASUREMENT PROGRAM_LENGTH_MEASUREMENT
, LV.MEANING PROGRAM_LENGTH_MESR_MEANING
FROM IGS_PS_OFR_OPT POO
, HZ_PARTIES PE
, IGS_LOOKUP_VALUES LV
WHERE PE.PARTY_ID (+) = POO.ENR_OFFICER_PERSON_ID
AND PE.STATUS (+) = 'A'
AND POO.PROGRAM_LENGTH_MEASUREMENT = LV.LOOKUP_CODE (+)
AND LV.LOOKUP_TYPE (+) = 'IGS_PS_PROGRAM_LENGTH_MESR'
AND POO.DELETE_FLAG='N'