Search Results csp_mstrstck_lists_itms




Overview
Explore in AI Chat

Overview

The MTL_PLANNERS 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 maintaining planner codes, which are critical for material planning and inventory management. A planner code is an identifier assigned to a person or role responsible for planning and replenishing items within a specific inventory organization. This table establishes the valid list of planners for each organization, enabling the association of items and planning processes with responsible personnel. Its integrity is fundamental to numerous planning, procurement, and replenishment workflows across the supply chain management suite.

Key Information Stored

The table's structure is defined by a composite primary key consisting of PLANNER_CODE and ORGANIZATION_ID, ensuring uniqueness of a planner within an organizational context. While the provided ETRM metadata does not list all columns, standard implementations of this table typically include fields such as DESCRIPTION for the planner's name, DISABLE_DATE to inactivate a planner, and various WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing. The ORGANIZATION_ID column links the planner definition to a specific operating unit within the MTL_PARAMETERS table, which holds organizational inventory parameters.

Common Use Cases and Queries

The primary use case is to validate and report on planner assignments. A common operational query retrieves all active planners for a given organization to populate list of values (LOVs) in forms. For reporting, a join with MTL_SYSTEM_ITEMS_B lists all items assigned to a specific planner for review. Data integrity checks often involve identifying items with invalid or null planner codes. Sample SQL to find items and their assigned planner is:

  • SELECT msi.segment1 Item, mp.planner_code, mp.description Planner_Name
  • FROM mtl_system_items_b msi, mtl_planners mp
  • WHERE msi.organization_id = mp.organization_id(+)
  • AND msi.planner_code = mp.planner_code(+)
  • AND msi.organization_id = 101;

This table is also central to customizations in modules like Consigned Spare Parts (CSP), as indicated by the foreign key relationships.

Related Objects

Based on the documented foreign key relationships, MTL_PLANNERS is a key reference table for several fundamental and extended objects. The table references MTL_PARAMETERS via ORGANIZATION_ID to validate the inventory organization. Crucially, it is referenced by the following tables, which rely on its planner code definitions:

  • MTL_SYSTEM_ITEMS_B: Links items to their responsible planner via PLANNER_CODE and ORGANIZATION_ID.
  • CSP_MSTRSTCK_LISTS_ITMS: References the planner for master stock list items in the Consigned Spare Parts module.
  • CSP_NOTIFICATIONS: References the planner associated with CSP notifications.
  • CSP_PARTS_LOOPS_B: References the planner for parts loops within CSP.

These relationships underscore the table's role in integrating inventory planning data with advanced functionality in related EBS modules.