Search Results csp_picklist_lines




Overview
Explore in AI Chat

Overview

The CSP_PICKLIST_LINES table is a core data object within the Oracle E-Business Suite Spares Management (CSP) module. It serves as the transactional repository for individual line items on a picklist, which is a document used to fulfill material requests for service parts. Each record in this table represents a specific part or item that needs to be picked from inventory, linking the high-level picklist header to the underlying material transaction request or move order. Its primary role is to manage and track the detailed fulfillment process for service parts, ensuring accurate picking, packing, and shipping operations.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the structure and foreign key relationships define the critical data points stored. The primary key, PICKLIST_LINE_ID, uniquely identifies each picklist line item. The PICKLIST_HEADER_ID column links the line to its parent document in the CSP_PICKLIST_HEADERS table. The LINE_ID column is a crucial foreign key that connects the picklist line to its source demand, which can originate from either a generic Inventory material request (MTL_TXN_REQUEST_LINES) or a Spares Management-specific move order (CSP_MOVEORDER_LINES). Additional columns typically track the requested and picked quantities, item identifiers, and status of the picking operation for each line.

Common Use Cases and Queries

This table is central to operational reporting and process tracking within Spares Management. Common use cases include generating real-time pick slips, calculating picking performance metrics, and reconciling picklist details with subsequent packing and shipping documents. A typical query would join this table to its header and source demand lines to analyze fulfillment status.

  • Sample Query (Open Picklist Lines): SELECT pll.picklist_line_id, plh.picklist_number, pll.line_id, pll.requested_quantity FROM csp_picklist_lines pll, csp_picklist_headers plh WHERE pll.picklist_header_id = plh.picklist_header_id AND plh.status = 'OPEN';
  • Integration Point: The table acts as a bridge between demand sources (move orders/material requests) and downstream shipping processes (packlists), making it vital for tracing the complete order-to-ship lifecycle of a service part.

Related Objects

The CSP_PICKLIST_LINES table is a central node in the Spares Management data model, with well-defined relationships documented in the ETRM.

  • Parent/Dependent Tables (Foreign Keys Referenced):
    • CSP_PICKLIST_HEADERS: Joined via CSP_PICKLIST_LINES.PICKLIST_HEADER_ID.
    • MTL_TXN_REQUEST_LINES: Joined via CSP_PICKLIST_LINES.LINE_ID.
    • CSP_MOVEORDER_LINES: Joined via CSP_PICKLIST_LINES.LINE_ID.
  • Child/Dependent Tables (Foreign Keys Referencing):
    • CSP_PACKLIST_LINES: References CSP_PICKLIST_LINES.PICKLIST_LINE_ID to associate picked items with packing lines.
    • CSP_PICKLIST_SERIAL_LOTS: References CSP_PICKLIST_LINES.PICKLIST_LINE_ID to track specific serial or lot numbers assigned during picking.