Search Results csp_excess_lists




Overview
Explore in AI Chat

Overview

The CSP_EXCESS_LISTS table is a transactional data object within the Oracle E-Business Suite Spares Management module (product code CSP). Its documented description identifies it as the storage location for Excess Spare Parts — that is, inventory items held in a subinventory that are surplus to requirement and available for redeployment, return, or requisition-based demand matching. Each row represents one excess line, keyed by the surrogate primary key EXCESS_LINE_ID, and enriched with attribute flexfield columns for customer-specific extensions.

Under a heuristic Data Vault classification mined from the foreign-key structure, CSP_EXCESS_LISTS is satellite-leaning. It carries descriptive, mutable measures (excess quantity, condition code, status) attached to a small set of stable business keys — the inventory item, the organization, and the subinventory — rather than acting as a hub or as a pure link between two hubs. This suggests that in a Data Vault or dimensional re-modeling exercise, the table is best treated as a satellite surrounding an inventory-item/organization hub, with the requisition reference layered on as an optional link.

Key Information Stored

The table is documented with 35 physical columns. The most significant of these are:

Common Use Cases and Queries

Typical reporting scenarios include identifying all excess lines awaiting disposition in a given organization, reconciling excess quantities against returns already executed, and tracing an excess line to the requisition that will consume it. A simple operational query:

  • SELECT el.excess_line_id, el.organization_id, el.inventory_item_id, el.subinventory_code, el.excess_quantity, el.excess_status FROM csp_excess_lists el WHERE el.organization_id = :org_id AND el.excess_status = :status;

To enrich with item description and unit of measure, join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID. To expose serial or lot detail held against an excess line, join CSP_EXCESS_LIST_SERIAL_LOTS on EXCESS_LINE_ID. Return-progress reporting compares EXCESS_QUANTITY against RETURNED_QUANTITY and CURRENT_RETURN_QTY grouped by organization and subinventory.

Related Objects

  • CSP_EXCESS_LIST_SERIAL_LOTS — child table; joins on EXCESS_LINE_ID to hold serial and lot detail for each excess line.
  • MTL_SYSTEM_ITEMS_B — master item definition, joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • MTL_SECONDARY_INVENTORIES — subinventory master, joined on SUBINVENTORY_CODE and ORGANIZATION_ID.
  • PO_REQUISITION_HEADERS_ALL — sourcing requisition reference, joined through REQUISITION_LINE_ID.
  • FND_SECURITY_GROUPS — multi-org security group reference via SECURITY_GROUP_ID.
  • Spares Management UI and concurrent programs that populate and consume excess lines during returns, replenishment, and sourcing flows.