FND Design Data [Home] [Help]

Table: FND_TERRITORIES

Product: FND - Application Object Library
Description: Territories, also known as countries
Implementation/DBA Data: TableAPPLSYS.FND_TERRITORIES
Primary Key: FND_TERRITORIES_PK
  1. ColumnTERRITORY_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAHL_MR_EFFECTIVITY_DTLS FK Joins to FND_TERRITORIES AHL_MR_EFFECTIVITY_DTLS.COUNTRY_CODE
TableAP_POL_LOCATIONS_B FK Joins to FND_TERRITORIES AP_POL_LOCATIONS_B.TERRITORY_CODE
TableFND_CURRENCIES FK Joins to FND_TERRITORIES FND_CURRENCIES.ISSUING_TERRITORY_CODE
TableFND_TERRITORIES_TL FK Joins to FND_TERRITORIES FND_TERRITORIES_TL.TERRITORY_CODE
TableGR_COUNTRY_PROFILES FK Joins to FND_TERRITORIES GR_COUNTRY_PROFILES.TERRITORY_CODE
TableHZ_CITIZENSHIP FK Joins to FND_TERRITORIES HZ_CITIZENSHIP.COUNTRY_CODE
TableHZ_GEOGRAPHIES FK Joins to FND_TERRITORIES HZ_GEOGRAPHIES.GEOGRAPHY_CODE
TableHZ_LOCATIONS FK Joins to FND_TERRITORIES HZ_LOCATIONS.COUNTRY
TableHZ_LOCATIONS FK Joins to FND_TERRITORIES HZ_LOCATIONS.COUNTRY
TableHZ_ORGANIZATION_PROFILES FK Joins to FND_TERRITORIES HZ_ORGANIZATION_PROFILES.HOME_COUNTRY
TableHZ_PARTIES FK Joins to FND_TERRITORIES HZ_PARTIES.HOME_COUNTRY
TableHZ_PHONE_COUNTRY_CODES FK Joins to FND_TERRITORIES HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE
TableHZ_STYLE_FMT_LOCALES FK Joins to FND_TERRITORIES HZ_STYLE_FMT_LOCALES.TERRITORY_CODE
TableHZ_WORD_REPLACEMENTS FK Joins to FND_TERRITORIES HZ_WORD_REPLACEMENTS.COUNTRY_CODE
TableIBY_BANK_INSTRUCTIONS_B FK Joins to FND_TERRITORIES IBY_BANK_INSTRUCTIONS_B.TERRITORY_CODE
TableIBY_CREDITCARD FK Joins to FND_TERRITORIES IBY_CREDITCARD.BILL_ADDR_TERRITORY_CODE
TableIBY_DELIVERY_CHANNELS_B FK Joins to FND_TERRITORIES IBY_DELIVERY_CHANNELS_B.TERRITORY_CODE
TableIBY_DOCUMENTS_PAYABLE_H FK Joins to FND_TERRITORIES IBY_DOCUMENTS_PAYABLE_H.COUNTRY
TableIBY_PAYMENTS_H FK Joins to FND_TERRITORIES IBY_PAYMENTS_H.COUNTRY
TableIBY_PAYMENT_REASONS_B FK Joins to FND_TERRITORIES IBY_PAYMENT_REASONS_B.TERRITORY_CODE
TableMTL_COUNTRY_ASSIGNMENTS FK Joins to FND_TERRITORIES MTL_COUNTRY_ASSIGNMENTS.TERRITORY_CODE
TableOKL_INS_RATES FK Joins to FND_TERRITORIES OKL_INS_RATES.IC_ID
TableOKL_INS_POLICIES_ALL_B FK Joins to FND_TERRITORIES OKL_INS_POLICIES_ALL_B.TERRITORY_CODE
TableOKL_INS_POLICIES_B FK Joins to FND_TERRITORIES OKL_INS_POLICIES_B.TERRITORY_CODE
TableOKL_SUBSIDY_CRITERIA FK Joins to FND_TERRITORIES OKL_SUBSIDY_CRITERIA.SALES_TERRITORY_CODE
TablePA_ASSIGNMENTS_HISTORY FK Joins to FND_TERRITORIES PA_ASSIGNMENTS_HISTORY.SEARCH_COUNTRY_CODE
TablePA_PROJECT_ASSIGNMENTS FK Joins to FND_TERRITORIES PA_PROJECT_ASSIGNMENTS.SEARCH_COUNTRY_CODE
TablePV_COUNTRY_RSBLTS FK Joins to FND_TERRITORIES PV_COUNTRY_RSBLTS.COUNTRY_CODE
TablePV_COUNTRY_TIMEOUTS FK Joins to FND_TERRITORIES PV_COUNTRY_TIMEOUTS.COUNTRY_CODE
TableRA_CUSTOMER_BANKS_INT_ALL FK Joins to FND_TERRITORIES RA_CUSTOMER_BANKS_INT_ALL.BANK_HOME_COUNTRY
TableXTR_COUNTRY_COMPANY_LIMITS FK Joins to FND_TERRITORIES XTR_COUNTRY_COMPANY_LIMITS.COUNTRY_CODE
TableZX_CONDITION_GROUPS_B FK Joins to FND_TERRITORIES ZX_CONDITION_GROUPS_B.COUNTRY_CODE
TableZX_FC_CODES_B FK Joins to FND_TERRITORIES ZX_FC_CODES_B.COUNTRY_CODE
TableZX_FC_CODES_DENORM_B FK Joins to FND_TERRITORIES ZX_FC_CODES_DENORM_B.COUNTRY_CODE
TableZX_FC_COUNTRY_DEFAULTS FK Joins to FND_TERRITORIES ZX_FC_COUNTRY_DEFAULTS.COUNTRY_CODE
TableZX_PARTY_TAX_PROFILE FK Joins to FND_TERRITORIES ZX_PARTY_TAX_PROFILE.COUNTRY_CODE
TableZX_REGIMES_B FK Joins to FND_TERRITORIES ZX_REGIMES_B.COUNTRY_CODE