eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_REMIT_TO_COUNTRY

Product:	AR - Receivables
Description:	Combines FND_TERRITORIES and AR_LOOKUPS
Implementation/DBA Data:	APPS.AR_REMIT_TO_COUNTRY

View Text

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'

Columns

Name
COUNTRY_CODE
DESCRIPTION
COUNTRY