SELECT LOOKUP_CODE CODE ,userenv('LANG') LANGUAGE ,MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='RRS_HIERARCHY_PURPOSE' AND VIEW_APPLICATION_ID in (718) AND SECURITY_GROUP_ID = 0 AND LANGUAGE = userenv('LANG')
View Text - HTML Formatted
SELECT LOOKUP_CODE CODE , USERENV('LANG') LANGUAGE , MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='RRS_HIERARCHY_PURPOSE' AND VIEW_APPLICATION_ID IN (718) AND SECURITY_GROUP_ID = 0 AND LANGUAGE = USERENV('LANG')