Search Results mtl_country_assignments




Overview
Explore in AI Chat

Overview

The MTL_COUNTRY_ASSIGNMENTS table is a core reference table within the Oracle E-Business Suite Inventory (INV) module. Its primary function is to manage the association between countries and defined economic zones. This mapping is essential for enabling regionalized business logic, particularly for trade compliance, reporting, and the application of specific rules or tariffs based on economic groupings. The table acts as a junction, linking the master list of countries (FND_TERRITORIES) with user-defined economic zones (MTL_ECONOMIC_ZONES_B), thereby providing a flexible framework for configuring and maintaining geographic trade hierarchies within the application.

Key Information Stored

The table's structure is straightforward, consisting primarily of two key foreign key columns that form its composite primary key. The ZONE_CODE column stores the unique identifier for an economic zone as defined in the MTL_ECONOMIC_ZONES_B table. The TERRITORY_CODE column stores the two-character ISO territory code corresponding to a country in the FND_TERRITORIES table. Each record represents a single assignment of a specific country to a specific economic zone. The integrity of this data is enforced by the primary key constraint (MTL_COUNTRY_ASSIGNMENTS_PK) and the two documented foreign key constraints, ensuring referential integrity with the parent tables.

Common Use Cases and Queries

This table is predominantly used in background processes and reports that require filtering or grouping data by economic region. A common use case is generating trade reports that summarize transaction volumes or values by economic zone rather than by individual country. It is also critical for compliance engines that need to validate shipping or procurement transactions against zone-specific regulations. A typical query would join this table to obtain a list of all countries within a zone or to find the zone for a given country.

  • Finding all countries assigned to a specific economic zone: 
    SELECT TERRITORY_CODE, TERRITORY_SHORT_NAME
FROM MTL_COUNTRY_ASSIGNMENTS MCA, FND_TERRITORIES FT
WHERE MCA.TERRITORY_CODE = FT.TERRITORY_CODE
AND MCA.ZONE_CODE = '&ZONE_CODE';
  • Identifying the economic zone for a specific country: 
    SELECT ZONE_CODE, ZONE_NAME
FROM MTL_COUNTRY_ASSIGNMENTS MCA, MTL_ECONOMIC_ZONES_B MEZ
WHERE MCA.ZONE_CODE = MEZ.ZONE_CODE
AND MCA.TERRITORY_CODE = '&TERRITORY_CODE';

Related Objects

As indicated by its foreign keys, MTL_COUNTRY_ASSIGNMENTS has direct dependencies on two primary reference tables. The MTL_ECONOMIC_ZONES_B table is the master definition for all economic zones configured in the system. The FND_TERRITORIES table is the Oracle E-Business Suite foundation table containing the global list of countries and territories. This table is likely referenced by various Inventory and related trade management interfaces, reports, and potentially by APIs that validate or default zone information based on a transaction's country context. Its data is typically maintained through the application's user interface for defining economic zones.