SELECT TERRITORY_CODE , DESCRIPTION , TERRITORY_SHORT_NAME From FND_TERRITORIES_VL UNION ALL select LOOKUP_CODE, MEANING, MEANING from AR_LOOKUPS where LOOKUP_TYPE='REMIT'
View Text - HTML Formatted
SELECT TERRITORY_CODE , DESCRIPTION , TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL UNION ALL SELECT LOOKUP_CODE , MEANING , MEANING FROM AR_LOOKUPS WHERE LOOKUP_TYPE='REMIT'