Search Results quantity_credited

Overview

RA_CUST_TRX_LINE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is catalogued under the GMF – Process Manufacturing Financials product family and is described as a "Customer transaction line view." The view consolidates line-level detail from completed Receivables transactions into a single, denormalised projection that joins the transaction header, transaction type, line, accounting distribution, and unit-of-measure data.

Its practical purpose is to expose a reporting-ready slice of the RA_CUSTOMER_TRX_LINES_ALL table, filtered to lines that are tied to inventory items and whose parent transaction is complete, together with a resolved unit of measure and revenue (receivable) accounting date. Because it spans Receivables and inventory dimensions, it is commonly consumed by GMF reporting, custom concurrent programs, and downstream integrations that must reconcile invoiced and credited quantities against inventory items without querying the individual base tables. Users searching for "quantity_credited" arrive at this view because QUANTITY_CREDITED is one of its exposed columns.

Underlying Base Objects

The documented view text and ETRM metadata identify the following referenced base objects, accessed through APPS synonyms:

• RA_CUSTOMER_TRX_LINES_ALL (alias RCTL) — the driving line table; supplies quantity, inventory item, UOM code, line type, and descriptive flexfield attributes.
• RA_CUSTOMER_TRX_ALL (alias RCT) — the transaction header; supplies TRX_NUMBER, TRX_DATE, COMPLETE_FLAG, and the header customer_trx_id.
• RA_CUST_TRX_TYPES_ALL (alias RCTT) — the transaction type; supplies the transaction class rendered as INVOICE_TYPE.
• RA_CUST_TRX_LINE_GL_DIST_ALL (alias GD) — the line accounting distributions, restricted to ACCOUNT_CLASS = 'REC' and LATEST_REC_FLAG = 'Y', supplying the GL date.
• MTL_UNITS_OF_MEASURE (alias MUOM) and SY_UOMS_MST (alias SUOM) — unit-of-measure master tables joined to derive the reported UNIT_OF_MEASURE.
• MTL_SYSTEM_ITEMS (alias MSI) — used in a scalar subquery to resolve the item's primary UOM when the line UOM code is null.

The joins enforce that only lines with LINE_TYPE = 'LINE' and a non-null INVENTORY_ITEM_ID are returned, and that the parent transaction is complete (COMPLETE_FLAG = 'Y'). Multi-organisation safety is handled by correlating the transaction type to a single CUST_TRX_TYPE_ID/ORG_ID combination via a ROWNUM-limited subquery.

Key Columns

• CUSTOMER_TRX_ID — identifier of the parent transaction header; the join key back to RA_CUSTOMER_TRX_ALL.
• TRX_NUMBER — the user-visible transaction number (invoice or credit memo).
• TRX_DATE — the receivable GL date where available (NVL of GL_DATE and RCT.TRX_DATE), used for period and ageing analysis.
• INVOICE_TYPE — the transaction type class derived from RA_CUST_TRX_TYPES_ALL.TYPE.
• UNIT_OF_MEASURE — the line UOM code, falling back to the item primary UOM.
• QUANTITY_CREDITED — the credited quantity on the line; central to credit memo and return analyses.
• QUANTITY_INVOICED — the invoiced quantity on the line; paired with QUANTITY_CREDITED for net quantity reporting.
• INVENTORY_ITEM_ID — the inventory item associated with the line; the key used for item-level and GMF reporting.
• ATTRIBUTE1, ATTRIBUTE5, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE15 — descriptive flexfield attribute columns carried from the line for contextual reporting.

Common Use Cases and Queries

The view is typically used to report invoiced versus credited quantities by item, to analyse credit memo activity, and to feed GMF or inventory reconciliation extracts. A representative query for credited quantity by item is:

SELECT inventory_item_id, unit_of_measure, SUM(quantity_credited) credited_qty, SUM(quantity_invoiced) invoiced_qty FROM ra_cust_trx_line_v WHERE trx_date BETWEEN :start_date AND :end_date GROUP BY inventory_item_id, unit_of_measure;

A transaction-level extract returning descriptive flexfield context is:

SELECT trx_number, trx_date, invoice_type, inventory_item_id, quantity_invoiced, quantity_credited FROM ra_cust_trx_line_v WHERE inventory_item_id = :item_id;

Because the view already restricts to complete transactions with inventory items and current REC distributions, consumers avoid re-implementing these filters. Note that no ROWNUM limiting is applied to the main result set, so a transaction with multiple line rows is fully expanded. As with all APPS reporting views, queries should be executed against the APPS schema or a synonym with appropriate Receivables and inventory read privileges.