Search Results gross_extended_amount




Overview
Explore in AI Chat

Overview

AR_NET_REVENUE_AMOUNT is a VALID Oracle E-Business Suite view owned by the APPS schema within the Oracle Receivables (AR) product. Its documented purpose is to determine the uncredited amount on a transaction line. In practice it returns the net and gross extended amounts attributable to an original transaction line, excluding amounts already credited through a complete credit transaction. This makes the view a reporting and integration building block used to derive the true revenue retained on a line after subsequent adjustments, rather than the raw stored amount on the line record itself.

Because the object is a view and not a table, it stores no data. Each query executes the underlying join and aggregation against the base transaction tables at runtime. When users search for the column GROSS_EXTENDED_AMOUNT, this view is the relevant object: it exposes that column as an aggregated value reflecting the original line's gross amount, with credit lines contributing conditionally based on the complete flag of the related transaction.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed as synonyms in the APPS schema: RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES. RA_CUSTOMER_TRX holds the transaction header, including the COMPLETE_FLAG that governs whether a transaction contributes to the amounts. RA_CUSTOMER_TRX_LINES holds the line-level amounts, including EXTENDED_AMOUNT and GROSS_EXTENDED_AMOUNT.

The view text self-joins RA_CUSTOMER_TRX_LINES, aliased as CTL and ORIG_CTL. ORIG_CTL supplies the original line identity in the SELECT list and GROUP BY, while CTL supplies the amount rows. The join condition matches a line either to itself (CTL.CUSTOMER_TRX_LINE_ID = ORIG_CTL.CUSTOMER_TRX_LINE_ID) or, where PREVIOUS_CUSTOMER_TRX_LINE_ID is not null, as a credit child of the original line. CTL.CUSTOMER_TRX_ID is joined to RA_CUSTOMER_TRX, so the COMPLETE_FLAG of the credit transaction controls whether its amounts are counted.

Key Columns

  • CUSTOMER_TRX_LINE_ID — the original line identifier, taken from ORIG_CTL.CUSTOMER_TRX_LINE_ID.
  • CUSTOMER_TRX_ID — the transaction identifier of the original line.
  • NET_AMOUNT — the summed EXTENDED_AMOUNT, decoded to zero when COMPLETE_FLAG is 'N'.
  • LINE_TYPE — the line type of the original line, carried into the GROUP BY.
  • GROSS_EXTENDED_AMOUNT — the summed GROSS_EXTENDED_AMOUNT, likewise zeroed when the related transaction is not complete.

The DECODE on COMPLETE_FLAG is central: incomplete transactions contribute zero, so the aggregate reflects only completed revenue activity.

Common Use Cases and Queries

Typical scenarios include reporting net revenue per original line when credit memos reduce previously billed amounts, reconciling gross extended amounts against credits, and feeding downstream revenue or integration extracts. The view is read-only and suitable for SELECT operations.

Sample query to return gross and net amounts for a transaction's lines:

  • SELECT customer_trx_line_id, customer_trx_id, line_type, net_amount, gross_extended_amount FROM apps.ar_net_revenue_amount WHERE customer_trx_id = :p_trx_id;
  • SELECT line_type, SUM(gross_extended_amount) gross, SUM(net_amount) net FROM apps.ar_net_revenue_amount GROUP BY line_type;

Because the view performs an aggregation and self-join, queries benefit from predicates on CUSTOMER_TRX_ID or CUSTOMER_TRX_LINE_ID to limit the driving set.