Search Results mrp_item_suppliers




Overview
Explore in AI Chat

Overview

The MRP_ITEM_SUPPLIERS table is a core data repository within the Oracle E-Business Suite Master Scheduling/MRP module. Its primary function is to store and manage supplier-specific sourcing information for inventory items. This table enables the planning engine to consider approved suppliers, their sites, and associated item attributes during Material Requirements Planning (MRP) and Master Production Scheduling (MPS) runs. By maintaining these relationships, it supports strategic sourcing decisions, supplier capacity planning, and the generation of planned purchase orders based on preferred or allocated suppliers.

Key Information Stored

The table's structure centers on uniquely identifying an item-supplier relationship within a specific organizational and planning context. Its composite primary key underscores this, comprising the COMPILE_DESIGNATOR (identifying the specific MRP/MPS plan), SUPPLIER_ID, SUPPLIER_SITE_ID, ORGANIZATION_ID (where the item is defined), INVENTORY_ITEM_ID, and USING_ORGANIZATION_ID. Key columns typically include supplier-related item attributes such as lead times, minimum order quantities, fixed lot multiples, and supplier item numbers. The table acts as the system of record for supplier assignments used in planning, distinct from purchasing sourcing rules which may be used for execution.

Common Use Cases and Queries

A primary use case is analyzing the supplier base for a critical component ahead of a planning cycle. Planners may query this table to validate sourcing assignments or to troubleshoot planning output. Common reporting needs include listing all approved suppliers for an item or identifying items sourced from a specific supplier site. A typical query pattern joins to item and supplier master tables:

  • Sample Query: To find all supplier assignments for a specific item in a plan:
    SELECT mis.supplier_id, pv.vendor_name, mis.supplier_site_id, pvs.vendor_site_code, msi.segment1 item_code
    FROM mrp_item_suppliers mis,
    po_vendors pv,
    po_vendor_sites_all pvs,
    mtl_system_items_b msi
    WHERE mis.inventory_item_id = :item_id
    AND mis.organization_id = :org_id
    AND mis.compile_designator = :plan_name
    AND mis.supplier_id = pv.vendor_id
    AND mis.supplier_site_id = pvs.vendor_site_id
    AND mis.inventory_item_id = msi.inventory_item_id
    AND mis.organization_id = msi.organization_id;

Related Objects

The MRP_ITEM_SUPPLIERS table maintains integral relationships with several fundamental EBS master tables, as documented by its foreign keys. These relationships ensure referential integrity and enable comprehensive data joins for reporting and processing.

  • MTL_SYSTEM_ITEMS_B: Joined via INVENTORY_ITEM_ID and ORGANIZATION_ID. This links the supplier data to the definitive item master.
  • PO_VENDORS: Joined via SUPPLIER_ID. This provides access to the supplier (vendor) master information.
  • PO_VENDOR_SITES_ALL: Joined via SUPPLIER_SITE_ID. This links to the specific operational site of the supplier.
  • MTL_PARAMETERS: Joined via ORGANIZATION_ID. This validates the organization within inventory master parameters.

These relationships position MRP_ITEM_SUPPLIERS as a central hub connecting planning-specific supplier data with the broader procurement and inventory master data architecture.