View: PER_COMPETENCE_LEVELS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_COMPETENCE_LEVELS_V

View Text

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')

Columns