VIEW: APPS.IGS_AS_GRD_SCHEMA_V

Source

View Text - Preformatted

SELECT agsc.rowid, agsc.grading_schema_cd , agsc.version_number , agsc.description , agsc.start_dt , agsc.end_dt , agsc.comments , agsc.grading_schema_type, lkv.meaning , agsc.created_by , agsc.creation_date , agsc.last_updated_by , agsc.last_update_date , agsc.last_update_login , agsc.attribute_category , agsc.attribute1 , agsc.attribute2 , agsc.attribute3 , agsc.attribute4 , agsc.attribute5 , agsc.attribute6 , agsc.attribute7 , agsc.attribute8 , agsc.attribute9 , agsc.attribute10 , agsc.attribute11 , agsc.attribute12 , agsc.attribute13 , agsc.attribute14 , agsc.attribute15 , agsc.attribute16 , agsc.attribute17 , agsc.attribute18 , agsc.attribute19 , agsc.attribute20 FROM IGS_AS_GRD_SCHEMA agsc, IGS_LOOKUPS_VIEW lkv WHERE agsc.grading_schema_type = lkv.lookup_code AND lkv.lookup_type = 'GRADING_SCHEMA_TYPES'

View Text - HTML Formatted

SELECT AGSC.ROWID
, AGSC.GRADING_SCHEMA_CD
, AGSC.VERSION_NUMBER
, AGSC.DESCRIPTION
, AGSC.START_DT
, AGSC.END_DT
, AGSC.COMMENTS
, AGSC.GRADING_SCHEMA_TYPE
, LKV.MEANING
, AGSC.CREATED_BY
, AGSC.CREATION_DATE
, AGSC.LAST_UPDATED_BY
, AGSC.LAST_UPDATE_DATE
, AGSC.LAST_UPDATE_LOGIN
, AGSC.ATTRIBUTE_CATEGORY
, AGSC.ATTRIBUTE1
, AGSC.ATTRIBUTE2
, AGSC.ATTRIBUTE3
, AGSC.ATTRIBUTE4
, AGSC.ATTRIBUTE5
, AGSC.ATTRIBUTE6
, AGSC.ATTRIBUTE7
, AGSC.ATTRIBUTE8
, AGSC.ATTRIBUTE9
, AGSC.ATTRIBUTE10
, AGSC.ATTRIBUTE11
, AGSC.ATTRIBUTE12
, AGSC.ATTRIBUTE13
, AGSC.ATTRIBUTE14
, AGSC.ATTRIBUTE15
, AGSC.ATTRIBUTE16
, AGSC.ATTRIBUTE17
, AGSC.ATTRIBUTE18
, AGSC.ATTRIBUTE19
, AGSC.ATTRIBUTE20
FROM IGS_AS_GRD_SCHEMA AGSC
, IGS_LOOKUPS_VIEW LKV
WHERE AGSC.GRADING_SCHEMA_TYPE = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'GRADING_SCHEMA_TYPES'