Search Results csp_supply_chain




Overview
Explore in AI Chat

Overview

CSP_SUPPLY_CHAIN is a transactional configuration table in the CSP (Spares Management) product schema of Oracle E-Business Suite, holding supply chain definition details used by the Spares Management module. The table defines how a specific inventory item, within a given organization and secondary inventory location, participates in a supply chain structure — encoding the source, lead time, and supply level attributes that drive spare parts replenishment and sourcing decisions. It is owned by the CSP schema and is documented as valid across EBS 12.1.1 and 12.2.2.

Based on the foreign key structure, the object exhibits a satellite-leaning Data Vault classification (heuristic). This suggests a modeling approach in which CSP_SUPPLY_CHAIN is treated as a satellite attached to a hub or link that represents the core inventory item, organization, and secondary inventory combination. The self-referencing PARENT_SUPPLY_CHAIN_ID column gives the table a hierarchical, recursive character, so it may also be treated as a recursive link when modeling the parent-child supply chain relationships.

Key Information Stored

The documented physical schema contains 16 columns. The primary key CSP_SUPPLY_CHAIN_PK is defined on the composite business key of ORGANIZATION_ID, SECONDARY_INVENTORY, and INVENTORY_ITEM_ID. This composite uniquely identifies a supply chain entry for an item at a secondary inventory location within an inventory organization. A separate surrogate SUPPLY_CHAIN_ID column also exists and is referenced by the self-referencing foreign key, indicating it functions as the internal hierarchical link identifier.

  • SUPPLY_CHAIN_ID — Surrogate identifier for the supply chain row; used as the target of the PARENT_SUPPLY_CHAIN_ID self-reference.
  • ORGANIZATION_ID — Inventory organization owning the supply chain definition; part of the primary key and FK to MTL_SYSTEM_ITEMS_B and MTL_SECONDARY_INVENTORIES.
  • INVENTORY_ITEM_ID — The item being sourced; part of the primary key and FK to MTL_SYSTEM_ITEMS_B.
  • SECONDARY_INVENTORY — The secondary inventory location within the organization; part of the primary key and FK to MTL_SECONDARY_INVENTORIES.
  • PARENT_SUPPLY_CHAIN_ID — Self-referencing parent link that builds the supply chain hierarchy.
  • SOURCE_TYPE — Classifies the supply source (for example, internal or external).
  • SOURCE_ORGANIZATION_ID / SOURCE_SUBINVENTORY — Identify the originating organization and subinventory supplying the item.
  • LEAD_TIME — Replenishment lead time applied to the supply chain entry.
  • SUPPLY_LEVEL — Ordering level associated with the supply chain definition.
  • SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS; enforces multi-org security and data access partitioning.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN record standard EBS row-level audit lineage.

Common Use Cases and Queries

CSP_SUPPLY_CHAIN is primarily consumed to determine how spare parts are sourced and replenished across inventory organizations. Typical reporting scenarios include identifying lead times per item/organization, tracing the parent-child supply hierarchy, and resolving source organization and subinventory for replenishment planning. A basic join to the item master retrieves descriptive item context:

  • Item supply detail: SELECT c.INVENTORY_ITEM_ID, c.ORGANIZATION_ID, c.SECONDARY_INVENTORY, c.LEAD_TIME, c.SUPPLY_LEVEL FROM CSP_SUPPLY_CHAIN c WHERE c.ORGANIZATION_ID = :org_id;
  • Hierarchy traversal: Join CSP_SUPPLY_CHAIN to itself on PARENT_SUPPLY_CHAIN_ID to walk the recursive parent chain of supply definitions.
  • Source resolution: Select SOURCE_TYPE, SOURCE_ORGANIZATION_ID, and SOURCE_SUBINVENTORY to determine where replenishment originates.
  • Item master enrichment: Join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID to report concatenated item descriptions alongside lead times.
  • Security-filtered extracts: Filter on SECURITY_GROUP_ID when generating multi-org reports to respect security group partitioning.

Related Objects

The following objects are the most significant relationships documented for CSP_SUPPLY_CHAIN:

  • MTL_SYSTEM_ITEMS_B — Joined on INVENTORY_ITEM_ID and ORGANIZATION_ID; provides item master attributes.
  • MTL_SECONDARY_INVENTORIES — Joined on SECONDARY_INVENTORY and ORGANIZATION_ID; validates the secondary inventory location.
  • CSP_SUPPLY_CHAIN (self) — Joined on PARENT_SUPPLY_CHAIN_ID to SUPPLY_CHAIN_ID for hierarchical traversal.
  • FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID for security group resolution and access control.

Because the table is specific to the CSP Spares Management module, downstream dependency is concentrated in CSP replenishment, sourcing, and supply planning logic rather than broad shared inventory tables.