Search Results reference_header_id

Overview

SO_LINES_RMA_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered under the Order Entry (OE) product family. The view presents a denormalized, query-friendly projection of return merchandise authorization (RMA) order lines, combining line-level attributes from the sales order line tables with descriptive and derived data sourced from inventory items, price lists, receivables, and a set of OE_QUERY package functions. Its status is VALID in both 12.1.1 and 12.2.2 reference environments.

Because it joins base order-entry entities and applies business logic at the database layer, the view is commonly used for RMA reporting, returns analysis, reconciliation of received and accepted quantities, and integration extracts where a single row per return line is required. It is not a transactional base table; consumers should treat it as read-only.

Underlying Base Objects

The view is defined over the following documented objects:

• AR_LOOKUPS (VIEW), SO_LOOKUPS (SYNONYM) — lookup meaning resolution, e.g., line type codes.
• MTL_SYSTEM_ITEMS_VL (VIEW), MTL_PARAMETERS (SYNONYM) — item description, BOM item type, and warehouse/organization attributes.
• RA_CUSTOMER_TRX (SYNONYM), RA_CUSTOMER_TRX_LINES (SYNONYM) — credit memo and invoice reference data for returns tied to billing.
• AR_VAT_TAX (SYNONYM) — tax exemption and VAT-related values.
• SO_HEADERS (VIEW), SO_LINES (VIEW) — the primary header and line sources supplying identifiers, quantities, pricing, and status flags.
• SO_PRICE_LISTS (SYNONYM) — price list rounding factors.
• QP_PRICE_LIST_PVT (PACKAGE) — pricing list access.
• OE_QUERY (PACKAGE) — supplies derived quantities and dates via stored functions such as RECEIVED_QTY, ACCEPTED_QTY, RECEIVED_DATE, ACCEPTED_DATE, GET_PRICE_ADJ_TOTAL, and GET_TAX_EXEMPT_FLAG.
• FND_GLOBAL, FND_PROFILE (PACKAGES) — session and profile context.

The view text confirms that many calculated values are fetched through OE_QUERY function calls rather than direct column references from the underlying tables.

Key Columns

Prominent columns exposed by the view include:

• LINE_ID, HEADER_ID, PARENT_LINE_ID, LINK_TO_LINE_ID — line and header identifiers, including hierarchical relationships.
• LINE_NUMBER — the line sequence; users searching for "reference_line_number" typically correlate this to the RMA line reference or a linked original order line.
• LINE_TYPE_CODE, ITEM_TYPE_CODE, ITEM_TYPE — lookup classifications for line and item behavior.
• INVENTORY_ITEM_ID, ITEM_DESCRIPTION, BOM_ITEM_TYPE — item identity and description.
• ORDERED_QUANTITY, CANCELLED_QUANTITY, SHIPPED_QUANTITY, INVOICED_QUANTITY — transactional quantities.
• RECEIVED_QUANTITY, ACCEPTED_QUANTITY, ACTUAL_RECEIPT_DATE, ACTUAL_ACCEPTED_DATE — derived via OE_QUERY functions.
• LIST_PRICE, SELLING_PRICE, LIST_PERCENT, SELLING_PERCENT, PRICE_ADJUSTMENTS_TOTAL — pricing data.
• WAREHOUSE_ID, WAREHOUSE_CODE — return destination organization.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_FLAG_DISPLAY — conditional tax flags derived from credit, return reference, and open-flag logic.

Common Use Cases and Queries

Typical scenarios include returns reconciliation, tracking quantity received versus accepted against an RMA, and reporting against the original referenced order line.

• Retrieve RMA line details for a specific header.
• Report received/accepted quantities and actual dates per line.
• Correlate return lines using line number or link-to-line identifiers for reference tracking.

Sample SQL:

SELECT header_id, line_id, line_number, inventory_item_id, item_description, ordered_quantity, received_quantity, accepted_quantity, actual_receipt_date, actual_accepted_date, warehouse_code FROM apps.so_lines_rma_v WHERE header_id = :p_header_id ORDER BY line_number;

To locate lines by reference or linked line, filter on line_number or link_to_line_id. Because several columns are resolved through OE_QUERY functions, performance can be affected when large result sets are scanned without restrictive predicates.