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]

Table: FND_TERRITORIES

Product:	FND - Application Object Library
Description:	Territories, also known as countries
Implementation/DBA Data:	APPLSYS.FND_TERRITORIES

Primary Key: FND_TERRITORIES_PK

TERRITORY_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_MR_EFFECTIVITY_DTLS	FND_TERRITORIES	AHL_MR_EFFECTIVITY_DTLS.COUNTRY_CODE
AP_POL_LOCATIONS_B	FND_TERRITORIES	AP_POL_LOCATIONS_B.TERRITORY_CODE
FND_CURRENCIES	FND_TERRITORIES	FND_CURRENCIES.ISSUING_TERRITORY_CODE
FND_TERRITORIES_TL	FND_TERRITORIES	FND_TERRITORIES_TL.TERRITORY_CODE
GR_COUNTRY_PROFILES	FND_TERRITORIES	GR_COUNTRY_PROFILES.TERRITORY_CODE
HZ_CITIZENSHIP	FND_TERRITORIES	HZ_CITIZENSHIP.COUNTRY_CODE
HZ_GEOGRAPHIES	FND_TERRITORIES	HZ_GEOGRAPHIES.GEOGRAPHY_CODE
HZ_LOCATIONS	FND_TERRITORIES	HZ_LOCATIONS.COUNTRY
HZ_LOCATIONS	FND_TERRITORIES	HZ_LOCATIONS.COUNTRY
HZ_ORGANIZATION_PROFILES	FND_TERRITORIES	HZ_ORGANIZATION_PROFILES.HOME_COUNTRY
HZ_PARTIES	FND_TERRITORIES	HZ_PARTIES.HOME_COUNTRY
HZ_PHONE_COUNTRY_CODES	FND_TERRITORIES	HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE
HZ_STYLE_FMT_LOCALES	FND_TERRITORIES	HZ_STYLE_FMT_LOCALES.TERRITORY_CODE
HZ_WORD_REPLACEMENTS	FND_TERRITORIES	HZ_WORD_REPLACEMENTS.COUNTRY_CODE
IBY_BANK_INSTRUCTIONS_B	FND_TERRITORIES	IBY_BANK_INSTRUCTIONS_B.TERRITORY_CODE
IBY_CREDITCARD	FND_TERRITORIES	IBY_CREDITCARD.BILL_ADDR_TERRITORY_CODE
IBY_DELIVERY_CHANNELS_B	FND_TERRITORIES	IBY_DELIVERY_CHANNELS_B.TERRITORY_CODE
IBY_DOCUMENTS_PAYABLE_H	FND_TERRITORIES	IBY_DOCUMENTS_PAYABLE_H.COUNTRY
IBY_PAYMENTCARD	FND_TERRITORIES	IBY_PAYMENTCARD.BILL_ADDR_TERRITORY_CODE
IBY_PAYMENTS_H	FND_TERRITORIES	IBY_PAYMENTS_H.COUNTRY
IBY_PAYMENT_REASONS_B	FND_TERRITORIES	IBY_PAYMENT_REASONS_B.TERRITORY_CODE
IBY_VAL_ASSIGNMENTS	FND_TERRITORIES	IBY_VAL_ASSIGNMENTS.TERRITORY_CODE
MTL_COUNTRY_ASSIGNMENTS	FND_TERRITORIES	MTL_COUNTRY_ASSIGNMENTS.TERRITORY_CODE
OKL_INS_RATES	FND_TERRITORIES	OKL_INS_RATES.IC_ID
OKL_INS_POLICIES_ALL_B	FND_TERRITORIES	OKL_INS_POLICIES_ALL_B.TERRITORY_CODE
OKL_INS_POLICIES_B	FND_TERRITORIES	OKL_INS_POLICIES_B.TERRITORY_CODE
OKL_SUBSIDY_CRITERIA	FND_TERRITORIES	OKL_SUBSIDY_CRITERIA.SALES_TERRITORY_CODE
PA_ASSIGNMENTS_HISTORY	FND_TERRITORIES	PA_ASSIGNMENTS_HISTORY.SEARCH_COUNTRY_CODE
PA_PROJECT_ASSIGNMENTS	FND_TERRITORIES	PA_PROJECT_ASSIGNMENTS.SEARCH_COUNTRY_CODE
POS_SUPPLIER_REGISTRATIONS	FND_TERRITORIES	POS_SUPPLIER_REGISTRATIONS.COUNTRY
POS_SUP_BANK_ACCOUNT_REQUESTS	FND_TERRITORIES	POS_SUP_BANK_ACCOUNT_REQUESTS.COUNTRY
PV_COUNTRY_RSBLTS	FND_TERRITORIES	PV_COUNTRY_RSBLTS.COUNTRY_CODE
PV_COUNTRY_TIMEOUTS	FND_TERRITORIES	PV_COUNTRY_TIMEOUTS.COUNTRY_CODE
RA_CUSTOMER_BANKS_INT_ALL	FND_TERRITORIES	RA_CUSTOMER_BANKS_INT_ALL.BANK_HOME_COUNTRY
XTR_COUNTRY_COMPANY_LIMITS	FND_TERRITORIES	XTR_COUNTRY_COMPANY_LIMITS.COUNTRY_CODE
ZX_CONDITION_GROUPS_B	FND_TERRITORIES	ZX_CONDITION_GROUPS_B.COUNTRY_CODE
ZX_FC_CODES_B	FND_TERRITORIES	ZX_FC_CODES_B.COUNTRY_CODE
ZX_FC_CODES_DENORM_B	FND_TERRITORIES	ZX_FC_CODES_DENORM_B.COUNTRY_CODE
ZX_FC_COUNTRY_DEFAULTS	FND_TERRITORIES	ZX_FC_COUNTRY_DEFAULTS.COUNTRY_CODE
ZX_PARTY_TAX_PROFILE	FND_TERRITORIES	ZX_PARTY_TAX_PROFILE.COUNTRY_CODE
ZX_REGIMES_B	FND_TERRITORIES	ZX_REGIMES_B.COUNTRY_CODE