Search Results csp_sec_inventories

Overview

The CSP_SEC_INVENTORIES table is a core data object within the Oracle E-Business Suite (EBS) Spares Management (CSP) module. It functions as an extension table to the standard inventory structures, specifically designed to hold supplementary information related to subinventories. Its primary role is to enable advanced spares management functionality by linking subinventory definitions to specific parts loops and organizational hierarchies, which are critical concepts for managing spare parts provisioning, replenishment, and allocation in maintenance and service operations. This table bridges standard Inventory data with the specialized processes of the CSP module.

Key Information Stored

The table's structure centers on linking a subinventory to other CSP entities. The documented foreign key relationships indicate its key columns include SECONDARY_INVENTORY_ID (the primary key), SECONDARY_INVENTORY_NAME, and ORGANIZATION_ID, which together uniquely identify a subinventory from the standard MTL_SECONDARY_INVENTORIES table. Crucially, it stores the PARTS_LOOP_ID, associating the subinventory with a specific parts replenishment loop, and the HIERARCHY_NODE_ID, linking it to a node within a customizable organizational reporting or planning hierarchy defined in CSP_REP_HIERARCHIES. This allows spares inventory to be managed and reported within a structured operational context.

Common Use Cases and Queries

A primary use case is generating reports that analyze spare parts inventory levels within the context of their assigned replenishment loops and organizational hierarchy. For instance, identifying all subinventories assigned to a specific parts loop for cycle counting or performance review. A common query pattern involves joining CSP_SEC_INVENTORIES to both standard Inventory tables and CSP configuration tables.

• Sample Query: To list subinventories with their associated parts loop and hierarchy node:
  SELECT csi.secondary_inventory_name,
      csi.organization_id,
      cpl.loop_name,
      crh.node_name
FROM csp_sec_inventories csi,
     csp_parts_loops_b cpl,
     csp_rep_hierarchies crh
WHERE csi.parts_loop_id = cpl.parts_loop_id(+)
AND csi.hierarchy_node_id = crh.hierarchy_node_id(+);
• Another critical use is data validation, ensuring that subinventories used in CSP setups are correctly defined in the base Inventory module.

Related Objects

The table is centrally connected to several key objects via documented foreign keys, forming the backbone of spares inventory configuration.

• MTL_SECONDARY_INVENTORIES: The foundational Inventory table. CSP_SEC_INVENTORIES references it via the composite key (SECONDARY_INVENTORY_NAME, ORGANIZATION_ID) to establish the base subinventory record.
• CSP_PARTS_LOOPS_B: Links a subinventory to a specific parts replenishment loop via the PARTS_LOOP_ID column, defining its replenishment policy context.
• CSP_REP_HIERARCHIES: Associates a subinventory with a node in a reporting hierarchy via the HIERARCHY_NODE_ID column, enabling structured organizational reporting for spares.