Search Results gl_sl_link_table




Overview
Explore in AI Chat

Overview

The AR_XLA_ARD_RA_LINES_V view is a Receivables (AR) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to help reports read the Chart of Accounts Code Combination Identifier (CCID) from the Subledger Accounting (XLA) engine for receivable application distribution lines. The view presents a denormalized projection of AR_DISTRIBUTIONS_ALL joined to AR_RECEIVABLE_APPLICATIONS_ALL, exposing the accounting flexfield reference alongside the original transaction and application attributes. It is primarily consumed by standard and custom reports that need to reconcile AR distribution accounting entries with their originating cash receipt applications, particularly where the posting control and application type attributes are required.

The view is marked VALID in the ETRM metadata, and its column list carries a mixture of AR distribution attributes, receivable application attributes, and pass-through placeholders (expressed as NULL or TO_NUMBER(NULL)) that align the projection for report consumption.

Underlying Base Objects

Per the documented view text, AR_XLA_ARD_RA_LINES_V is defined over two base synonyms:

  • AR_DISTRIBUTIONS_ALL (aliased ARD) — supplies the distribution line details, amounts, and code combination reference.
  • AR_RECEIVABLE_APPLICATIONS_ALL (aliased RA) — supplies the application-level attributes such as APPLICATION_TYPE, POSTING_CONTROL_ID, CASH_RECEIPT_ID, and GL_DATE.
  • XLA_DISTRIBUTION_LINKS — documented as a referenced base object in the ETRM metadata, used by the XLA engine to link AR distributions to their subledger accounting entries.

The join logic is expressed as a UNION of two SELECT branches, each driving from AR_DISTRIBUTIONS_ALL and correlating to AR_RECEIVABLE_APPLICATIONS_ALL on ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID where ARD.SOURCE_TABLE = 'RA'. Filter predicates restrict the result set to applications with a POSTING_CONTROL_ID other than -3, a STATUS in the set ('APP','ACC','ACTIVITY','OTHER ACC'), and a NULL EVENT_ID, meaning the view surfaces applications that have not yet been associated with an accounting event.

Key Columns

Common Use Cases and Queries

The view is typically used to build AR-to-GL reconciliation reports and to inspect unreleased application distributions. A representative query filtering on the application type is shown below:

  • Reconciliation reporting — match AR distribution amounts to GL balances by CODE_COMBINATION_ID.
  • Application type analysis — aggregate amounts by APPLICATION_TYPE to summarize how receipts are applied.
  • Unposted application review — the view already excludes POSTING_CONTROL_ID = -3 and applications with a populated EVENT_ID.
SELECT application_type,
       SUM(amount_dr)        AS total_dr,
       SUM(amount_cr)        AS total_cr,
       SUM(acctd_amount_dr)  AS acctd_dr,
       SUM(acctd_amount_cr)  AS acctd_cr
FROM   apps.ar_xla_ard_ra_lines_v
WHERE  org_id = :p_org_id
AND    gl_date BETWEEN :p_start AND :p_end
GROUP  BY application_type;

Queries joining back to AR_DISTRIBUTIONS_ALL on LINE_ID can further enrich the report with posting and description fields not carried in the view.