Table: MTL_LE_ECONOMIC_ZONES | Oracle EBS ETRM Search

Table: MTL_LE_ECONOMIC_ZONES 12.1.1 link

owner INV·INV - Inventory·7 columns

stores information concerning the assignment of legal entity to economic zones.

INV.MTL_LE_ECONOMIC_ZONES·Explore INV module →

Table: MTL_ECONOMIC_ZONES_B 12.2.2 hub-leaning

owner INV·INV - Inventory·7 columns

Stores information concerning all the economic zones.

INV.MTL_ECONOMIC_ZONES_B·Explore INV module →

Table: MTL_LE_ECONOMIC_ZONES 12.2.2 link

owner INV·INV - Inventory·7 columns

stores information concerning the assignment of legal entity to economic zones.

INV.MTL_LE_ECONOMIC_ZONES·Explore INV module →

View: MTL_COUNTRY_ASSIGNMENTS_V 12.2.2

INV - Inventory·11 columns

View joins territories and country assignments

APPS.MTL_COUNTRY_ASSIGNMENTS_V·↳ FND_TERRITORIES_VL·↳ MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

View: MTL_STAT_TYPE_USAGES_V 12.2.2

INV - Inventory·38 columns

Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations

APPS.MTL_STAT_TYPE_USAGES_V·↳ GL_PERIOD_TYPES·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore INV module →

Table: MTL_MATERIAL_STATUS_HISTORY 12.1.1 link

owner INV·INV - Inventory·42 columns

Inventory status update history - Used by WMS only

INV.MTL_MATERIAL_STATUS_HISTORY·Explore INV module →

Table: MTL_ECONOMIC_ZONES_B 12.1.1 hub-leaning

owner INV·INV - Inventory·6 columns

Stores information concerning all the economic zones.

INV.MTL_ECONOMIC_ZONES_B·Explore INV module →

Table: MTL_COUNTRY_ASSIGNMENTS 12.1.1 link

owner INV·INV - Inventory·9 columns

stores information concerning the assignment of countries to economic zones.

INV.MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

View: MTL_ECONOMIC_ZONES_VL 12.2.2

INV - Inventory·9 columns

Joins the base economic zone table and translated economic zone table

APPS.MTL_ECONOMIC_ZONES_VL·↳ MTL_ECONOMIC_ZONES_B·↳ MTL_ECONOMIC_ZONES_TL·Explore INV module →

View: MTL_ECONOMIC_ZONES_VL 12.1.1

INV - Inventory·9 columns

Joins the base economic zone table and translated economic zone table

APPS.MTL_ECONOMIC_ZONES_VL·↳ MTL_ECONOMIC_ZONES_B·↳ MTL_ECONOMIC_ZONES_TL·Explore INV module →

Table: MTL_ECONOMIC_ZONES_TL 12.1.1 satellite-leaning

owner INV·INV - Inventory·10 columns

Corresponding transalation table for MTL_ECONOMIC_ZONES_B.

INV.MTL_ECONOMIC_ZONES_TL·Explore INV module →

View: MTL_LE_ECONOMIC_ZONES_V 12.2.2

INV - Inventory·11 columns

Join between the table MTL_Le_Economic_Zones, the view MTL_Economic_Zones_VL and HR_Legal_Entities

APPS.MTL_LE_ECONOMIC_ZONES_V·↳ MTL_ECONOMIC_ZONES_VL·↳ MTL_LE_ECONOMIC_ZONES·↳ XLE_FIRSTPARTY_INFORMATION_V·Explore INV module →

View: MTL_COUNTRY_ASSIGNMENTS_V 12.1.1

INV - Inventory·11 columns

View joins territories and country assignments

APPS.MTL_COUNTRY_ASSIGNMENTS_V·↳ FND_TERRITORIES_VL·↳ MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

Table: MTL_MOVEMENT_STATISTICS 12.2.2 standalone

owner INV·INV - Inventory·146 columns

Stores all relevant information for movement statistics transactions.

INV.MTL_MOVEMENT_STATISTICS·Explore INV module →

Table: MTL_COUNTRY_ASSIGNMENTS 12.2.2 link

owner INV·INV - Inventory·10 columns

stores information concerning the assignment of countries to economic zones.

INV.MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

Table: MTL_ECONOMIC_ZONES_TL 12.2.2 satellite-leaning

owner INV·INV - Inventory·11 columns

Corresponding transalation table for MTL_ECONOMIC_ZONES_B.

INV.MTL_ECONOMIC_ZONES_TL·Explore INV module →

View: MTL_LE_ECONOMIC_ZONES_V 12.1.1

INV - Inventory·11 columns

Join between the table MTL_Le_Economic_Zones, the view MTL_Economic_Zones_VL and HR_Legal_Entities

APPS.MTL_LE_ECONOMIC_ZONES_V·↳ MTL_ECONOMIC_ZONES_VL·↳ MTL_LE_ECONOMIC_ZONES·↳ XLE_FIRSTPARTY_INFORMATION_V·Explore INV module →

Table: MTL_STAT_TYPE_USAGES 12.1.1 link

owner INV·INV - Inventory·32 columns

Stores information which determines the statistical type data for each legal entity.

INV.MTL_STAT_TYPE_USAGES·Explore INV module →

Table: MTL_STAT_TYPE_USAGES 12.2.2 link

owner INV·INV - Inventory·32 columns

Stores information which determines the statistical type data for each legal entity.

INV.MTL_STAT_TYPE_USAGES·Explore INV module →

Table: MTL_MATERIAL_STATUS_HISTORY 12.2.2 link

owner INV·INV - Inventory·44 columns

Inventory status update history - Used by WMS only

INV.MTL_MATERIAL_STATUS_HISTORY·Explore INV module →

View: MTL_STAT_TYPE_USAGES_V 12.1.1

INV - Inventory·38 columns

Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations

APPS.MTL_STAT_TYPE_USAGES_V·↳ GL_PERIOD_TYPES·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore INV module →

Table: MTL_MOVEMENT_STATISTICS 12.1.1 standalone

owner INV·INV - Inventory·146 columns

Stores all relevant information for movement statistics transactions.

INV.MTL_MOVEMENT_STATISTICS·Explore INV module →

View: MTL_GRD_STS_HISTORY_V 12.1.1

INV - Inventory·15 columns

APPS.MTL_GRD_STS_HISTORY_V·↳ MTL_LOT_GRADE_HISTORY·↳ MTL_MATERIAL_STATUSES·↳ MTL_MATERIAL_STATUS_HISTORY·Explore INV module →

View: MTL_GRD_STS_HISTORY_V 12.2.2

INV - Inventory·19 columns

APPS.MTL_GRD_STS_HISTORY_V·↳ MTL_LOT_GRADE_HISTORY·↳ MTL_MATERIAL_STATUSES·↳ MTL_MATERIAL_STATUS_HISTORY·Explore INV module →

View: MTL_MOVEMENT_STATISTICS_V 12.1.1

INV - Inventory

Not implemented in this database·Explore INV module →

View: MTL_MOVEMENT_STATISTICS_V 12.2.2

INV - Inventory

Not implemented in this database·Explore INV module →

Results for “zone_code”