SELECT lookup_code id ,meaning value ,description description FROM fnd_lookup_values WHERE lookup_type = 'IBW_SITE_AREA' AND enabled_flag = 'Y' AND language = userenv ('lang')
View Text - HTML Formatted
SELECT LOOKUP_CODE ID , MEANING VALUE , DESCRIPTION DESCRIPTION FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'IBW_SITE_AREA' AND ENABLED_FLAG = 'Y' AND LANGUAGE = USERENV ('LANG')