Search Results mtl_le_economic_zones_pk




Overview
Explore in AI Chat

Overview

The MTL_LE_ECONOMIC_ZONES table is a foundational data structure within the Oracle E-Business Suite (EBS) Inventory (INV) module, specifically for releases 12.1.1 and 12.2.2. Its primary role is to manage the assignment of legal entities to predefined economic zones. This mapping is critical for supporting complex financial and logistical operations that are governed by regional economic regulations, such as intra-community trade within the European Union. The table acts as a junction, enforcing a many-to-many relationship between legal entities (stored in HRMS tables) and the economic zones defined within the Inventory module, thereby enabling system-wide compliance and reporting based on these associations.

Key Information Stored

The table is designed with a concise structure centered on its composite primary key. The two key columns are LEGAL_ENTITY_ID and ZONE_CODE. The LEGAL_ENTITY_ID is a foreign key that references the ORGANIZATION_ID in the HR_ALL_ORGANIZATION_UNITS table, specifically identifying the organization classified as a legal entity. The ZONE_CODE is a foreign key referencing the ZONE_CODE in the MTL_ECONOMIC_ZONES_B table, which holds the master definition of all economic zones configured in the system. The combination of these two columns forms the primary key (MTL_LE_ECONOMIC_ZONES_PK), ensuring that a legal entity cannot be assigned to the same economic zone more than once.

Common Use Cases and Queries

This table is essential for transactions and reports that require determining the applicable economic zone for a given legal entity. A common use case is during the creation of an intra-community invoice, where the system must validate that both the shipping and receiving legal entities belong to permissible economic zones. For reporting, it is used to list all economic zones a specific legal entity operates within. A typical query would join this table to the HR and economic zones master tables to produce a readable report:

  • SELECT hou.name legal_entity, mez.zone_code, mez.name zone_name
  • FROM inv.mtl_le_economic_zones mlez,
  • hr_all_organization_units hou,
  • inv.mtl_economic_zones_b mez
  • WHERE mlez.legal_entity_id = hou.organization_id
  • AND mlez.zone_code = mez.zone_code
  • ORDER BY hou.name;

Related Objects

The MTL_LE_ECONOMIC_ZONES table maintains defined foreign key relationships with two core tables, as documented in the ETRM metadata. These relationships are fundamental to its integrity and function:

  • HR_ALL_ORGANIZATION_UNITS: The LEGAL_ENTITY_ID column in MTL_LE_ECONOMIC_ZONES references the ORGANIZATION_ID in this HR table. This links the economic zone assignment to a valid legal entity defined in the organization hierarchy.
  • MTL_ECONOMIC_ZONES_B: The ZONE_CODE column in MTL_LE_ECONOMIC_ZONES references the ZONE_CODE in this master table. This ensures that only a pre-defined economic zone from the Inventory module can be assigned to a legal entity.