Search Results interfaced_quantity

Overview

The APPS.ICX_SO_RMA_MATL_INT_DETAIL_V view (rendered in ETRM metadata as ICX_SO_RMA_MTL_INT_DETAIL_V) is a reporting and integration object within the Oracle iProcurement (ICX) product family. Its purpose is to consolidate return material authorization (RMA) line information originating from Service Order (SO) processing into a single row per RMA line, enriched with receipt activity captured against the material interface records. The view aggregates received and accepted quantities from RMA receipt transactions and joins them to the corresponding RMA interface line so that downstream consumers—reporting queries, Oracle iProcurement transaction flows, and integration programs—can determine how much of an interfaced return quantity has actually been received or accepted at the warehouse.

The object is formally marked as Obsolete in the ETRM documentation for Oracle EBS 12.1.1 and 12.2.2. This status implies that the view is retained for backward compatibility and metadata completeness but is no longer the recommended access path for new development. Nevertheless, the view text is preserved in the dictionary and can still be queried where legacy customizations or reports reference it.

Underlying Base Objects

The view is defined over three base tables joined in a single SELECT statement. The ETRM metadata records no separately documented referenced base objects, so the source is drawn from the view text itself:

• MTL_SO_RMA_RECEIPTS — aliased MTLSRR, the receipt transaction table holding RECEIVED_QUANTITY, ACCEPTED_QUANTITY, and RECEIPT_DATE.
• MTL_SO_RMA_INTERFACE — aliased MTLSRI, the RMA interface table supplying RMA_LINE_ID, QUANTITY, INVENTORY_ITEM_ID, and COMPONENT_SEQUENCE_ID.
• SO_LINE_DETAILS — aliased LD, the order line detail table providing LINE_ID, COMPONENT_RATIO, and INVENTORY_ITEM_ID.

The join between receipts and the interface is an outer join on RMA_INTERFACE_ID (MTLSRR.RMA_INTERFACE_ID(+) = MTLSRI.RMA_INTERFACE_ID), and the join to SO_LINE_DETAILS is an outer join on INVENTORY_ITEM_ID (LD.INVENTORY_ITEM_ID(+) = MTLSRI.INVENTORY_ITEM_ID). Aggregation is performed with a GROUP BY across RMA_LINE_ID, QUANTITY, INVENTORY_ITEM_ID, COMPONENT_SEQUENCE_ID, LINE_ID, and COMPONENT_RATIO.

Key Columns

• RMA_LINE_ID — identifier of the RMA line; the primary grouping key for the result set.
• RECEIVED_QUANTITY — sum of RECEIVED_QUANTITY from receipts, normalized by dividing by COMPONENT_RATIO to express the quantity in parent-item terms.
• RECEIPT_DATE — the latest receipt date (MAX) observed for the RMA line.
• ACCEPTED_QUANTITY — sum of accepted quantities across receipts for the line.
• INTERFACED_QUANTITY — the QUANTITY carried on MTL_SO_RMA_INTERFACE, representing the anticipated or interfaced return amount for the line. This is the column most relevant to users searching for "interfaced_quantity," as it exposes the interface-side quantity without receipt netting.
• DETAIL_LINE_ID — the SO_LINE_DETAILS.LINE_ID correlated to the RMA line.

Common Use Cases and Queries

Because the view is obsolete, its principal practical role is reconciling interfaced RMA quantities against actual receipts. A typical query compares the interface quantity with the received and accepted aggregates to detect shortfalls:

• Reconciliation reporting: listing RMA lines where INTERFACED_QUANTITY exceeds RECEIVED_QUANTITY or ACCEPTED_QUANTITY to flag unreceived returns.
• Receipt aging: using RECEIPT_DATE to identify lines without recent receipt activity.
• Legacy integration support: driving downstream programs that still reference the view.

Sample query:

• SELECT rma_line_id, interfaced_quantity, received_quantity, accepted_quantity, receipt_date FROM apps.icx_so_rma_mtl_int_detail_v WHERE interfaced_quantity > NVL(received_quantity, 0);

Given the obsolete designation, new development should prefer current RMA and receiving views, but the object remains a valid reference for understanding historical RMA interface-to-receipt logic.