Results for “csp_moveorder_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSP_MOVEORDER_LINES is a table within the CSP (Spares Management) product schema of Oracle E-Business Suite, documented as valid in releases 12.1.1 and 12.2.2. Its stated purpose is to hold extra information for move order lines. In practice, the table functions as a CSP-specific extension or satellite of the standard Oracle Inventory move order line record maintained in MTL_TXN_REQUEST_LINES, allowing the Spares Management module to attach supplementary attributes—such as incident references, task associations, and descriptive flexfield data—without altering the base Inventory table structure.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This suggests the table may be modeled as a satellite attached to a core move order line hub or link, carrying descriptive and contextual attributes rather than defining new business entities. This classification is a modeling suggestion derived from the FK topology, not a statement of physical design intent by Oracle.

Key Information Stored

The table is owned by the CSP schema and contains 29 documented columns. The surrogate primary key is LINE_ID, which is also the single documented unique index (CSP_MOVEORDER_LINES_U1), making it both the physical row identifier and the business-key candidate in the documented metadata. LINE_ID is a foreign key to MTL_TXN_REQUEST_LINES, confirming that each CSP row extends exactly one Inventory move order line.

• LINE_ID — Primary key and unique index column; also a foreign key to MTL_TXN_REQUEST_LINES, anchoring the extension record to the base Inventory line.
• HEADER_ID — Foreign key to both CSP_MOVEORDER_HEADERS and MTL_TXN_REQUEST_HEADERS, linking the line to its CSP-level header as well as the standard move order header.
• INCIDENT_ID — Reference to a service incident, tying the move order line to the field service context that generated it.
• TASK_ID — Identifier of the service task associated with the moved material.
• TASK_ASSIGNMENT_ID — Identifier of the specific task assignment, supporting resource-level traceability.
• CUSTOMER_PO — Customer purchase order reference captured on the line for reconciliation and billing.
• COMMENTS — Free-form text notes recorded against the move order line.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns providing extensible, unplanned capture of additional line attributes.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or organization-level data segregation.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_LOGIN) — Standard EBS who-columns recording row creation and maintenance history.

Common Use Cases and Queries

The principal use case is joining the CSP extension data back to the base Inventory move order line to produce operational or analytical reports enriched with service context. A typical query pattern joins on LINE_ID:

• Service-aware move order reporting: joining CSP_MOVEORDER_LINES to MTL_TXN_REQUEST_LINES to display moved items alongside INCIDENT_ID, TASK_ID, and CUSTOMER_PO for field service reconciliation.
• Pack and pick list assembly: CSP_PACKLIST_LINES and CSP_PICKLIST_LINES both reference CSP_MOVEORDER_LINES.LINE_ID, so packing and picking documents can be traced back to their originating move order line and its incident context.
• Flexfield-based reporting: querying ATTRIBUTE_CATEGORY with ATTRIBUTE1–ATTRIBUTE15 where organizations have configured descriptive flexfields to capture site-specific line details.
• Audit and change tracking: filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify recently modified move order line extensions.

A representative pattern is: select CSP_MOVEORDER_LINES.LINE_ID, CSP_MOVEORDER_LINES.INCIDENT_ID, CSP_MOVEORDER_LINES.TASK_ID, and CSP_MOVEORDER_LINES.CUSTOMER_PO, joined to MTL_TXN_REQUEST_LINES on LINE_ID, restricted by HEADER_ID for a given move order.

Related Objects

• MTL_TXN_REQUEST_LINES — Base Inventory move order line; CSP_MOVEORDER_LINES.LINE_ID references it.
• MTL_TXN_REQUEST_HEADERS — Standard move order header; referenced via HEADER_ID.
• CSP_MOVEORDER_HEADERS — CSP-level move order header; referenced via HEADER_ID.
• CSP_PACKLIST_LINES — References CSP_MOVEORDER_LINES.LINE_ID, extending the line into packing documentation.
• CSP_PICKLIST_LINES — References CSP_MOVEORDER_LINES.LINE_ID, extending the line into picking documentation.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for data segregation.