Search Results ar_xla_ctlgd_lines_v




Overview
Explore in AI Chat

Overview

AR_XLA_CTLGD_LINES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and is documented in ETRM with the concise description "help reports to read the CCID from XLA." The object name can be decomposed as AR (Receivables), XLA (Subledger Accounting), CTLGD (Customer Transaction Line GL Distribution), and LINES, indicating that the view joins Receivables distribution lines to their corresponding Subledger Accounting accounting entries and distribution links.

The view's primary purpose is to expose the Code Combination ID (CCID) and the associated debits and credits generated by the XLA engine for each Receivables transaction line GL distribution. Because the core distribution table RA_CUST_TRX_LINE_GL_DIST_ALL does not itself carry the final accounted amounts and CCID post-XLA processing, this view bridges that gap by joining to the XLA accounting entries and distribution link tables. It is therefore relied upon by custom reports, reconciliations, and extensions that need to read the accounted (rather than merely entered) amounts and the exact accounting flexfield combination assigned by Subledger Accounting.

Underlying Base Objects

The documented base objects referenced by AR_XLA_CTLGD_LINES_V are:

  • RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — the Receivables customer transaction line GL distribution table, providing distribution identity, GL dates, salesrep, comments, attributes, and set of books.
  • XLA_AE_HEADERS (SYNONYM) — Subledger Accounting event headers.
  • XLA_AE_LINES (SYNONYM) — Subledger Accounting entry lines supplying the accounted and entered debit/credit amounts.
  • XLA_DISTRIBUTION_LINKS (SYNONYM) — the link between the Receivables distribution line and the XLA accounting entry.

The view joins the Receivables distribution (aliased CTLGD) to the XLA accounting entries (aliased AE and LK), keying on the GL_SL_LINK_ID and GL_SL_LINK_TABLE that tie a distribution line to its XLA entry. A DECODE on AE.ACCOUNTING_CLASS_CODE transforms the raw debit and credit columns into a single signed amount, with special handling for RECEIVABLE, FV_REC_DR, and FV_REC_CR accounting classes (factored receivables), and the account class is likewise normalized to 'REC' for those classes.

Key Columns

Important columns exposed by the view include the following:

Common Use Cases and Queries

Typical scenarios include reconciling Receivables distributions to their XLA accounting entries, extracting accounted amounts for a given transaction, resolving the CCID for reporting against GL, and building custom receipt or invoice registers that require Subledger Accounting detail.

Example query retrieving accounted amounts and CCIDs for a transaction:

  • SELECT cust_trx_id, customer_trx_line_id, code_combination_id, concatenated_segments, gl_date, account_class FROM ar_xla_ctlgd_lines_v WHERE customer_trx_id = :p_trx_id ORDER BY cust_trx_line_id;

Example query summarizing accounted activity by account class for a set of books:

  • SELECT account_class, set_of_books_id, SUM(NVL(unrounded_accounted_dr,0)) dr, SUM(NVL(unrounded_accounted_cr,0)) cr FROM ar_xla_ctlgd_lines_v WHERE set_of_books_id = :p_sob GROUP BY account_class, set_of_books_id;

Because the view consolidates the XLA linkage, these queries avoid manually joining RA_CUST_TRX_LINE_GL_DIST_ALL to the XLA tables. Reports should apply appropriate Operating Unit (ORG_ID) and ledger filters, and be aware that accounted amounts only appear once Subledger Accounting has processed the distributions.