DBA Data[Home] [Help]

VIEW: APPS.AR_REMIT_TO_COUNTRY

Source

View Text - Preformatted

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'