VIEW: APPS.IGS_PS_USEC_REF_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)