Search Results csp_requirement_lines

Overview

The CSP_REQUIREMENT_LINES table is a core data object within the Oracle E-Business Suite (EBS) Spares Management (CSP) module. It functions as the detailed transactional repository for individual parts requirements generated from service requests, work orders, or other demand sources. While the parent table, CSP_REQUIREMENT_HEADERS, stores the overall requirement document, this table holds the specific line-level details for each part or item needed, including quantities, sourcing information, and fulfillment status. Its role is central to the spares planning and fulfillment process, tracking the lifecycle of each part requirement from creation through to reservation, sourcing, and shipment.

Key Information Stored

The table's primary key is the REQUIREMENT_LINE_ID, which uniquely identifies each requirement line. A critical foreign key, REQUIREMENT_HEADER_ID, links each line to its parent document in CSP_REQUIREMENT_HEADERS. Key transactional columns include ORDER_LINE_ID, which links the requirement to a sales order line in OE_ORDER_LINES_ALL when fulfillment is processed through Order Management. For inventory sourcing, the SOURCE_ORGANIZATION_ID and SOURCE_SUBINVENTORY columns define the inventory location from which the part is to be supplied. The table also manages inventory reservations via the RESERVATION_ID and LOCAL_RESERVATION_ID columns, which reference the MTL_RESERVATIONS table to track committed inventory for the requirement.

Common Use Cases and Queries

A primary use case is generating reports on open spares requirements to drive procurement or transfer activities. Analysts often query this table to understand demand patterns and fulfillment bottlenecks. A common SQL pattern involves joining to the headers and inventory tables to list all pending requirements:

• SELECT csh.requirement_number, csl.inventory_item_id, csl.required_quantity, msi.segment1 item_code FROM csp_requirement_lines csl JOIN csp_requirement_headers csh ON csl.requirement_header_id = csh.requirement_header_id JOIN mtl_system_items_b msi ON csl.inventory_item_id = msi.inventory_item_id AND csl.organization_id = msi.organization_id WHERE csh.status = 'OPEN';

Another critical operational use case is tracing the fulfillment path for a specific requirement, which involves querying the links to OE_ORDER_LINES_ALL for shipped lines and MTL_RESERVATIONS for reserved inventory.

Related Objects

CSP_REQUIREMENT_LINES has integral relationships with several key EBS tables. Its primary relationship is with CSP_REQUIREMENT_HEADERS, the parent document table. For order fulfillment, it references OE_ORDER_LINES_ALL. For inventory management, it links to MTL_RESERVATIONS for reservations, MTL_PARAMETERS for organization definitions, and MTL_SECONDARY_INVENTORIES for subinventory details. These relationships position the table at the intersection of Spares Management, Order Management, and Inventory modules, making it essential for cross-modular processes and data integrity.