Results for “ar_cust_trx_lines_l_v”

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

Overview

AR_CUST_TRX_LINES_L_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite Receivables (AR). It is documented in ETRM as a "transaction line extract" view, meaning it is designed to expose customer transaction line data — including descriptive, attribute, and accounting-rule information — in the flattened, denormalized form required by external extraction processes and downstream reporting. Because the view is defined over AutoInvoice and Subledger Accounting (SLA) extraction tables, it is used primarily in the context of data warehousing, GL reconciliation, and interface extraction rather than in the Receivables transactional forms themselves.

The view is valid in both 12.1.1 and 12.2.2. Its naming convention ("_L_V") signals a view that also surfaces descriptive ("L" for line-level) information, consistent with Receivables' pattern of shipping language or line-detail views for external consumption.

Underlying Base Objects

The ETRM 12.2.2 metadata lists the following referenced base objects, all accessed through APPS synonyms:

• AR_ADJUSTMENTS_ALL
• AR_DISTRIBUTIONS_ALL
• AR_MEMO_LINES_ALL_B
• AR_XLA_LINES_EXTRACT
• RA_CUSTOMER_TRX_LINES_ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL
• RA_RULES

The view text shows a driving query over AR_XLA_LINES_EXTRACT (aliased CTLAF), with a hint forcing index AR_XLA_LINES_EXTRACT_N1. AR_XLA_LINES_EXTRACT is the SLA extraction table that stores subledger accounting line data for Receivables transactions before transfer to GL. RA_CUSTOMER_TRX_LINES_ALL supplies the base transaction line attributes; AR_ADJUSTMENTS_ALL and AR_MEMO_LINES_ALL_B supply adjustment and memo-line context; RA_CUST_TRX_LINE_GL_DIST_ALL and AR_DISTRIBUTIONS_ALL supply distribution/accounting information; and RA_RULES supplies accounting-rule definitions such as ACCOUNTING_RULE_DURATION.

Key Columns

Columns exposed by the view are prefixed TRX_LINE_ to distinguish them from header-level data. Notable columns include:

• TRX_LINE_CUSTOMER_TRX_LINE_ID — the primary key of the customer transaction line, joining back to RA_CUSTOMER_TRX_LINES_ALL.
• TRX_LINE_DESCRIPTION — the free-text line description.
• TRX_LINE_ACCT_RULE_DURATION — duration of the accounting rule associated with the line, sourced from RA_RULES.
• TRX_LINE_AMT_INCLUDES_TAX_FLAG — indicates whether the line amount includes tax.
• TRX_LINE_ATTR_CAT and TRX_LINE_ATTR1–15 — the descriptive flexfield context and attribute values from the line.
• TRX_LINE_GLOBAL_ATTR1–20 — the global descriptive flexfield segments.

The user search term "trx_line_dist_id" corresponds to the distribution identifier associated with the transaction line. In the underlying stack, this is the link between the line distribution rows (RA_CUST_TRX_LINE_GL_DIST_ALL/AR_DISTRIBUTIONS_ALL) and the SLA extract rows (AR_XLA_LINES_EXTRACT), and it is the key by which accounting entries are tied back to specific lines.

Common Use Cases and Queries

Typical uses include extracting customer transaction line detail for a data warehouse, reconciling Receivables subledger lines to GL, and validating line-level attributes and accounting rules for AutoInvoice troubleshooting.

SELECT trx_line_customer_trx_line_id,
       trx_line_description,
       trx_line_acct_rule_duration,
       trx_line_amt_includes_tax_flag,
       trx_line_attr_cat
FROM   apps.ar_cust_trx_lines_l_v
WHERE  trx_line_customer_trx_line_id = :line_id;

To trace distribution and accounting context for a line, join the view to AR_XLA_LINES_EXTRACT and RA_CUST_TRX_LINE_GL_DIST_ALL on the customer transaction line identifier. Because the view is a read-only extract, it should never be updated directly; all maintenance is performed on the underlying base tables.