Search Results cancel_meaning

Overview

APPS.SO_ORDER_CANCELLATIONS_V is a reporting and integration view that exposes order-line cancellation activity recorded in Oracle Order Management. It joins the base cancellation table SO_ORDER_CANCELLATIONS to order headers, order types, order lines, item master descriptions, and the SO_LOOKUPS lookup set, producing a denormalized, human-readable result set suitable for concurrent programs, BI Publisher reports, OBIEE extracts, and interface staging tables. The view returns the full complement of Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), concurrent-program context columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID), descriptive flexfield columns (CONTEXT and ATTRIBUTE1 through ATTRIBUTE15), and derived numbering attributes produced by the OEXVWCAN package.

The view is defined as a UNION ALL of at least two branches. Each branch re-derives the same column list from the same physical tables, which means callers must anticipate potential duplicate logical rows and should apply DISTINCT or aggregation where a single row per cancellation is required. The user search term "cancel_meaning" maps directly to the derived column CANCEL_MEANING, which is populated from SO_LOOKUPS.MEANING and is the most frequently consumed column in cancellation reporting.

Underlying Base Objects

The view is defined over the following documented base objects:

• SO_ORDER_CANCELLATIONS (synonym) — the primary transactional source, supplying CANCEL_CODE, CANCELLED_BY, CANCEL_DATE, CANCELLED_QUANTITY, CANCEL_COMMENT, STATUS, PROCESSED_FLAG, and the DFF attributes.
• SO_HEADERS (view) — supplies ORDER_NUMBER and links the cancellation to its order via HEADER_ID.
• SO_LINES (view) — supplies LINE_ID linkage, ITEM_TYPE_CODE, COMPONENT_SORT_CODE, PARENT_LINE_ID, SERVICE_PARENT_LINE_ID, SHIPMENT_SCHEDULE_LINE_ID, and LINE_NUMBER.
• SO_ORDER_TYPES (synonym) — supplies ORDER_TYPE_NAME through ORDER_TYPE_ID.
• SO_LOOKUPS (synonym) — restricted to LOOKUP_TYPE = 'CANCEL_CODE'; supplies MEANING as CANCEL_MEANING and drives the CANCEL_CODE join.
• MTL_SYSTEM_ITEMS_KFV (synonym) — supplies CONCATENATED_SEGMENTS as ITEM, filtered by FND_PROFILE.VALUE('SO_ORGANIZATION_ID') to restrict items to the current operating unit's master organization.
• FND_PROFILE (package) — resolves the SO_ORGANIZATION_ID profile option value at query time.
• FND_GLOBAL (package) — supports session context and Who column behavior.
• OEXVWCAN (package) — provides the BASE_LINE_NUMBER, SHIPMENT_SCHEDULE_NUMBER, and OPTION_LINE_NUMBER functions that reconstruct hierarchical line numbering for model, option, and service lines.

Key Columns

• CANCEL_MEANING — the lookup MEANING for the cancellation reason code; the descriptive counterpart of CANCEL_CODE. This is the column most often searched for as "cancel_meaning".
• CANCEL_CODE — the lookup code from FND_LOOKUPS/SO_LOOKUPS identifying the reason for cancellation.
• HEADER_ID, LINE_ID, ORDER_NUMBER, ORDER_TYPE_NAME — the order context identifying where the cancellation occurred.
• CANCELLED_BY, CANCEL_DATE, CANCELLED_QUANTITY, CANCEL_COMMENT — who cancelled, when, how much, and any free-text explanation.
• STATUS, PROCESSED_FLAG — indicate the processing state of the cancellation record.
• ITEM — the concatenated item flexfield value, indented for model/option hierarchy via LPAD and COMPONENT_SORT_CODE logic.
• BASE_LINE_NUMBER, SHIPMENT_SCHEDULE_NUMBER, OPTION_LINE_NUMBER — derived line identifiers produced by OEXVWCAN functions.
• ITEM_TYPE_CODE — distinguishes standard, model, option class, and service items.
• ATTRIBUTE1–ATTRIBUTE15, CONTEXT — descriptive flexfield storage carried from the base table.

Common Use Cases and Queries

Typical use cases include cancellation reason analysis, cancellation trend reporting by order type and item, and data extraction into a data warehouse. Because the view is a UNION ALL, always verify cardinality before aggregating.

• Cancellation reasons by period: SELECT cancel_meaning, COUNT(*) FROM apps.so_order_cancellations_v WHERE cancel_date BETWEEN :from_date AND :to_date GROUP BY cancel_meaning;
• Cancellation detail for one order: SELECT order_number, order_type_name, item, cancel_meaning, cancelled_quantity, cancel_comment FROM apps.so_order_cancellations_v WHERE order_number = :order_number;
• Unprocessed cancellations for an interface: SELECT header_id, line_id, cancel_code, cancelled_quantity FROM apps.so_order_cancellations_v WHERE processed_flag = 'N';
• Top cancelled items: SELECT item, SUM(cancelled_quantity) FROM apps.so_order_cancellations_v GROUP BY item ORDER BY 2 DESC;