VIEW: APPS.PER_RATING_SCALES_V

Source

View Text - Preformatted

SELECT RSC.ROWID ROW_ID ,RSC.RATING_SCALE_ID ,RSL.NAME ,RSC.BUSINESS_GROUP_ID ,RSC. OBJECT_VERSION_NUMBER ,RSL.DESCRIPTION ,RSC.TYPE ,HR_GENERAL.DECODE_LOOKUP('RATING_SCALE_TYPE',RSC.TYPE) ,RSC.DEFAULT_FLAG ,RSC.MIN_SCALE_STEP ,RSC.MAX_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 ,DECODE(RSC.BUSINESS_GROUP_ID,NULL,'Y','N') 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
, RSL.NAME
, RSC.BUSINESS_GROUP_ID
, RSC. OBJECT_VERSION_NUMBER
, RSL.DESCRIPTION
, RSC.TYPE
, HR_GENERAL.DECODE_LOOKUP('RATING_SCALE_TYPE'
, RSC.TYPE)
, RSC.DEFAULT_FLAG
, RSC.MIN_SCALE_STEP
, RSC.MAX_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
, DECODE(RSC.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
FROM PER_RATING_SCALES RSC
, PER_RATING_SCALES_TL RSL
WHERE RSC. RATING_SCALE_ID = RSL.RATING_SCALE_ID
AND RSL.LANGUAGE = USERENV('LANG')