Search Results csp_excess_lists_pk

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:

• EXCESS_LINE_ID — the surrogate primary key, enforced by CSP_EXCESS_LISTS_PK and by unique index CSP_EXCESS_LISTS_U1. This is the only documented business-key candidate and is referenced by child tables.
• ORGANIZATION_ID — the inventory organization owning the excess stock; a common filter for reporting and a component of the item/subinventory foreign keys.
• INVENTORY_ITEM_ID — the spare part being flagged as excess, resolving to MTL_SYSTEM_ITEMS_B.
• SUBINVENTORY_CODE — the secondary inventory location holding the excess quantity.
• EXCESS_QUANTITY, RETURNED_QUANTITY, CURRENT_RETURN_QTY — the core quantity measures describing how much material is excess, how much has already been returned, and the quantity currently scheduled for return.
• EXCESS_STATUS, REASON_CODE, CONDITION_CODE — status and classification drivers for the excess disposition workflow.
• REQUISITION_LINE_ID — links the excess line to a sourcing requisition in PO_REQUISITION_HEADERS_ALL.
• RETURN_ORGANIZATION_ID, RETURN_SUBINVENTORY_NAME — the destination organization and subinventory for return transactions.
• Standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• SECURITY_GROUP_ID — multi-org security reference to FND_SECURITY_GROUPS.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF placeholder set for client-specific extensions.

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.