Results for “aso_returns_v”

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

Overview

ASO_RETURNS_V is a database view owned by the APPS schema in Oracle E-Business Suite, defined within the ASO (Order Capture) product family. Its documented purpose is to list all return orders present in Order Management. Because return orders represent a distinct transactional category in the order lifecycle—used for RMAs, credit processing, and reverse logistics—a dedicated view that isolates them from the broader population of sales orders simplifies reporting, reconciliation, and downstream integration.

The view presents a denormalized projection that joins order header and order line information, filtered so that only lines whose category code equals 'RETURN' are exposed. Each row therefore represents a single return order line paired with its parent order header attributes. In EBS 12.1.1 and 12.2.2 the object is reported as VALID and is documented in the E-Business Suite Technical Reference Manuals (ETRM) under the ASO module.

Its principal role is as a reporting and integration surface. Rather than requiring report authors or interface developers to navigate the substantial structure of the Order Management tables directly, ASO_RETURNS_V provides a curated column set covering order identification, item identification, and customer/party identification.

Underlying Base Objects

The documented view text selects from two Order Capture views, joined on HEADER_ID:

• ASO_I_ORDER_HEADERS_V — supplies order header attributes such as ORDER_NUMBER.
• ASO_I_ORDER_LINES_V — supplies line-level attributes including LINE_ID, LINE_NUMBER, INVENTORY_ITEM_ID, and the LINE_CATEGORY_CODE used in the filter.

The view text applies the predicate LINE.LINE_CATEGORY_CODE = 'RETURN' against the line source, which is the mechanism by which the view restricts its output to return orders only. The ETRM 12.2.2 metadata additionally records referencing packages: OE_PROFILE, QP_PRICE_LIST_PVT, and the two ASO views above. These packages are associated with profile option resolution and pricing list logic that underpin the ASO order capture views rather than the ASO_RETURNS_V select itself.

Key Columns

The documented column list maps as follows:

• ORDER_NUMBER — the user-visible order number from the header, used to identify the return order.
• RETURN_LINE_ID — the unique identifier of the return order line; documented as LINE_ID in the view text.
• RETURN_LINE_NUMBER — the displayed line number on the order; documented as LINE_NUMBER.
• INVENTORY_ITEM_ID — the inventory item being returned.
• PARTY_ID — the party identifier; sourced from HEAD.CUST_ACCT_ID in the view text.
• CUST_ACCOUNT_ID — the customer account identifier; sourced from HEAD.INVOICE_TO_ORG_ID in the view text.

Common Use Cases and Queries

Typical uses include return-order dashboards, credit and RMA analysis, and extract feeds to data warehouses. A basic query retrieving return lines for a given order or item is shown below.

• List all return lines: SELECT order_number, return_line_id, return_line_number, inventory_item_id FROM aso_returns_v;
• Filter by item: SELECT order_number, return_line_number FROM aso_returns_v WHERE inventory_item_id = :p_item_id;
• Filter by customer: SELECT order_number, return_line_id FROM aso_returns_v WHERE cust_account_id = :p_cust_account_id;

Return line identifiers retrieved here can be passed to standard Order Management return APIs for further processing.