Search Results msl_id

Overview

The table CSP_MSTRSTCK_LISTS_ITMS is a core transactional entity within the Oracle E-Business Suite (EBS) Spares Management (CSP) module. It serves as the master repository for stocklist items, which are critical for managing spare parts inventory. The table's primary function is to define and maintain the catalog of parts that are planned, forecasted, and replenished across the supply chain. Its existence is central to the module's ability to ensure optimal stock levels for service and maintenance operations, directly supporting key business processes like parts planning, forecasting, and procurement.

Key Information Stored

The table stores the master definition for each stocklist item. While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal its critical data attributes. The primary key column, MSL_ID, uniquely identifies each stocklist item record. The table links to several foundational EBS entities, indicating it stores the foreign key references: the specific inventory item (INVENTORY_ITEM_ID) within an organization (ORGANIZATION_ID), the assigned planner (PLANNER_CODE), the associated parts loop for planning logic (PARTS_LOOPS_ID), and the forecasting rule (FORECAST_RULE_ID) to be applied. This structure positions the table as a nexus connecting master item data, planning parameters, and organizational structure.

Common Use Cases and Queries

This table is integral to operational and analytical processes within Spares Management. Common use cases include generating the master stocklist report for planners, serving as the source data for forecasting engine runs, and providing the item master for replenishment recommendation programs. A typical query might join this table to inventory and planner master tables to analyze planner assignments or to validate forecast rule setup. For instance, a report to list all active stocklist items with their planner and forecast rule would utilize a SQL pattern similar to:

• SELECT msl.MSL_ID, msi.SEGMENT1 ITEM, mp.PLANNER_CODE, cfr.RULE_NAME
• FROM CSP_MSTRSTCK_LISTS_ITMS msl,
• MTL_SYSTEM_ITEMS_B msi,
• MTL_PLANNERS mp,
• CSP_FORECAST_RULES_B cfr
• WHERE msl.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID
• AND msl.ORGANIZATION_ID = msi.ORGANIZATION_ID
• AND msl.PLANNER_CODE = mp.PLANNER_CODE
• AND msl.ORGANIZATION_ID = mp.ORGANIZATION_ID
• AND msl.FORECAST_RULE_ID = cfr.FORECAST_RULE_ID;

Related Objects

The table CSP_MSTRSTCK_LISTS_ITMS maintains defined referential integrity with several key EBS tables, as documented in its foreign key constraints. These relationships are fundamental to its data integrity and functional role:

• CSP_PARTS_LOOPS_B: Linked via PARTS_LOOPS_ID. This defines the planning and sourcing loop for the stocklist item.
• MTL_PLANNERS: Linked via PLANNER_CODE and ORGANIZATION_ID. This identifies the material planner responsible for the item.
• MTL_SYSTEM_ITEMS_B: Linked via INVENTORY_ITEM_ID and ORGANIZATION_ID. This is the core link to the Inventory item master, providing item details.
• CSP_FORECAST_RULES_B: Linked via FORECAST_RULE_ID. This specifies the forecasting methodology applied to the item for demand planning.

The primary key constraint CSP_MSTRSTCK_LISTS_ITMS_PK on MSL_ID ensures each record is unique and is likely referenced by other transactional tables within the CSP module, such as demand history or plan output tables.