VIEW: APPS.PER_ZA_QUALIFICATION_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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