Results for “customer_po”
50+ results
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.
-
Holds extra information for moveorder lines
-
Holds extra information for moveorder lines
-
View: CSP_MO_LINES_V 12.2.2
Move order lines including extra information of Spares Management
APPS.CSP_MO_LINES_V·↳ CSP_MOVEORDER_LINES·↳ CS_INCIDENTS_ALL·↳ JTF_TASKS_B·Explore CSP module →
-
this view picks up all the valid exception details
APPS.MSC_EXCEPTION_DETAILS_V·↳ MSC_DEMANDS·↳ MSC_EXCEPTION_DETAILS·↳ MSC_FULL_PEGGING·Explore MSC module →
-
this view picks up all the valid exception details
APPS.MSC_EXCEPTION_DETAILS_V·↳ MSC_DEMANDS·↳ MSC_EXCEPTION_DETAILS·↳ MSC_FULL_PEGGING·Explore MSC module →
-
View: CSP_MOVEORDER_LINES_V 12.2.2
Mover order lines including extra information for Spares Management
APPS.CSP_MOVEORDER_LINES_V·↳ CSP_MOVEORDER_LINES·Explore CSP module →
-
View: CSP_MOVEORDER_LINES_V 12.1.1
Mover order lines including extra information for Spares Management
APPS.CSP_MOVEORDER_LINES_V·↳ CSP_MOVEORDER_LINES·Explore CSP module →
-
View: CSP_MO_LINES_V 12.1.1
Move order lines including extra information of Spares Management
APPS.CSP_MO_LINES_V·↳ CSP_MOVEORDER_LINES·↳ CS_INCIDENTS_ALL·↳ JTF_TASKS_B·Explore CSP module →
-
To decide whether the cascading feature for a attribute is turned on or not
-
To decide whether the cascading feature for a attribute is turned on or not
-
Lookup Type: MSC_PQ_CP_EXCP 12.1.1
Field Prompts used for Personal Queries
-
Lookup Type: MSC_PQ_CP_EXCP 12.2.2
Field Prompts used for Personal Queries
-
VIEW: APPS.CSP_MO_LINES_V 12.1.1
-
VIEW: APPS.CSP_MO_LINES_V 12.2.2
-
View: OEFV_DISCOUNT_LINES 12.2.2
- Retrofitted
Not implemented in this database·Explore OE module →
-
View: OEFV_DISCOUNT_LINES 12.1.1
- Retrofitted
Not implemented in this database·Explore OE module →