Product: | IGS - Student System (Obsolete) |
---|---|
Description: | The view is created for showing the relation between Unit Sections and Unit Section Reference Code. |
Implementation/DBA Data: | Not implemented in this database |
SELECT USRF.ROWID ROW_ID
, USRF. UNIT_SECTION_REFERENCE_ID
, USRF. UOO_ID
, USRF. SHORT_TITLE
, UVSB. SUBTITLE
, USRF.SUBTITLE_ID
, USRF. SUBTITLE_MODIFIABLE_FLAG
, USRF. CLASS_SCHEDULE_EXCLUSION_FLAG
, USRF. REGISTRATION_EXCLUSION_FLAG
, USRF.TITLE
, USRF.RECORD_EXCLUSION_FLAG
, USRF. ATTRIBUTE_CATEGORY
, USRF. ATTRIBUTE1
, USRF. ATTRIBUTE2
, USRF. ATTRIBUTE3
, USRF. ATTRIBUTE4
, USRF. ATTRIBUTE5
, USRF. ATTRIBUTE6
, USRF. ATTRIBUTE7
, USRF. ATTRIBUTE8
, USRF. ATTRIBUTE9
, USRF. ATTRIBUTE10
, USRF. ATTRIBUTE11
, USRF. ATTRIBUTE12
, USRF. ATTRIBUTE13
, USRF. ATTRIBUTE14
, USRF. ATTRIBUTE15
, USRF. ATTRIBUTE16
, USRF. ATTRIBUTE17
, USRF. ATTRIBUTE18
, USRF. ATTRIBUTE19
, USRF. ATTRIBUTE20
, USRF. CREATED_BY
, USRF. CREATION_DATE
, USRF. LAST_UPDATED_BY
, USRF. LAST_UPDATE_DATE
, USRF. LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_REF USRF
, IGS_PS_UNIT_SUBTITLE UVSB
WHERE USRF.SUBTITLE_ID = UVSB.SUBTITLE_ID(+)