SELECT ffc.CONTEXT_NAME ,ffc.CONTEXT_LEVEL ,hr_bis.bis_decode_lookup('DATA_TYPE', ffc.DATA_TYPE) DATA_TYPE ,ffc.DATA_TYPE DATA_TYPE_CODE ,ffc.CONTEXT_ID FROM ff_contexts ffc WITH READ ONLY
View Text - HTML Formatted
SELECT FFC.CONTEXT_NAME , FFC.CONTEXT_LEVEL , HR_BIS.BIS_DECODE_LOOKUP('DATA_TYPE' , FFC.DATA_TYPE) DATA_TYPE , FFC.DATA_TYPE DATA_TYPE_CODE , FFC.CONTEXT_ID FROM FF_CONTEXTS FFC WITH READ ONLY