Search Results csp_moveorder_lines




Overview
Explore in AI Chat

Overview

The CSP_MOVEORDER_LINES table is a core data object within the Oracle E-Business Suite (EBS) Spares Management (CSP) module, specifically in versions 12.1.1 and 12.2.2. It functions as an extension table designed to hold supplementary information for individual lines of a move order. A move order, represented by MTL_TXN_REQUEST_HEADERS, is a transaction request to move material within an organization. While the standard Inventory tables manage the primary transaction data, CSP_MOVEORDER_LINES provides the additional attributes and context required for complex spares management processes, such as service part fulfillment, kit assembly, or field service logistics. Its role is to bridge standard Inventory functionality with the specialized requirements of managing spare parts, ensuring detailed line-level tracking beyond core inventory transactions.

Key Information Stored

The table's primary key is the LINE_ID column, which directly corresponds to the LINE_ID in the standard MTL_TXN_REQUEST_LINES table. This one-to-one relationship is the fundamental link between the spares-specific data and the base inventory transaction line. The HEADER_ID column stores the identifier for the move order header, linking the line to both the CSP-specific header (CSP_MOVEORDER_HEADERS) and the standard inventory header (MTL_TXN_REQUEST_HEADERS). While the exact supplemental columns are not detailed in the provided metadata, based on its description and role, this table typically stores data pertinent to service part fulfillment, such as reference to a service request, a specific asset, a customer, shipping priorities, or custom attributes needed for downstream spares-specific processes like pick confirmation, pack verification, and shipment staging.

Common Use Cases and Queries

This table is central to reporting and process flows within Spares Management. A common use case is generating detailed pick lists or pack lists for service part orders, where the extra information in CSP_MOVEORDER_LINES provides necessary context for warehouse personnel. Another scenario involves tracing the fulfillment status of a specific spare part line item from the initial move order request through to packing. A typical query would join this table to standard Inventory and Spares Management headers to create a comprehensive line-level report.

Sample SQL Pattern:
SELECT cml.line_id,
mtrl.line_number,
mtrl.inventory_item_id,
mtrl.quantity,
cmh.order_number,
cml.* -- Select specific extended columns as needed
FROM csp_moveorder_lines cml,
mtl_txn_request_lines mtrl,
csp_moveorder_headers cmh
WHERE cml.line_id = mtrl.line_id
AND cml.header_id = cmh.header_id
AND cmh.order_number = '<ORDER_NUMBER>';

Related Objects

The CSP_MOVEORDER_LINES table is a nexus within the Spares Management schema, maintaining critical foreign key relationships with both standard and CSP-specific tables.

  • References To (Child Table): CSP_MOVEORDER_LINES references the following parent tables.
    • CSP_MOVEORDER_HEADERS via CSP_MOVEORDER_LINES.HEADER_ID
    • MTL_TXN_REQUEST_HEADERS via CSP_MOVEORDER_LINES.HEADER_ID
    • MTL_TXN_REQUEST_LINES via CSP_MOVEORDER_LINES.LINE_ID (Primary Key link)
  • Referenced By (Parent Table): The following child tables reference CSP_MOVEORDER_LINES.

These relationships illustrate the table's position in the process flow: it inherits core transaction data from Inventory tables, enriches it for spares, and is subsequently used to generate detailed pick and pack lists for fulfillment execution.