Search Results outstanding_quantity




Overview
Explore in AI Chat

Overview

RCV_DISTRIBUTIONS_PRINT_RMA is an APPS-owned database view in Oracle E-Business Suite, classified under the PO (Purchasing) product family. Its name indicates that it is a reporting and printing construct for Return Merchandise Authorization (RMA) receipt distributions. The view consolidates receiving transaction data for receipts whose receipt source is a customer, effectively the return of goods from a customer back into inventory. It joins receiving, order management, human resources, and warehouse management tables into a single denormalized rowset suitable for printing receiving documents, distribution labels, and return-related reports.

The ETRM metadata describes the object as "Retrofitted," meaning it was carried forward and adapted across EBS releases, and it carries a VALID status in the 12.2.2 reference. Because it presents pre-joined, presentation-ready columns (such as displayed field labels, formatted person and location strings, unit of measure names, and license plate numbers), it is best understood as a presentation view rather than a transactional base object. It is not intended for update; it is consumed by concurrent programs, Oracle Reports layouts, and ad hoc queries that need RMA receipt distribution detail.

Underlying Base Objects

The view is defined over a substantial set of synonyms and supporting views. The core receiving objects are RCV_TRANSACTIONS, RCV_SHIPMENT_LINES, and RCV_SHIPMENT_HEADERS, which supply the transaction, shipment line, and shipment header context respectively. RCV_TRANSACTIONS_INTERFACE is also referenced in the dependency list, reflecting the interface tier used during receipt processing.

Order Management objects supply the return order context: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_TRANSACTION_TYPES_ALL, and OE_TRANSACTION_TYPES_TL. These provide order number, ordered, fulfilled, and cancelled quantities, order category (notably 'RETURN'), and shipping instructions. Human resources and person objects — PER_ALL_PEOPLE_F, HR_LOCATIONS_ALL_TL, and HR_ALL_ORGANIZATION_UNITS_TL — supply deliver-to person names, location codes, and organization names. MTL_UNITS_OF_MEASURE_TL provides the unit of measure description, WMS_LICENSE_PLATE_NUMBERS provides license plate and transfer license plate numbers, and PO_LOOKUP_CODES (a view) resolves the destination type code into a displayed field. FND_GLOBAL is referenced for session context functions such as USERENV('LANG').

Key Columns

Common Use Cases and Queries

The primary use case is printing RMA receipt distributions for customer returns. A typical query retrieves return transaction detail for an organization and date range:

  • SELECT order_number, transaction_id, quantity, transaction_date, unit_of_measure FROM rcv_distributions_print_rma WHERE organization_id = :org_id AND transaction_date BETWEEN :start_date AND :end_date;
  • To surface the outstanding return quantity, reference the computed expression directly, since no OUTSTANDING_QUANTITY column exists: SELECT order_number, NVL(ordered_quantity,0) - NVL(fulfilled_quantity,0) - NVL(cancelled_quantity,0) AS outstanding_quantity FROM oe_order_lines_all;
  • To isolate return-category rows: SELECT * FROM rcv_distributions_print_rma WHERE order_number IN (SELECT order_number FROM oe_order_headers_all WHERE order_category_code = 'RETURN');

Because the view filters on RSH.RECEIPT_SOURCE_CODE IN ('CUSTOMER'), results are restricted to customer returns and exclude supplier receipts. Performance depends on the underlying joins across RCV, OE, and HR tables; queries should filter on ORGANIZATION_ID and TRANSACTION_DATE. The view remains a reliable reporting source in both 12.1.1 and 12.2.2, though the "Retrofitted" designation warrants verification of column availability after any upgrade.