Search Results csp_moveorder_headers_v




Overview
Explore in AI Chat

Overview

The CSP_MOVEORDER_HEADERS_V view is a reporting and integration object within the Oracle E-Business Suite Spares Management (CSP) module. It presents move order header information together with supplementary attributes required by the Spares Management business flow. Move orders are internal inventory transactions used to move material between subinventories, organizations, or locations, and the header record defines the controlling attributes for each move order. This view exposes those header-level attributes — including the SHIPMENT_METHOD and CARRIER columns that govern how the resulting shipment is dispatched — in a form suitable for inquiry, reporting, and downstream integration.

The object is owned by the APPS schema and is reported as VALID in both Oracle EBS 12.1.1 and 12.2.2. As a view, it holds no data of its own; it simply projects columns from the underlying move order header table. This design allows Oracle to insulate dependent code from changes to the base table while still delivering the Spares Management-specific field set.

Underlying Base Objects

The view is defined over a single base object: CSP_MOVEORDER_HEADERS, referenced in the view text through the alias CMH. In the documented metadata, CSP_MOVEORDER_HEADERS is listed as a SYNONYM resolving to the underlying APPS table. Because the definition is a simple projection with no joins, the view is a straight pass-through of the header columns with no transformation logic, filters, or aggregation. Each row in the view corresponds one-to-one with a row in CSP_MOVEORDER_HEADERS, keyed by HEADER_ID. This direct relationship means query performance and row counts track the base table, and indexing on HEADER_ID controls access efficiency.

Key Columns

  • HEADER_ID — Primary identifier for the move order header; the join key to move order lines and distributions.
  • CARRIER — The carrier responsible for transporting the shipped material.
  • SHIPMENT_METHOD — The shipment method associated with the move order, relevant to the user's search term; identifies how goods are to be shipped.
  • AUTORECEIPT_FLAG — Indicates whether receipt at the destination is handled automatically.
  • PARTY_SITE_ID — The party site associated with the move order destination or trading partner.
  • LOCATION_ID — The location identifier tied to the move order header.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle descriptive flexfield columns, providing extensible, customer-defined attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical uses include reporting on move orders by shipment method or carrier, and joining header information to line-level detail for full shipment visibility. A representative query retrieving headers by shipment method is:

SELECT h.header_id, h.carrier, h.shipment_method, h.autoreceipt_flag
FROM   apps.csp_moveorder_headers_v h
WHERE  h.shipment_method = :p_shipment_method;

Integration scenarios frequently extract the descriptive flexfield values alongside the shipment attributes, selecting ATTRIBUTE_CATEGORY and the relevant ATTRIBUTEn columns. Because the view is a projection of CSP_MOVEORDER_HEADERS, any query can also be issued directly against the base table when full column access is required. The view remains the recommended access path where Spares Management expects the documented column set.