Search Results csp_moveorder_headers




Overview
Explore in AI Chat

Overview

The CSP_MOVEORDER_HEADERS table is a core data object within the Oracle E-Business Suite (EBS) Spares Management (CSP) module. It functions as an extension table to the standard Inventory transaction request (move order) structure. Its primary role is to store supplementary, module-specific information for move order headers that is not captured in the base inventory tables. This table is integral to managing the movement of spare parts, enabling the Spares Management module to maintain its proprietary workflow and business logic while leveraging the foundational inventory transaction engine of Oracle EBS.

Key Information Stored

The table's structure is anchored by its primary key, HEADER_ID, which serves as a foreign key to the standard inventory table MTL_TXN_REQUEST_HEADERS. This one-to-one relationship ensures each extended header record corresponds to exactly one standard move order header. While the specific descriptive columns are not detailed in the provided metadata, tables of this nature typically store attributes such as spares-specific order references, project or asset associations unique to maintenance operations, approval status flags for spares workflows, or custom dates and identifiers that drive the Spares Management business processes. The data in this table enriches the standard move order with context critical for spare parts logistics and fulfillment.

Common Use Cases and Queries

This table is central to reporting and process flows within Spares Management. Common use cases include generating detailed reports on all spare parts move orders, integrating spares fulfillment data with external maintenance management systems, and auditing the spares requisition lifecycle. A fundamental query involves joining this table to the standard move order header to retrieve a consolidated view. For example:

  • To list all spares move orders with their extended data: SELECT mtrh.*, cmoh.* FROM mtl_txn_request_headers mtrh, csp_moveorder_headers cmoh WHERE mtrh.header_id = cmoh.header_id;
  • To investigate the lines for a specific spares move order: SELECT * FROM csp_moveorder_lines WHERE header_id = <header_id>;

Data in this table is primarily created, updated, and accessed through the CSP module's application forms and underlying PL/SQL APIs, rather than via direct SQL manipulation.

Related Objects

The CSP_MOVEORDER_HEADERS table sits at the center of a key relationship hierarchy within the Spares Management schema, as documented in the ETRM metadata.

  • References (Parent Table): The table has a mandatory foreign key relationship to the core Inventory table MTL_TXN_REQUEST_HEADERS on the column HEADER_ID. This links every spares-specific header to its foundational transaction request.
  • Referenced By (Child Table): The table is referenced by CSP_MOVEORDER_LINES via its HEADER_ID column. This establishes a one-to-many relationship where a single extended header record can have multiple associated spares move order lines, which themselves likely extend the standard MTL_TXN_REQUEST_LINES.

This structure creates a clear chain: MTL_TXN_REQUEST_HEADERS -> CSP_MOVEORDER_HEADERS -> CSP_MOVEORDER_LINES, allowing spares-specific data to propagate from the header down to the individual line items.