View: PER_COMPETENCE_ELEMENTS_V2

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

View Text

SELECT 1
, CEL.GROUP_COMPETENCE_TYPE
, HR_GENERAL.DECODE_LOOKUP('COMPETENCE_TYPE'
, CEL.GROUP_COMPETENCE_TYPE)
, CEL.ASSESSMENT_TYPE_ID
, CEL.SEQUENCE_NUMBER
, 'Y'
, CEL.COMPETENCE_ELEMENT_ID
, CEL.BUSINESS_GROUP_ID
, CEL.OBJECT_VERSION_NUMBER
, CEL.ATTRIBUTE_CATEGORY
, CEL.ATTRIBUTE1
, CEL.ATTRIBUTE2
, CEL.ATTRIBUTE3
, CEL.ATTRIBUTE4
, CEL.ATTRIBUTE5
, CEL.ATTRIBUTE6
, CEL.ATTRIBUTE7
, CEL.ATTRIBUTE8
, CEL.ATTRIBUTE9
, CEL.ATTRIBUTE10
, CEL.ATTRIBUTE11
, CEL.ATTRIBUTE12
, CEL.ATTRIBUTE13
, CEL.ATTRIBUTE14
, CEL.ATTRIBUTE15
, CEL.ATTRIBUTE16
, CEL.ATTRIBUTE17
, CEL.ATTRIBUTE18
, CEL.ATTRIBUTE19
, CEL.ATTRIBUTE20
, CEL.LAST_UPDATE_DATE
, CEL.LAST_UPDATED_BY
, CEL.LAST_UPDATE_LOGIN
, CEL.CREATED_BY
, CEL.CREATION_DATE
, CEL.PARTY_ID
FROM PER_COMPETENCE_ELEMENTS CEL
WHERE CEL.TYPE = 'ASSESSMENT_GROUP' UNION SELECT 1
, LOOKUP_CODE
, HR_GENERAL.DECODE_LOOKUP('COMPETENCE_TYPE'
, LOOKUP_CODE)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 'N'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'COMPETENCE_TYPE'

Columns