SELECT LOOKUP_CODE CODE, userenv('LANG') LANGUAGE, MEANING FROM RRS_LOOKUPS_V WHERE LOOKUP_TYPE = 'RRS_SITE_LOCATIONS' UNION SELECT TERRITORY_CODE CODE, userenv('LANG') LANGUAGE, TERRITORY_SHORT_NAME MEANING FROM FND_TERRITORIES_VL
SELECT LOOKUP_CODE CODE
, USERENV('LANG') LANGUAGE
, MEANING
FROM RRS_LOOKUPS_V
WHERE LOOKUP_TYPE = 'RRS_SITE_LOCATIONS' UNION SELECT TERRITORY_CODE CODE
, USERENV('LANG') LANGUAGE
, TERRITORY_SHORT_NAME MEANING
FROM FND_TERRITORIES_VL
|
|
|