Search Results so_lines_view_returns_v




Overview
Explore in AI Chat

Overview

SO_LINES_VIEW_RETURNS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined in the Order Entry (OE) product family. It presents return-related order line information in a single denormalized result set, joining order header, order line, unit of measure, item master, lookup, and receivables transaction data. The view is designed for reporting and integration scenarios that require a consolidated read of returned order lines, including pricing attributes, descriptive flexfield segments, credit-to-invoice references, and return reason codes.

Because the view exposes the full Pricing_Attribute1 through Pricing_Attribute15 set, it is frequently the target of ad hoc queries where users search for a specific pricing attribute, such as pricing_attribute15, to trace how return lines were priced and how those pricing context values map back to a source order. This makes the view especially relevant for pricing audits, return reason analysis, and reconciliation between Order Management and Receivables.

Underlying Base Objects

The documented metadata lists the following referenced base objects which the view is defined over:

The view therefore acts as a curated join point across Order Management, Inventory, and Receivables data rather than a base table in its own right.

Key Columns

  • LINE_ID, HEADER_ID, LINE_NUMBER — order line and header identifiers for joining back to transactional tables.
  • OPEN_QUANTITY — derived as NVL(ORDERED_QUANTITY,0) minus NVL(CANCELLED_QUANTITY,0), representing the net open quantity on the line.
  • SELLING_PRICE, CURRENCY_CODE — pricing and currency context for the returned line.
  • RETURN_REASON — the lookup meaning describing why the line was returned.
  • CREDIT_TO_INVOICE — the receivables transaction number associated with the credit.
  • ITEM / ITEM_DESC — the concatenated item segment and item description.
  • PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTE15 — the complete pricing attribute set, sourced from SO_LINES, with PRICING_CONTEXT supplying the pricing context name. pricing_attribute15 is exposed here directly.
  • ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT — the descriptive flexfield segments and their context.
  • ACCEPTED_QUANTITY — the accepted quantity calculated via OE_QUERY.ACCEPTED_QTY.
  • ORDER_NUMBER, ORDER_TYPE — identifying attributes of the source order.
  • RETURN_REFERENCE_TYPE — indicates the reference source for the return.

Common Use Cases and Queries

Typical usage includes pricing audits, return reason reporting, and integration extracts. A common requirement is locating all return lines tied to a particular pricing attribute value:

  • SELECT order_number, line_number, inventory_item_id, pricing_attribute15, return_reason FROM so_lines_view_returns_v WHERE pricing_attribute15 = 'VALUE';
  • SELECT order_number, SUM(open_quantity) FROM so_lines_view_returns_v GROUP BY order_number;
  • SELECT credit_to_invoice, return_reason, selling_price FROM so_lines_view_returns_v WHERE credit_to_invoice IS NOT NULL;

Because the view performs profile and organization lookups via FND_PROFILE.VALUE('SO_ORGANIZATION_ID'), results can differ by organization context. Restricting queries by ORDER_NUMBER, LINE_ID, or organization-specific filters, and adding redundant indexes where execution plans degrade, is recommended for large-volume reporting.