VIEW: APPS.PER_COMPETENCE_LEVELS_V

Source

View Text - Preformatted

SELECT RTL.ROWID ,RTL.RATING_LEVEL_ID ,RTL.COMPETENCE_ID ,RTL.RATING_SCALE_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.COMPETENCE_ID IS NOT NULL AND RTL.RATING_LEVEL_ID = RTX.RATING_LEVEL_ID AND RTX.LANGUAGE = userenv('LANG') UNION SELECT LVL.ROWID ,LVL.RATING_LEVEL_ID ,CMP.COMPETENCE_ID ,LVL.RATING_SCALE_ID ,LVL.BUSINESS_GROUP_ID ,LVL.STEP_VALUE ,RTX2.NAME ,RTX2.BEHAVIOURAL_INDICATOR ,LVL.OBJECT_VERSION_NUMBER ,LVL.ATTRIBUTE_CATEGORY ,LVL.ATTRIBUTE1 ,LVL.ATTRIBUTE2 ,LVL.ATTRIBUTE3 ,LVL.ATTRIBUTE4 ,LVL.ATTRIBUTE5 ,LVL.ATTRIBUTE6 ,LVL.ATTRIBUTE7 ,LVL.ATTRIBUTE8 ,LVL.ATTRIBUTE9 ,LVL.ATTRIBUTE10 ,LVL.ATTRIBUTE11 ,LVL.ATTRIBUTE12 ,LVL.ATTRIBUTE13 ,LVL.ATTRIBUTE14 ,LVL.ATTRIBUTE15 ,LVL.ATTRIBUTE16 ,LVL.ATTRIBUTE17 ,LVL.ATTRIBUTE18 ,LVL.ATTRIBUTE19 ,LVL.ATTRIBUTE20 ,LVL.LAST_UPDATE_DATE ,LVL.LAST_UPDATED_BY ,LVL.LAST_UPDATE_LOGIN ,LVL.CREATED_BY ,LVL.CREATION_DATE FROM PER_RATING_LEVELS LVL, PER_RATING_LEVELS_TL RTX2, PER_COMPETENCES CMP WHERE LVL.RATING_SCALE_ID = CMP.RATING_SCALE_ID AND RTX2.RATING_LEVEL_ID = LVL.RATING_LEVEL_ID AND RTX2.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT RTL.ROWID
, RTL.RATING_LEVEL_ID
, RTL.COMPETENCE_ID
, RTL.RATING_SCALE_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.COMPETENCE_ID IS NOT NULL
AND RTL.RATING_LEVEL_ID = RTX.RATING_LEVEL_ID
AND RTX.LANGUAGE = USERENV('LANG') UNION SELECT LVL.ROWID
, LVL.RATING_LEVEL_ID
, CMP.COMPETENCE_ID
, LVL.RATING_SCALE_ID
, LVL.BUSINESS_GROUP_ID
, LVL.STEP_VALUE
, RTX2.NAME
, RTX2.BEHAVIOURAL_INDICATOR
, LVL.OBJECT_VERSION_NUMBER
, LVL.ATTRIBUTE_CATEGORY
, LVL.ATTRIBUTE1
, LVL.ATTRIBUTE2
, LVL.ATTRIBUTE3
, LVL.ATTRIBUTE4
, LVL.ATTRIBUTE5
, LVL.ATTRIBUTE6
, LVL.ATTRIBUTE7
, LVL.ATTRIBUTE8
, LVL.ATTRIBUTE9
, LVL.ATTRIBUTE10
, LVL.ATTRIBUTE11
, LVL.ATTRIBUTE12
, LVL.ATTRIBUTE13
, LVL.ATTRIBUTE14
, LVL.ATTRIBUTE15
, LVL.ATTRIBUTE16
, LVL.ATTRIBUTE17
, LVL.ATTRIBUTE18
, LVL.ATTRIBUTE19
, LVL.ATTRIBUTE20
, LVL.LAST_UPDATE_DATE
, LVL.LAST_UPDATED_BY
, LVL.LAST_UPDATE_LOGIN
, LVL.CREATED_BY
, LVL.CREATION_DATE
FROM PER_RATING_LEVELS LVL
, PER_RATING_LEVELS_TL RTX2
, PER_COMPETENCES CMP
WHERE LVL.RATING_SCALE_ID = CMP.RATING_SCALE_ID
AND RTX2.RATING_LEVEL_ID = LVL.RATING_LEVEL_ID
AND RTX2.LANGUAGE = USERENV('LANG')