Search Results interfaced_quantity




Overview
Explore in AI Chat

Overview

APPS.ICX_SO_RMA_MTL_INT_V is an Oracle E-Business Suite reporting view that consolidates RMA (Return Material Authorization) material interface activity for a given RMA line. It is defined in the APPS schema and is commonly referenced by the Oracle iStore / Order Management self-service returns flow and related reporting, where users need to reconcile how much of an RMA line has been interfaced into the receiving process versus how much has actually been received and accepted.

The view joins the RMA interface table to the RMA receipts table and aggregates receipt-level quantities up to the RMA line level. This makes it suitable for display in the "Return Items" or RMA status pages, where a line may generate multiple receipt transactions over time. The search term "interfaced_quantity" corresponds directly to one of the view's projected columns, which exposes the quantity originally recorded on the RMA interface record — that is, the amount submitted for receipt processing.

Underlying Base Objects

The view definition references two documented base objects, both exposed as synonyms in APPS:

  • MTL_SO_RMA_INTERFACE (MTLSRI) — the RMA interface staging table that carries header/line information to be processed into receipts. This is the driving table in the join.
  • MTL_SO_RMA_RECEIPTS (MTLSRR) — the receipts detail table recording quantities actually received, accepted, and the receipt dates for each interface record.

The join is an outer join: MTLSRR.RMA_INTERFACE_ID(+) = MTLSRI.RMA_INTERFACE_ID. This ensures that every interface row is retained even when no receipt rows exist yet. In that case the NVL(...,0) wrappers return zero values for received and accepted quantities. The GROUP BY clause aggregates at the level of RMA_LINE_ID, QUANTITY, INVENTORY_ITEM_ID, and COMPONENT_SEQUENCE_ID, so that multiple receipt rows for the same line collapse into a single summarized row.

Key Columns

  • RMA_LINE_ID — the identifier of the RMA line; the primary grouping key and the column typically used to join back to the RMA line tables.
  • INTERFACED_QUANTITY — the quantity from MTLSRI.QUANTITY on the RMA interface record; the amount submitted for receiving. This is the column that matches the "interfaced_quantity" search.
  • RECEIVED_QUANTITY — the sum of NVL(MTLSRR.RECEIVED_QUANTITY,0) across all receipts for the line; the total physically received quantity.
  • ACCEPTED_QUANTITY — the sum of NVL(MTLSRR.ACCEPTED_QUANTITY,0); the portion of the received quantity accepted back into inventory.
  • RECEIPT_DATE — MAX(MTLSRR.RECEIPT_DATE), the most recent receipt date for the line, useful for status and aging reporting.

Because the aggregation groups by INVENTORY_ITEM_ID and COMPONENT_SEQUENCE_ID, the view correctly handles both standard items and component-level (shippable component) lines in an RMA return.

Common Use Cases and Queries

The principal use case is reconciliation reporting: comparing interfaced quantity to received and accepted quantity to identify lines with pending or short receipts. A typical query is:

  • SELECT rma_line_id, interfaced_quantity, received_quantity, accepted_quantity, receipt_date FROM apps.icx_so_rma_mtl_int_v WHERE rma_line_id = :p_rma_line_id;
  • SELECT rma_line_id, interfaced_quantity - received_quantity pending_receipt_qty FROM apps.icx_so_rma_mtl_int_v WHERE interfaced_quantity > received_quantity; — lines awaiting full receipt.
  • SELECT rma_line_id, received_quantity - accepted_quantity rejected_qty FROM apps.icx_so_rma_mtl_int_v WHERE received_quantity > accepted_quantity; — lines with rejected or non-conforming returns.

This view is read-only and should be treated as a reporting convenience layer rather than as a base for DML. Queries against it execute as the invoking user and are subject to APPS synonym and privilege grants, so EBS responsibility permissions on the underlying RMA tables apply.