Results for “mrp_planning_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_MFG_PART_NUMBERS is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines manufacturer part numbers. It associates a specific manufacturer with the internal inventory item that represents the part they supply, effectively bridging the gap between Oracle's item master and externally-recognized vendor part identifiers. A single inventory item can be linked to multiple manufacturer part numbers, allowing procurement and quality teams to track which manufacturers produce or supply a given part.

Under the heuristic Data Vault classification mined from its foreign key structure, MTL_MFG_PART_NUMBERS is modeled as a link table. This is a modeling suggestion only: the table resolves a many-to-many relationship between manufacturers and inventory items, functioning as an associative entity rather than a standalone business hub or a descriptive satellite. Its primary key, MTL_MFG_PART_NUMBERS_PK, is a composite of MANUFACTURER_ID and MFG_PART_NUM.

Key Information Stored

The table stores 35 documented columns. The most significant are:

• MANUFACTURER_ID — foreign key to MTL_MANUFACTURERS; identifies the manufacturer of the part. Part of the primary key.
• MFG_PART_NUM — the manufacturer's own part number for the item. Part of the primary key.
• INVENTORY_ITEM_ID — foreign key to MTL_SYSTEM_ITEMS_B; the internal item that this manufacturer part maps to.
• ORGANIZATION_ID — foreign key to MTL_PARAMETERS; scopes the record to a specific inventory organization.
• DESCRIPTION — free-text description of the manufacturer part.
• MRP_PLANNING_CODE — controls MRP planning behavior for the part.
• START_DATE and END_DATE — effective dating for the manufacturer part association.
• APPROVAL_STATUS and FIRST_ARTICLE_STATUS — approval and first-article inspection status.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS flexible-attribute (descriptive flexfield) columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent-program audit columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns.

The surrogate primary key is MTL_MFG_PART_NUMBERS_PK (MANUFACTURER_ID, MFG_PART_NUM). The documented business-key candidate unique index is MTL_MFG_PART_NUMBERS_U1 (ORGANIZATION_ID, MANUFACTURER_ID, INVENTORY_ITEM_ID, MFG_PART_NUM), which enforces uniqueness within an organization across the manufacturer, item, and part number combination.

Common Use Cases and Queries

Typical scenarios include cross-referencing a customer- or vendor-supplied manufacturer part number to the internal item, building approved-manufacturer-parts reporting, and supporting receiving and quality inspection.

To retrieve all manufacturer parts for an item:

• SELECT mfgpart.mfg_part_num, mfg.manufacturer_name FROM mtl_mfg_part_numbers mfgpart, mtl_manufacturers mfg WHERE mfgpart.manufacturer_id = mfg.manufacturer_id AND mfgpart.inventory_item_id = :item_id;

To find the internal item for a known manufacturer part number:

• SELECT inventory_item_id FROM mtl_mfg_part_numbers WHERE mfg_part_num = :part_num AND organization_id = :org_id;

To list all manufacturer parts active within a date range, filter on START_DATE and END_DATE. Reporting use cases often join to MTL_SYSTEM_ITEMS_B for item segment descriptions and to MTL_MANUFACTURERS for supplier names.

Related Objects

The table is closely tied to the following objects through documented foreign keys and related relationships:

• MTL_MANUFACTURERS — joined on MTL_MFG_PART_NUMBERS.MANUFACTURER_ID = MTL_MANUFACTURERS.MANUFACTURER_ID.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID (and ORGANIZATION_ID) to resolve the internal item.
• MTL_PARAMETERS — joined on ORGANIZATION_ID to identify the inventory organization.
• MTL_ITEM_REVISIONS — item revision context commonly used alongside manufacturer parts.
• MTL_SYSTEM_ITEMS_TL — for translated item descriptions in reporting.
• MTL_ITEM_CATEGORIES / MTL_CATEGORIES_B — frequently joined for category-based manufacturer part reports.

These joins let developers and analysts reconstruct a complete view of item-to-manufacturer relationships within an inventory organization.