SELECT lookup_code id, meaning value FROM FND_LOOKUP_VALUES WHERE lookup_type = 'CREDIT_MEMO_REASON' AND LANGUAGE = userenv('LANG') AND view_application_id = 222 AND security_group_id = 0
View Text - HTML Formatted
SELECT LOOKUP_CODE ID , MEANING VALUE FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'CREDIT_MEMO_REASON' AND LANGUAGE = USERENV('LANG') AND VIEW_APPLICATION_ID = 222 AND SECURITY_GROUP_ID = 0