DBA Data[Home] [Help]

VIEW: APPS.BIS_SEEDED_MEASURE_REPORT_V

Source

View Text - Preformatted

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'