DBA Data[Home] [Help]

VIEW: APPS.BIV_RESOLUTIONS_V

Source

View Text - Preformatted

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