Search Results ahl_mr_effectivity_dtls

Overview

The MTL_MANUFACTURERS table is a core master data table within the Oracle E-Business Suite Inventory (INV) module. It serves as the central repository for defining and storing information about manufacturers, which are entities that produce items. This table is fundamental to the item definition and supplier data model, enabling the association of manufactured parts with their original producers. Its role extends beyond basic inventory tracking, supporting functionalities in procurement, engineering, and service management by providing a standardized reference for manufacturer identification across the application.

Key Information Stored

The table's primary purpose is to store unique manufacturer records. Its structure is defined by a key identifier and descriptive attributes. The most critical column is MANUFACTURER_ID, which serves as the primary key (MTL_MANUFACTURERS_PK) and uniquely identifies each manufacturer entity in the system. While the provided ETRM excerpt does not list all columns, standard implementation includes columns such as MANUFACTURER_NAME for the company name and potentially attributes for address, contact information, and descriptive flexfields for custom data capture. The table's design ensures each manufacturer is recorded once, maintaining data integrity.

Common Use Cases and Queries

A primary use case is the creation and maintenance of manufacturer records during item setup, often via the Item Master form. This data is subsequently referenced when defining manufacturer part numbers in the MTL_MFG_PART_NUMBERS table. Common reporting and integration queries involve joining this table to related objects. For instance, to list all items with their associated manufacturer names, a query would join MTL_SYSTEM_ITEMS_B to MTL_MFG_PART_NUMBERS and then to MTL_MANUFACTURERS. A basic query to retrieve all active manufacturers would follow the pattern: SELECT manufacturer_id, manufacturer_name FROM mtl_manufacturers WHERE disable_date IS NULL ORDER BY manufacturer_name;. This table is also critical for APIs used in item import and data conversion processes.

Related Objects

As indicated by the foreign key constraints in the metadata, MTL_MANUFACTURERS has direct relationships with several other tables. The most significant is MTL_MFG_PART_NUMBERS, which links specific item part numbers to a manufacturer in this table. Another key relationship is with AHL_MR_EFFECTIVITY_DTLS in the Complex Maintenance, Repair, and Overhaul (CMRO) product, showing its use in service and effectivity management. Furthermore, it is implicitly related to the core item master table, MTL_SYSTEM_ITEMS_B, through the manufacturer part number association. These relationships underscore its position as a shared reference table within the EBS manufacturing and supply chain architecture.