Results for “orig_ctl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AR_NET_REVENUE_AMOUNT is a reporting view in the Oracle E-Business Suite Receivables (AR) module. Its purpose is to expose, for each originating receivable transaction line, the net and gross revenue amounts after accounting for related lines that carry a reference back to that originating line. In practice the view aggregates revenue figures across a line and any lines linked to it through the PREVIOUS_CUSTOMER_TRX_LINE_ID relationship, which is the mechanism Oracle Receivables uses to associate credit memos, adjustments, and other correcting transactions with the original invoice line.

The view suppresses revenue for transactions that are not yet complete. It incorporates the COMPLETE_FLAG value from RA_CUSTOMER_TRX so that lines belonging to incomplete transactions contribute a zero amount rather than their recorded extended amount. This makes the view suitable for revenue recognition reporting, where only completed (finalized and posted) transactions should be counted. The view is owned by APPS, consistent with Oracle EBS standards for shared reporting objects, and is consumed by reports, custom queries, and integrations that require net-of-adjustment revenue by originating invoice line.

The user search term "orig_ctl" refers to the table alias ORIG_CTL used in the view text, which represents the originating RA_CUSTOMER_TRX_LINES row and serves as the grouping anchor for the aggregation.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is defined over two referenced base objects, both exposed to APPS through synonyms:

• RA_CUSTOMER_TRX_LINES (SYNONYM) — the transaction line table. It appears twice in the view: once as CTL, the line whose amounts are summed, and once as ORIG_CTL, the originating line that defines the grouping key.
• RA_CUSTOMER_TRX (SYNONYM) — the transaction header table, joined to CTL on CUSTOMER_TRX_ID and used to read COMPLETE_FLAG.

The relationships are established through a self-join on RA_CUSTOMER_TRX_LINES. A line is attributed to an originating line when either its CUSTOMER_TRX_LINE_ID equals ORIG_CTL.CUSTOMER_TRX_LINE_ID, or its PREVIOUS_CUSTOMER_TRX_LINE_ID equals ORIG_CTL.CUSTOMER_TRX_LINE_ID (and is not null). The header join then supplies the completion status that gates the amounts.

Key Columns

• CUSTOMER_TRX_LINE_ID — the originating transaction line identifier; the primary grouping column of the view.
• CUSTOMER_TRX_ID — the transaction identifier of the originating line.
• LINE_TYPE — the line type of the originating line (for example LINE, TAX, FREIGHT, or CHARGE).
• NET_AMOUNT — the sum of EXTENDED_AMOUNT across the originating line and its related lines, excluding lines of incomplete transactions (DECODE against COMPLETE_FLAG returns 0 when the flag is 'N').
• GROSS_EXTENDED_AMOUNT — the equivalent sum using GROSS_EXTENDED_AMOUNT instead of EXTENDED_AMOUNT, following the same completion gating.

Common Use Cases and Queries

Typical usage includes revenue reconciliation, credit memo netting analysis, and feeds into general ledger or data warehouse extracts where revenue must be reported net of correcting transactions at the originating line level.

To retrieve net and gross revenue for a specific originating line:

SELECT customer_trx_line_id, customer_trx_id, line_type,
       net_amount, gross_extended_amount
FROM   apps.ar_net_revenue_amount
WHERE  customer_trx_line_id = :line_id;

To list revenue for all lines of a given transaction:

SELECT customer_trx_line_id, line_type, net_amount, gross_extended_amount
FROM   apps.ar_net_revenue_amount
WHERE  customer_trx_id = :trx_id
ORDER  BY customer_trx_line_id;

Because the aggregation already nets adjustments linked through PREVIOUS_CUSTOMER_TRX_LINE_ID and excludes incomplete transactions, consumers should treat NET_AMOUNT and GROSS_EXTENDED_AMOUNT as the authoritative post-adjustment figures for the originating line and avoid further summation that would double-count related lines.