VIEW: APPS.HRBV_QUALIFICATION_TYPES_V

Source

View Text - Preformatted

SELECT EQTL.NAME, EQT.CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES',EQT.CATEGORY), EQT.RANK, 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.INFORMATION_CATEGORY, '_DF:PER:PER_QUALIFICATION_TYPES:EQT', EQT.QUALIFICATION_TYPE_ID, EQT.LAST_UPDATE_DATE, EQT.LAST_UPDATED_BY, EQT.CREATED_BY, EQT.CREATION_DATE FROM PER_QUALIFICATION_TYPES EQT, PER_QUALIFICATION_TYPES_TL EQTL WHERE EQT.QUALIFICATION_TYPE_ID = EQTL.QUALIFICATION_TYPE_ID AND EQTL.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT EQTL.NAME
, EQT.CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES'
, EQT.CATEGORY)
, EQT.RANK
, 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.INFORMATION_CATEGORY
, '_DF:PER:PER_QUALIFICATION_TYPES:EQT'
, EQT.QUALIFICATION_TYPE_ID
, EQT.LAST_UPDATE_DATE
, EQT.LAST_UPDATED_BY
, EQT.CREATED_BY
, EQT.CREATION_DATE
FROM PER_QUALIFICATION_TYPES EQT
, PER_QUALIFICATION_TYPES_TL EQTL
WHERE EQT.QUALIFICATION_TYPE_ID = EQTL.QUALIFICATION_TYPE_ID
AND EQTL.LANGUAGE = USERENV('LANG') WITH READ ONLY