Results for “line_cancelled”

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

Overview

SO_LINES_CANCEL_V is a seeded Oracle E-Business Suite view owned by the APPS schema and assigned a VALID status in both release 12.1.1 and 12.2.2. It belongs to the Order Entry (OE) product family and exists to expose sales order line details in the specific context of order line cancellation, particularly the handling of cancelled quantities. Its naming convention and reference to the OEXVWCAN package indicate that it is intended for use by the order cancellation workflow and by reporting or integration logic that needs to identify and quantify partially or fully cancelled order lines. Because it is a view rather than a table, it presents no persisted data of its own; consumers query it to obtain a consistent, product-supported projection of the underlying order line information.

Underlying Base Objects

The view is documented in ETRM 12.2.2 as being defined over FND_GLOBAL (package), FND_PROFILE (package), MTL_SYSTEM_ITEMS_KFV (synonym), MTL_SYSTEM_ITEMS_VL (view), OEXVWCAN (package), SO_LINES (view), and SO_LOOKUPS (synonym). The principal data source is SO_LINES, the primary order line view in the Order Management schema. The view text selects from this source using the alias SOL, carrying forward the full column set of the order line. Supporting objects provide enrichment: MTL_SYSTEM_ITEMS_VL supplies item-level attributes, FND_GLOBAL and FND_PROFILE resolve session context and profile option values, SO_LOOKUPS supports code-to-meaning translation for lookup columns, and OEXVWCAN encapsulates the cancellation-specific business logic. The inclusion of OEXVWCAN is the defining characteristic that distinguishes this view from the broader SO_LINES view.

Key Columns

The view projects the complete column list of the order line, including the following columns of particular relevance to cancellation processing:

• CANCELLED_QUANTITY — the quantity cancelled against the line, the central measure for cancellation reporting.
• ORDERED_QUANTITY — the original ordered quantity, against which cancelled, shipped and invoiced quantities are compared.
• SHIPPED_QUANTITY and INVOICED_QUANTITY — used to determine the proportion of the line still eligible for cancellation.
• LINE_ID, HEADER_ID, LINE_NUMBER — primary identification of the line and its parent order.
• OPEN_FLAG and LINE_TYPE_CODE — status and classification of the line, useful when filtering cancellable lines.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — audit columns identifying the concurrent program that last modified the row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• Pricing, shipping and scheduling columns such as LIST_PRICE, SELLING_PRICE, WAREHOUSE_ID, SCHEDULE_DATE and SHIP_SET_NUMBER, retained for reporting completeness.

Common Use Cases and Queries

The view is typically used to report cancellation activity, to reconcile cancelled quantities against ordered quantities, and to feed downstream integration or reconciliation processes. A representative query identifies lines with cancellations in a given period:

• SELECT line_id, header_id, line_number, ordered_quantity, cancelled_quantity, last_update_date FROM so_lines_cancel_v WHERE cancelled_quantity > 0 AND last_update_date >= :p_from_date;
• SELECT header_id, SUM(ordered_quantity) ordered_qty, SUM(cancelled_quantity) cancelled_qty FROM so_lines_cancel_v GROUP BY header_id;
• SELECT l.line_id, l.ordered_quantity, l.shipped_quantity, l.cancelled_quantity FROM so_lines_cancel_v l WHERE l.open_flag = 'Y' AND l.cancelled_quantity < l.ordered_quantity;

Because the view joins to MTL_SYSTEM_ITEMS_VL and SO_LOOKUPS, queries may also project item description and lookup meanings without additional joins. Filtering on OPEN_FLAG, LINE_TYPE_CODE and the audit columns is recommended to limit result sets and avoid performance degradation on large order volumes.