VIEW: APPS.PER_QUALIFICATION_TYPES_V

Source

View Text - Preformatted

SELECT EQT.ROWID ROW_ID , EQT.QUALIFICATION_TYPE_ID , QTT.NAME , EQT.CATEGORY , HR_GENERAL.DECODE_LOOKUP('PER_CATEGORIES',EQT.CATEGORY) CATEGORY_MEANING, EQT.RANK , EQT.OBJECT_VERSION_NUMBER , EQT.ATTRIBUTE_CATEGORY , EQT.ATTRIBUTE1 , EQT.ATTRIBUTE2 , EQT.ATTRIBUTE3 , EQT.ATTRIBUTE4 , EQT.ATTRIBUTE5 , EQT.ATTRIBUTE6 , EQT.ATTRIBUTE7 , EQT.ATTRIBUTE8 , EQT.ATTRIBUTE9 , EQT.ATTRIBUTE10 , EQT.ATTRIBUTE11 , EQT.ATTRIBUTE12 , EQT.ATTRIBUTE13 , EQT.ATTRIBUTE14 , EQT.ATTRIBUTE15 , EQT.ATTRIBUTE16 , EQT.ATTRIBUTE17 , EQT.ATTRIBUTE18 , EQT.ATTRIBUTE19 , EQT.ATTRIBUTE20 , EQT.INFORMATION_CATEGORY, EQT.INFORMATION1, EQT.INFORMATION2, EQT.INFORMATION3, EQT.INFORMATION4, EQT.INFORMATION5, EQT.INFORMATION6, EQT.INFORMATION7, EQT.INFORMATION8, EQT.INFORMATION9, EQT.INFORMATION10, EQT.INFORMATION11, EQT.INFORMATION12, EQT.INFORMATION13, EQT.INFORMATION14, EQT.INFORMATION15, EQT.INFORMATION16, EQT.INFORMATION17, EQT.INFORMATION18, EQT.INFORMATION19, EQT.INFORMATION20, EQT.INFORMATION21, EQT.INFORMATION22, EQT.INFORMATION23, EQT.INFORMATION24, EQT.INFORMATION25, EQT.INFORMATION26, EQT.INFORMATION27, EQT.INFORMATION28, EQT.INFORMATION29, EQT.INFORMATION30, EQT.LAST_UPDATE_DATE , EQT.LAST_UPDATED_BY , EQT.LAST_UPDATE_LOGIN , EQT.CREATED_BY , EQT.CREATION_DATE ,EQT.QUAL_FRAMEWORK_ID ,EQT.QUALIFICATION_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QUAL_TYPE',EQT.QUALIFICATION_TYPE) ,EQT.CREDIT_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE',EQT.CREDIT_TYPE) ,EQT.CREDITS ,EQT.LEVEL_TYPE ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE',EQT.LEVEL_TYPE) ,EQT.LEVEL_NUMBER ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL',EQT.LEVEL_NUMBER) ,EQT.FIELD ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_FIELD',EQT.FIELD) ,EQT.SUB_FIELD ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD',EQT.SUB_FIELD) ,EQT.PROVIDER ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER',EQT.PROVIDER) ,EQT.QA_ORGANIZATION ,HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QA_ORG',EQT.QA_ORGANIZATION) FROM PER_QUALIFICATION_TYPES EQT , PER_QUALIFICATION_TYPES_TL QTT WHERE EQT.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID AND QTT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT EQT.ROWID ROW_ID
, EQT.QUALIFICATION_TYPE_ID
, QTT.NAME
, EQT.CATEGORY
, HR_GENERAL.DECODE_LOOKUP('PER_CATEGORIES'
, EQT.CATEGORY) CATEGORY_MEANING
, EQT.RANK
, EQT.OBJECT_VERSION_NUMBER
, EQT.ATTRIBUTE_CATEGORY
, EQT.ATTRIBUTE1
, EQT.ATTRIBUTE2
, EQT.ATTRIBUTE3
, EQT.ATTRIBUTE4
, EQT.ATTRIBUTE5
, EQT.ATTRIBUTE6
, EQT.ATTRIBUTE7
, EQT.ATTRIBUTE8
, EQT.ATTRIBUTE9
, EQT.ATTRIBUTE10
, EQT.ATTRIBUTE11
, EQT.ATTRIBUTE12
, EQT.ATTRIBUTE13
, EQT.ATTRIBUTE14
, EQT.ATTRIBUTE15
, EQT.ATTRIBUTE16
, EQT.ATTRIBUTE17
, EQT.ATTRIBUTE18
, EQT.ATTRIBUTE19
, EQT.ATTRIBUTE20
, EQT.INFORMATION_CATEGORY
, EQT.INFORMATION1
, EQT.INFORMATION2
, EQT.INFORMATION3
, EQT.INFORMATION4
, EQT.INFORMATION5
, EQT.INFORMATION6
, EQT.INFORMATION7
, EQT.INFORMATION8
, EQT.INFORMATION9
, EQT.INFORMATION10
, EQT.INFORMATION11
, EQT.INFORMATION12
, EQT.INFORMATION13
, EQT.INFORMATION14
, EQT.INFORMATION15
, EQT.INFORMATION16
, EQT.INFORMATION17
, EQT.INFORMATION18
, EQT.INFORMATION19
, EQT.INFORMATION20
, EQT.INFORMATION21
, EQT.INFORMATION22
, EQT.INFORMATION23
, EQT.INFORMATION24
, EQT.INFORMATION25
, EQT.INFORMATION26
, EQT.INFORMATION27
, EQT.INFORMATION28
, EQT.INFORMATION29
, EQT.INFORMATION30
, EQT.LAST_UPDATE_DATE
, EQT.LAST_UPDATED_BY
, EQT.LAST_UPDATE_LOGIN
, EQT.CREATED_BY
, EQT.CREATION_DATE
, EQT.QUAL_FRAMEWORK_ID
, EQT.QUALIFICATION_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QUAL_TYPE'
, EQT.QUALIFICATION_TYPE)
, EQT.CREDIT_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_CREDIT_TYPE'
, EQT.CREDIT_TYPE)
, EQT.CREDITS
, EQT.LEVEL_TYPE
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL_TYPE'
, EQT.LEVEL_TYPE)
, EQT.LEVEL_NUMBER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_LEVEL'
, EQT.LEVEL_NUMBER)
, EQT.FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_FIELD'
, EQT.FIELD)
, EQT.SUB_FIELD
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_SUB_FIELD'
, EQT.SUB_FIELD)
, EQT.PROVIDER
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_PROVIDER'
, EQT.PROVIDER)
, EQT.QA_ORGANIZATION
, HR_GENERAL.DECODE_LOOKUP('PER_QUAL_FWK_QA_ORG'
, EQT.QA_ORGANIZATION)
FROM PER_QUALIFICATION_TYPES EQT
, PER_QUALIFICATION_TYPES_TL QTT
WHERE EQT.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')