VIEW: APPS.PER_RATING_SCALES_VL

Source

View Text - Preformatted

SELECT RSC.ROWID ROW_ID ,RSC.RATING_SCALE_ID ,RSC.BUSINESS_GROUP_ID ,RSC.OBJECT_VERSION_NUMBER ,RSC.TYPE ,RSC.DEFAULT_FLAG ,RSC.MAX_SCALE_STEP ,RSC.MIN_SCALE_STEP ,RSC.ATTRIBUTE_CATEGORY ,RSC.ATTRIBUTE1 ,RSC.ATTRIBUTE2 ,RSC.ATTRIBUTE3 ,RSC.ATTRIBUTE4 ,RSC.ATTRIBUTE5 ,RSC.ATTRIBUTE6 ,RSC.ATTRIBUTE7 ,RSC.ATTRIBUTE8 ,RSC.ATTRIBUTE9 ,RSC.ATTRIBUTE10 ,RSC.ATTRIBUTE11 ,RSC.ATTRIBUTE12 ,RSC.ATTRIBUTE13 ,RSC.ATTRIBUTE14 ,RSC.ATTRIBUTE15 ,RSC.ATTRIBUTE16 ,RSC.ATTRIBUTE17 ,RSC.ATTRIBUTE18 ,RSC.ATTRIBUTE19 ,RSC.ATTRIBUTE20 ,RSC.LAST_UPDATE_DATE ,RSC.LAST_UPDATED_BY ,RSC.LAST_UPDATE_LOGIN ,RSC.CREATED_BY ,RSC.CREATION_DATE ,RSL.NAME ,RSL.DESCRIPTION FROM PER_RATING_SCALES RSC ,PER_RATING_SCALES_TL RSL WHERE RSC. RATING_SCALE_ID =RSL.RATING_SCALE_ID AND RSL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT RSC.ROWID ROW_ID
, RSC.RATING_SCALE_ID
, RSC.BUSINESS_GROUP_ID
, RSC.OBJECT_VERSION_NUMBER
, RSC.TYPE
, RSC.DEFAULT_FLAG
, RSC.MAX_SCALE_STEP
, RSC.MIN_SCALE_STEP
, RSC.ATTRIBUTE_CATEGORY
, RSC.ATTRIBUTE1
, RSC.ATTRIBUTE2
, RSC.ATTRIBUTE3
, RSC.ATTRIBUTE4
, RSC.ATTRIBUTE5
, RSC.ATTRIBUTE6
, RSC.ATTRIBUTE7
, RSC.ATTRIBUTE8
, RSC.ATTRIBUTE9
, RSC.ATTRIBUTE10
, RSC.ATTRIBUTE11
, RSC.ATTRIBUTE12
, RSC.ATTRIBUTE13
, RSC.ATTRIBUTE14
, RSC.ATTRIBUTE15
, RSC.ATTRIBUTE16
, RSC.ATTRIBUTE17
, RSC.ATTRIBUTE18
, RSC.ATTRIBUTE19
, RSC.ATTRIBUTE20
, RSC.LAST_UPDATE_DATE
, RSC.LAST_UPDATED_BY
, RSC.LAST_UPDATE_LOGIN
, RSC.CREATED_BY
, RSC.CREATION_DATE
, RSL.NAME
, RSL.DESCRIPTION
FROM PER_RATING_SCALES RSC
, PER_RATING_SCALES_TL RSL
WHERE RSC. RATING_SCALE_ID =RSL.RATING_SCALE_ID
AND RSL.LANGUAGE = USERENV('LANG')