Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_QUALIFICATION_TYPES_V |
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
FROM PER_QUALIFICATION_TYPES EQT
, PER_QUALIFICATION_TYPES_TL QTT
WHERE EQT.QUALIFICATION_TYPE_ID = QTT.QUALIFICATION_TYPE_ID
AND QTT.LANGUAGE = USERENV('LANG')