SELECT lookup_code, DECODE(lookup_code, 'AUTO', 'BSC', 'EXISTING', 'PMF', lookup_code) id, meaning value FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_KPI_REPORT_TYPE'
View Text - HTML Formatted
SELECT LOOKUP_CODE , DECODE(LOOKUP_CODE , 'AUTO' , 'BSC' , 'EXISTING' , 'PMF' , LOOKUP_CODE) ID , MEANING VALUE FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'BIS_KPI_REPORT_TYPE'