View: PER_ZA_QUALIFICATION_TYPES_V

Product:	PER - Human Resources
Description:	PER_ZA_QUALIFICATION_TYPES_V is used to maintain table PER_ZA_QUALIFICATION_TYPES via NQF forms.
Implementation/DBA Data:	APPS.PER_ZA_QUALIFICATION_TYPES_V

View Text

SELECT EQT.ROWID ROW_ID
, EQT.QUALIFICATION_TYPE_ID
, NQT.NQF_QUALIFICATION_TYPE
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_QUALIFICATION_TYPES'
, NQT.NQF_QUALIFICATION_TYPE) NQF_QUALIFICATION_TYPE_MEANING
, EQT.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.LAST_UPDATE_DATE
, EQT.LAST_UPDATED_BY
, EQT.LAST_UPDATE_LOGIN
, EQT.CREATED_BY
, EQT.CREATION_DATE
FROM PER_QUALIFICATION_TYPES EQT
, PER_ZA_QUALIFICATION_TYPES NQT
WHERE NQT.QUALIFICATION_TYPE_ID(+) = EQT.QUALIFICATION_TYPE_ID

Columns