VIEW: APPS.PER_COMPETENCES_VL

Source

View Text - Preformatted

SELECT CPN.ROWID ROW_ID ,CPN.BUSINESS_GROUP_ID ,CPN.COMPETENCE_ID ,CPN.OBJECT_VERSION_NUMBER ,CPN.DATE_FROM ,CPN.DATE_TO ,CPN.CERTIFICATION_REQUIRED ,CPN.EVALUATION_METHOD ,CPN.RENEWAL_PERIOD_FREQUENCY ,CPN.RENEWAL_PERIOD_UNITS ,CPN.MAX_LEVEL ,CPN.MIN_LEVEL ,CPN.RATING_SCALE_ID ,CPN.ATTRIBUTE_CATEGORY ,CPN.ATTRIBUTE1 ,CPN.ATTRIBUTE2 ,CPN.ATTRIBUTE3 ,CPN.ATTRIBUTE4 ,CPN.ATTRIBUTE5 ,CPN.ATTRIBUTE6 ,CPN.ATTRIBUTE7 ,CPN.ATTRIBUTE8 ,CPN.ATTRIBUTE9 ,CPN.ATTRIBUTE10 ,CPN.ATTRIBUTE11 ,CPN.ATTRIBUTE12 ,CPN.ATTRIBUTE13 ,CPN.ATTRIBUTE14 ,CPN.ATTRIBUTE15 ,CPN.ATTRIBUTE16 ,CPN.ATTRIBUTE17 ,CPN.ATTRIBUTE18 ,CPN.ATTRIBUTE19 ,CPN.ATTRIBUTE20 ,CPN.LAST_UPDATE_DATE ,CPN.LAST_UPDATED_BY ,CPN.LAST_UPDATE_LOGIN ,CPN.CREATED_BY ,CPN.CREATION_DATE ,CPN.COMPETENCE_DEFINITION_ID ,CPL.NAME ,CPL.COMPETENCE_ALIAS ,CPN.COMPETENCE_CLUSTER ,CPL.BEHAVIOURAL_INDICATOR ,CPL.DESCRIPTION ,CPN.UNIT_STANDARD_ID ,CPN.CREDIT_TYPE ,CPN.CREDITS ,CPN.LEVEL_TYPE ,CPN.LEVEL_NUMBER ,CPN.FIELD ,CPN.SUB_FIELD ,CPN.PROVIDER ,CPN.QA_ORGANIZATION ,CPN.INFORMATION_CATEGORY ,CPN.INFORMATION1 ,CPN.INFORMATION2 ,CPN.INFORMATION3 ,CPN.INFORMATION4 ,CPN.INFORMATION5 ,CPN.INFORMATION6 ,CPN.INFORMATION7 ,CPN.INFORMATION8 ,CPN.INFORMATION9 ,CPN.INFORMATION10 ,CPN.INFORMATION11 ,CPN.INFORMATION12 ,CPN.INFORMATION13 ,CPN.INFORMATION14 ,CPN.INFORMATION15 ,CPN.INFORMATION16 ,CPN.INFORMATION17 ,CPN.INFORMATION18 ,CPN.INFORMATION19 ,CPN.INFORMATION20 FROM PER_COMPETENCES CPN , PER_COMPETENCES_TL CPL WHERE CPN.COMPETENCE_ID = CPL.COMPETENCE_ID AND CPL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT CPN.ROWID ROW_ID
, CPN.BUSINESS_GROUP_ID
, CPN.COMPETENCE_ID
, CPN.OBJECT_VERSION_NUMBER
, CPN.DATE_FROM
, CPN.DATE_TO
, CPN.CERTIFICATION_REQUIRED
, CPN.EVALUATION_METHOD
, CPN.RENEWAL_PERIOD_FREQUENCY
, CPN.RENEWAL_PERIOD_UNITS
, CPN.MAX_LEVEL
, CPN.MIN_LEVEL
, CPN.RATING_SCALE_ID
, CPN.ATTRIBUTE_CATEGORY
, CPN.ATTRIBUTE1
, CPN.ATTRIBUTE2
, CPN.ATTRIBUTE3
, CPN.ATTRIBUTE4
, CPN.ATTRIBUTE5
, CPN.ATTRIBUTE6
, CPN.ATTRIBUTE7
, CPN.ATTRIBUTE8
, CPN.ATTRIBUTE9
, CPN.ATTRIBUTE10
, CPN.ATTRIBUTE11
, CPN.ATTRIBUTE12
, CPN.ATTRIBUTE13
, CPN.ATTRIBUTE14
, CPN.ATTRIBUTE15
, CPN.ATTRIBUTE16
, CPN.ATTRIBUTE17
, CPN.ATTRIBUTE18
, CPN.ATTRIBUTE19
, CPN.ATTRIBUTE20
, CPN.LAST_UPDATE_DATE
, CPN.LAST_UPDATED_BY
, CPN.LAST_UPDATE_LOGIN
, CPN.CREATED_BY
, CPN.CREATION_DATE
, CPN.COMPETENCE_DEFINITION_ID
, CPL.NAME
, CPL.COMPETENCE_ALIAS
, CPN.COMPETENCE_CLUSTER
, CPL.BEHAVIOURAL_INDICATOR
, CPL.DESCRIPTION
, CPN.UNIT_STANDARD_ID
, CPN.CREDIT_TYPE
, CPN.CREDITS
, CPN.LEVEL_TYPE
, CPN.LEVEL_NUMBER
, CPN.FIELD
, CPN.SUB_FIELD
, CPN.PROVIDER
, CPN.QA_ORGANIZATION
, CPN.INFORMATION_CATEGORY
, CPN.INFORMATION1
, CPN.INFORMATION2
, CPN.INFORMATION3
, CPN.INFORMATION4
, CPN.INFORMATION5
, CPN.INFORMATION6
, CPN.INFORMATION7
, CPN.INFORMATION8
, CPN.INFORMATION9
, CPN.INFORMATION10
, CPN.INFORMATION11
, CPN.INFORMATION12
, CPN.INFORMATION13
, CPN.INFORMATION14
, CPN.INFORMATION15
, CPN.INFORMATION16
, CPN.INFORMATION17
, CPN.INFORMATION18
, CPN.INFORMATION19
, CPN.INFORMATION20
FROM PER_COMPETENCES CPN
, PER_COMPETENCES_TL CPL
WHERE CPN.COMPETENCE_ID = CPL.COMPETENCE_ID
AND CPL.LANGUAGE = USERENV('LANG')