Search Results net_unit_price




Overview
Explore in AI Chat

Overview

APPS.AR_CM_NET_REV_DIST_FORM is a reporting view in the Oracle E-Business Suite Receivables (AR) module, present in both 12.1.1 and 12.2.2. It is part of the Credit Memo net revenue distribution reporting layer and exists specifically to shape and aggregate the output of the underlying AR_CM_NET_DISTS_V view for presentation on the Receivables "Credit Memo Net Revenue Distributions" report form. The view consolidates distribution records into a summary grouped by customer transaction line, customer transaction, general ledger date and period set, which makes it suitable for financial reporting, credit and revenue distribution analysis, and reconciliation against the general ledger.

The view is owned by APPLSYS/APPS and is documented in the ETRM 12.2.2 metadata as a VIEW object whose sole referenced base object is AR_CM_NET_DISTS_V. Its principal practical relevance is enabling inquiry into credit memo distributions that reference preceding (previous) transactions, which is why the term "previous_customer_trx_id" is a frequently searched attribute associated with this object.

Underlying Base Objects

According to the documented ETRM metadata, AR_CM_NET_REV_DIST_FORM is defined exclusively over AR_CM_NET_DISTS_V, itself a view. No base tables are listed as direct dependents in the metadata; AR_CM_NET_DISTS_V in turn draws from the Receivables credit memo distribution schema objects. Consequently, the FORM view is a two-tier abstraction: the FM form queries AR_CM_NET_REV_DIST_FORM, which projects and aggregates columns from AR_CM_NET_DISTS_V.

The grouping clause in the inline view text—GROUP BY previous_customer_trx_line_id, trunc(gl_date), previous_customer_trx_id, period_set_name—demonstrates that the aggregation is at the previous transaction line/transaction, GL date and period set level, deliberately dropping individual distribution identifiers so that the form displays net totals per credit memo line.

Key Columns

  • PREVIOUS_CUSTOMER_TRX_LINE_ID — Identifier of the preceding transaction line to which the credit memo distribution relates; used for drill-down and line-level traceability.
  • PREVIOUS_CUSTOMER_TRX_ID — Identifier of the preceding customer transaction (the transaction being credited). Because this is a grouping column, each row represents distributions for one prior transaction and line combination.
  • TRUNC(GL_DATE) — General ledger date truncated to the day, providing the accounting date bucket for aggregation.
  • SUM(AMOUNT) — Total distribution amount for the group.
  • The computed quantity/rate expression — SUM(DECODE(CREDIT_METHOD_FOR_RULES,'UNIT',0,'LIFO',0,AMOUNT)) / DECODE(SUM(DECODE(CREDIT_METHOD_FOR_RULES,'',QUANTITY,0)),0,1,...) — derives a per-unit value, excluding UNIT and LIFO credit methods from the numerator and defaulting the denominator to 1 to prevent division by zero.
  • PERIOD_SET_NAME — The accounting period set associated with the distribution, supporting multi-period-set and calendar-aware reporting.

Common Use Cases and Queries

Typical usage involves querying net revenue distributions for a given prior transaction, by prior transaction line, GL date range and period set. A representative query follows:

SELECT previous_customer_trx_id,
       previous_customer_trx_line_id,
       trunc(gl_date)        gl_date,
       period_set_name,
       SUM(amount)           net_amount
  FROM apps.ar_cm_net_rev_dist_form
 WHERE previous_customer_trx_id = :trx_id
   AND trunc(gl_date) BETWEEN :start_date AND :end_date
 GROUP BY previous_customer_trx_id,
          previous_customer_trx_line_id,
          trunc(gl_date),
          period_set_name;

Other scenarios include reconciliations of credit memo distribution amounts to the GL, revenue allocation reporting under credit methods such as UNIT and LIFO, and integration extracts feeding downstream revenue analysis. The view should be treated as read-only and subject to the standard Receivables security and MO: security profile or org access controls.