Search Results gain_loss_amt




Overview
Explore in AI Chat

Overview

APPS.AR_CM_LINES_BASE_V is a Receivables (AR) reporting and integration view that exposes credit memo (CM) line-level accounting and currency conversion details sourced from the Subledger Accounting (SLA/XLA) extraction tables. It is one of the standard AR views used by Oracle's E-Business Tax and Subledger Accounting infrastructure to communicate transactional line data to downstream accounting engines. The view presents a line-oriented projection of credit memo distributions, pairing customer transaction line GL distribution rows with the corresponding XLA extract rows so that accounting amounts, currency conversion attributes, and event identifiers are available in a single consumable structure.

The view is central to the AR credit memo accounting flow. Its rows carry the event identifiers used by SLA to build journal entries, together with the accounted amounts and exchange-rate details required for multi-currency processing. The presence of the columns gain_loss_amt, gain_loss_sign, and gain_loss_ref reflects its intended role in exposing realized and unrealized foreign-exchange gain or loss information for credit memo activity, even though in this view those columns are populated as NULL placeholders within the UNION branches.

Underlying Base Objects

The view is defined as a UNION of two query branches and references four documented base objects, all exposed to APPS through synonyms:

  • AR_XLA_LINES_EXTRACT — The SLA line-level extract table that supplies event identifiers, base currency codes, exchange-rate metadata, accounted amounts, ledger and language information, and line numbers. It is the primary driver of both query branches.
  • RA_CUST_TRX_LINE_GL_DIST_ALL — Holds the credit memo line GL distributions. It is joined to the extract on CUST_TRX_LINE_GL_DIST_ID in the first branch.
  • RA_CUSTOMER_TRX_ALL — The customer transaction header table, joined on CUSTOMER_TRX_ID to obtain the invoice currency code used in the GAIN_LOSS_REF derivation.
  • AR_DISTRIBUTIONS_ALL — Referenced as the distribution source identified by the cm_dist_type literal and the posting_entity = 'APP' predicate in the second branch.

The first branch filters level_flag = 'L', posting_entity = 'CTLGD', and event types CM_CREATE and CM_UPDATE. The second branch filters posting_entity = 'APP', level_flag = 'L', and from_to_flag = 'F'. A leading hint (INDEX(HE AR_XLA_LINES_EXTRACT_N1)) directs the optimizer toward the extract index.

Key Columns

  • EVENT_ID — SLA subledger event identifier, the anchor for journal-line creation.
  • LINE_ID — Line identifier, mapped from the GL distribution or the extract line.
  • CM_LINE_CUR_CODE — Base currency code for the credit memo line.
  • CM_LINE_CUR_CONVERSION_TYPE / _DATE / _RATE — Exchange-rate type, conversion date, and rate applied to the line.
  • CM_LINE_ACCTD_AMT — Accounted amount for the distribution line.
  • LINE_NUMBER, LANGUAGE, LEDGER_ID — Sequencing, language, and ledger context.
  • CM_DIST_TYPE — Literal indicating the distribution source (RA_CUST_TRX_LINE_GL_DIST_ALL or AR_DISTRIBUTIONS_ALL).
  • CM_DIST_IDENTIFER — Identifier of the distribution row.
  • GAIN_LOSS_AMT, GAIN_LOSS_SIGN — Gain/loss amount and sign placeholders; returned as NULL in this view.
  • GAIN_LOSS_REF — Derived reference that returns the event ID when the invoice currency equals the base currency, otherwise NULL.

Common Use Cases and Queries

This view is typically queried during credit memo accounting analysis, currency conversion validation, and reconciliation between AR distributions and SLA extract rows.

  • Retrieving credited amounts by ledger and event:
SELECT event_id, line_id, cm_line_acctd_amt, cm_line_cur_code
FROM   apps.ar_cm_lines_base_v
WHERE  ledger_id = :ledger_id;
  • Inspecting gain/loss placeholders — note both return NULL in this view:
SELECT event_id, gain_loss_amt, gain_loss_sign, gain_loss_ref
FROM   apps.ar_cm_lines_base_v
WHERE  gain_loss_ref IS NOT NULL;
  • Auditing exchange-rate attributes applied to credit memo lines:
SELECT event_id, cm_line_cur_conversion_type,
       cm_line_cur_conversion_date, cm_line_cur_conversion_rate
FROM   apps.ar_cm_lines_base_v;

For actual gain/loss amounts, users should generally reference the corresponding AR gain/loss views or the underlying SLA tables rather than this view, since the gain/loss columns here are NULL placeholders retained for structural consistency with sibling AR CM views.