SELECT lookup_code as ID , meaning as VALUE from cs_lookups WHERE lookup_type = 'REQUEST_RESOLUTION_CODE' union all select '-1' , fnd_message.get_string('BIS','BIS_UNASSIGNED') from dual
View Text - HTML Formatted
SELECT LOOKUP_CODE AS ID , MEANING AS VALUE FROM CS_LOOKUPS WHERE LOOKUP_TYPE = 'REQUEST_RESOLUTION_CODE' UNION ALL SELECT '-1' , FND_MESSAGE.GET_STRING('BIS' , 'BIS_UNASSIGNED') FROM DUAL