SELECT LOOKUP_CODE CODE ,userenv('LANG') LANGUAGE ,MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE IN ( 'PARTY_SITE_USE_CODE' , 'RRS_SITE_PURPOSE') AND VIEW_APPLICATION_ID in (222,718) AND SECURITY_GROUP_ID = 0 AND LANGUAGE = userenv('LANG')
SELECT LOOKUP_CODE CODE
, USERENV('LANG') LANGUAGE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE IN ( 'PARTY_SITE_USE_CODE'
, 'RRS_SITE_PURPOSE')
AND VIEW_APPLICATION_ID IN (222
, 718)
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG')
|
|
|