VIEW: APPS.PER_RATING_LEVELS_V

Source

View Text - Preformatted

SELECT RTL.ROWID ROW_ID ,RTL.RATING_LEVEL_ID ,RTL.RATING_SCALE_ID ,RTL.COMPETENCE_ID ,RTL.BUSINESS_GROUP_ID ,RTL.STEP_VALUE ,RTX.NAME ,RTX.BEHAVIOURAL_INDICATOR ,RTL.OBJECT_VERSION_NUMBER ,RTL.ATTRIBUTE_CATEGORY ,RTL.ATTRIBUTE1 ,RTL.ATTRIBUTE2 ,RTL.ATTRIBUTE3 ,RTL.ATTRIBUTE4 ,RTL.ATTRIBUTE5 ,RTL.ATTRIBUTE6 ,RTL.ATTRIBUTE7 ,RTL.ATTRIBUTE8 ,RTL.ATTRIBUTE9 ,RTL.ATTRIBUTE10 ,RTL.ATTRIBUTE11 ,RTL.ATTRIBUTE12 ,RTL.ATTRIBUTE13 ,RTL.ATTRIBUTE14 ,RTL.ATTRIBUTE15 ,RTL.ATTRIBUTE16 ,RTL.ATTRIBUTE17 ,RTL.ATTRIBUTE18 ,RTL.ATTRIBUTE19 ,RTL.ATTRIBUTE20 ,RTL.LAST_UPDATE_DATE ,RTL.LAST_UPDATED_BY ,RTL.LAST_UPDATE_LOGIN ,RTL.CREATED_BY ,RTL.CREATION_DATE FROM PER_RATING_LEVELS RTL , PER_RATING_LEVELS_TL RTX WHERE RTL.RATING_SCALE_ID IS NOT NULL AND RTL.RATING_LEVEL_ID = RTX.RATING_LEVEL_ID AND RTX.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT RTL.ROWID ROW_ID
, RTL.RATING_LEVEL_ID
, RTL.RATING_SCALE_ID
, RTL.COMPETENCE_ID
, RTL.BUSINESS_GROUP_ID
, RTL.STEP_VALUE
, RTX.NAME
, RTX.BEHAVIOURAL_INDICATOR
, RTL.OBJECT_VERSION_NUMBER
, RTL.ATTRIBUTE_CATEGORY
, RTL.ATTRIBUTE1
, RTL.ATTRIBUTE2
, RTL.ATTRIBUTE3
, RTL.ATTRIBUTE4
, RTL.ATTRIBUTE5
, RTL.ATTRIBUTE6
, RTL.ATTRIBUTE7
, RTL.ATTRIBUTE8
, RTL.ATTRIBUTE9
, RTL.ATTRIBUTE10
, RTL.ATTRIBUTE11
, RTL.ATTRIBUTE12
, RTL.ATTRIBUTE13
, RTL.ATTRIBUTE14
, RTL.ATTRIBUTE15
, RTL.ATTRIBUTE16
, RTL.ATTRIBUTE17
, RTL.ATTRIBUTE18
, RTL.ATTRIBUTE19
, RTL.ATTRIBUTE20
, RTL.LAST_UPDATE_DATE
, RTL.LAST_UPDATED_BY
, RTL.LAST_UPDATE_LOGIN
, RTL.CREATED_BY
, RTL.CREATION_DATE
FROM PER_RATING_LEVELS RTL
, PER_RATING_LEVELS_TL RTX
WHERE RTL.RATING_SCALE_ID IS NOT NULL
AND RTL.RATING_LEVEL_ID = RTX.RATING_LEVEL_ID
AND RTX.LANGUAGE = USERENV('LANG')