Search Results order_total_numeric




Overview
Explore in AI Chat

Overview

APPS.OE_AS_ORDER_HEADERS_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes a consolidated, denormalized snapshot of sales order header information from the Order Management module. The view is published under the APPS schema and is intended to present order header data alongside its associated descriptive attributes—operating unit, order type, order source, flow status, sales channel, sold-to customer and contact details, and assigned sales representative—in a single flattened result set. Rather than joining the underlying normalized tables at report runtime, consumers can query this view to obtain a business-friendly representation of orders suitable for concurrent programs, custom reports, BI Publisher data templates, and outbound integration extracts.

The view is particularly relevant for users searching on the identifier "sold_arl." That alias refers to the AR_LOOKUPS alias in the view definition, which resolves the contact title (for example, Mr., Ms., Dr.) of the sold-to contact through the lookup type 'CONTACT_TITLE'. The concatenated SOLD_TO_CONTACT column incorporates this value.

Underlying Base Objects

The view is defined over a set of documented base objects that span Order Management, Receivables, and Trading Community Architecture (TCA). The documented referenced objects are:

Outer joins (+) are applied to most reference and customer tables, ensuring that an order header is returned even when source, customer, contact, salesrep, or operating unit data is absent.

Key Columns

Common Use Cases and Queries

The view is typically used to surface order header details with meaningful descriptions for reporting, dashboards, or interface extracts.

  • Listing open orders with customer, contact, and salesrep: SELECT order_number, flow_status, sold_to_contact, account_number, salesrep_name FROM apps.oe_as_order_headers_v WHERE org_id = :p_org_id;
  • Filtering by contact title (the sold_arl attribute): SELECT order_number, sold_to_contact FROM apps.oe_as_order_headers_v WHERE sold_to_contact LIKE '%Mr%';
  • Extracting order totals for reconciliation: SELECT order_number, order_total_numeric FROM apps.oe_as_order_headers_v WHERE flow_status_code = 'BOOKED';
  • Joining to OE_ORDER_LINES_ALL by HEADER_ID for line-level reporting.

Consumers should be aware that ORDER_TOTAL_NUMERIC invokes a PL/SQL package function per row, which can affect performance on large result sets, and that the view joins OE_ORDER_HEADERS_ALL without a status filter, so all orders are returned unless constrained.