VIEW: APPS.PER_COMPETENCE_ELEMENTS_V5

Source

View Text - Preformatted

SELECT /* $HEADER: $ */COMP.ROWID , COMP.COMPETENCE_ELEMENT_ID , COMP.BUSINESS_GROUP_ID , COMP.OBJECT_VERSION_NUMBER , COMP.TYPE , COMP.COMPETENCE_ID , CPL.NAME , CPN.UNIT_STANDARD_ID , COMP.EFFECTIVE_DATE_FROM , COMP.EFFECTIVE_DATE_TO , COMP.COMPETENCE_TYPE , COMP.LAST_UPDATE_DATE , COMP.LAST_UPDATED_BY , COMP.LAST_UPDATE_LOGIN , COMP.CREATED_BY , COMP.CREATION_DATE , COMP.QUALIFICATION_TYPE_ID , COMP.UNIT_STANDARD_TYPE , HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_UNIT_STD_TYPE',COMP.UNIT_STANDARD_TYPE) , COMP.STATUS , HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_COMP_STATUS',COMP.STATUS) , QUA.CREDIT_TYPE , QUA.CREDITS , QUA.LEVEL_TYPE , QUA.LEVEL_NUMBER , QUA.FIELD , QUA.SUB_FIELD , QUA.QUAL_FRAMEWORK_ID , QUA.QUALIFICATION_TYPE , QUATL.NAME , QUA.PROVIDER , QUA.QA_ORGANIZATION , COMP.ATTRIBUTE_CATEGORY , COMP.ATTRIBUTE1 , COMP.ATTRIBUTE2 , COMP.ATTRIBUTE3 , COMP.ATTRIBUTE4 , COMP.ATTRIBUTE5 , COMP.ATTRIBUTE6 , COMP.ATTRIBUTE7 , COMP.ATTRIBUTE8 , COMP.ATTRIBUTE9 , COMP.ATTRIBUTE10 , COMP.ATTRIBUTE11 , COMP.ATTRIBUTE12 , COMP.ATTRIBUTE13 , COMP.ATTRIBUTE14 , COMP.ATTRIBUTE15 , COMP.ATTRIBUTE16 , COMP.ATTRIBUTE17 , COMP.ATTRIBUTE18 , COMP.ATTRIBUTE19 , COMP.ATTRIBUTE20 , COMP.INFORMATION_CATEGORY , COMP.INFORMATION1 , COMP.INFORMATION2 , COMP.INFORMATION3 , COMP.INFORMATION4 , COMP.INFORMATION5 , COMP.INFORMATION6 , COMP.INFORMATION7 , COMP.INFORMATION8 , COMP.INFORMATION9 , COMP.INFORMATION10 , COMP.INFORMATION11 , COMP.INFORMATION12 , COMP.INFORMATION13 , COMP.INFORMATION14 , COMP.INFORMATION15 , COMP.INFORMATION16 , COMP.INFORMATION17 , COMP.INFORMATION18 , COMP.INFORMATION19 , COMP.INFORMATION20 FROM PER_COMPETENCES CPN , PER_COMPETENCES_TL CPL , PER_COMPETENCE_ELEMENTS COMP , PER_QUALIFICATION_TYPES QUA , PER_QUALIFICATION_TYPES_TL QUATL WHERE COMP.COMPETENCE_ID = CPN.COMPETENCE_ID AND COMP.TYPE = 'QUALIFICATION' AND CPL.COMPETENCE_ID = CPN.COMPETENCE_ID AND CPL.LANGUAGE(+) = userenv('LANG') AND COMP.QUALIFICATION_TYPE_ID = QUA.QUALIFICATION_TYPE_ID AND QUA.QUALIFICATION_TYPE_ID = QUATL.QUALIFICATION_TYPE_ID AND QUATL.LANGUAGE(+) = userenv('LANG')

View Text - HTML Formatted

SELECT /* $HEADER: $ */COMP.ROWID
, COMP.COMPETENCE_ELEMENT_ID
, COMP.BUSINESS_GROUP_ID
, COMP.OBJECT_VERSION_NUMBER
, COMP.TYPE
, COMP.COMPETENCE_ID
, CPL.NAME
, CPN.UNIT_STANDARD_ID
, COMP.EFFECTIVE_DATE_FROM
, COMP.EFFECTIVE_DATE_TO
, COMP.COMPETENCE_TYPE
, COMP.LAST_UPDATE_DATE
, COMP.LAST_UPDATED_BY
, COMP.LAST_UPDATE_LOGIN
, COMP.CREATED_BY
, COMP.CREATION_DATE
, COMP.QUALIFICATION_TYPE_ID
, COMP.UNIT_STANDARD_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_UNIT_STD_TYPE'
, COMP.UNIT_STANDARD_TYPE)
, COMP.STATUS
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_COMP_STATUS'
, COMP.STATUS)
, QUA.CREDIT_TYPE
, QUA.CREDITS
, QUA.LEVEL_TYPE
, QUA.LEVEL_NUMBER
, QUA.FIELD
, QUA.SUB_FIELD
, QUA.QUAL_FRAMEWORK_ID
, QUA.QUALIFICATION_TYPE
, QUATL.NAME
, QUA.PROVIDER
, QUA.QA_ORGANIZATION
, COMP.ATTRIBUTE_CATEGORY
, COMP.ATTRIBUTE1
, COMP.ATTRIBUTE2
, COMP.ATTRIBUTE3
, COMP.ATTRIBUTE4
, COMP.ATTRIBUTE5
, COMP.ATTRIBUTE6
, COMP.ATTRIBUTE7
, COMP.ATTRIBUTE8
, COMP.ATTRIBUTE9
, COMP.ATTRIBUTE10
, COMP.ATTRIBUTE11
, COMP.ATTRIBUTE12
, COMP.ATTRIBUTE13
, COMP.ATTRIBUTE14
, COMP.ATTRIBUTE15
, COMP.ATTRIBUTE16
, COMP.ATTRIBUTE17
, COMP.ATTRIBUTE18
, COMP.ATTRIBUTE19
, COMP.ATTRIBUTE20
, COMP.INFORMATION_CATEGORY
, COMP.INFORMATION1
, COMP.INFORMATION2
, COMP.INFORMATION3
, COMP.INFORMATION4
, COMP.INFORMATION5
, COMP.INFORMATION6
, COMP.INFORMATION7
, COMP.INFORMATION8
, COMP.INFORMATION9
, COMP.INFORMATION10
, COMP.INFORMATION11
, COMP.INFORMATION12
, COMP.INFORMATION13
, COMP.INFORMATION14
, COMP.INFORMATION15
, COMP.INFORMATION16
, COMP.INFORMATION17
, COMP.INFORMATION18
, COMP.INFORMATION19
, COMP.INFORMATION20
FROM PER_COMPETENCES CPN
, PER_COMPETENCES_TL CPL
, PER_COMPETENCE_ELEMENTS COMP
, PER_QUALIFICATION_TYPES QUA
, PER_QUALIFICATION_TYPES_TL QUATL
WHERE COMP.COMPETENCE_ID = CPN.COMPETENCE_ID
AND COMP.TYPE = 'QUALIFICATION'
AND CPL.COMPETENCE_ID = CPN.COMPETENCE_ID
AND CPL.LANGUAGE(+) = USERENV('LANG')
AND COMP.QUALIFICATION_TYPE_ID = QUA.QUALIFICATION_TYPE_ID
AND QUA.QUALIFICATION_TYPE_ID = QUATL.QUALIFICATION_TYPE_ID
AND QUATL.LANGUAGE(+) = USERENV('LANG')