Results for “ar_tax_lines_v”

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

Overview

AR_TAX_LINES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Receivables. It exposes tax line information associated with customer transaction lines, joining tax detail records to the underlying transaction line so that tax amounts, rates, and tax codes can be reported alongside the invoice or credit memo lines they relate to. The view presents tax precedence, extended tax amounts, and the "amount includes tax" indicator, together with the tax code and tax identifier resolved from the Receivables tax setup.

According to the ETRM metadata, the object is documented as a Release 10SC view, which indicates it originated in an early Receivables release and has been retained in the APPS schema for backward compatibility. In 12.1.1 and 12.2.2 environments it remains a VALID view. Its principal role is as a read-only reporting and integration surface: it allows reports, queries, and downstream interfaces to retrieve tax line detail without navigating the normalization of the underlying tax tables directly. Because the view exposes a ROWID from the tax detail table, it also supports identification of individual tax rows for reconciliation purposes.

Underlying Base Objects

The documented view metadata lists the referenced base objects as AR_VAT_TAX (a synonym) and RA_CUSTOMER_TRX_LINES (a synonym), both resolved to APPS-owned objects at runtime. RA_CUSTOMER_TRX_LINES is the core Receivables transaction line table and supplies line-level context such as the transaction line number and the transaction and line identifiers. AR_VAT_TAX holds the tax code and tax identifier definitions used to describe the tax applied to the line, including the tax code, VAT tax identifier, and validation flag.

The view text additionally references tax detail tables aliased as CTL_TAX and CTL_INV_TAX, along with paired line tables CTL_LINE and CTL_INV_LINE. The CTL_TAX and CTL_LINE aliases represent the tax and line records of the primary transaction, while CTL_INV_TAX and CTL_INV_LINE represent corresponding records from a related credit transaction. This paired structure allows the view to return both the original and the reversing or credit-side tax line information, which is typical of Receivables credit memo and adjustment processing. The join is driven by CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID, with LINK_TO_CUST_TRX_LINE_ID and the PREVIOUS_* columns capturing lineage between a line and the line it references.

Key Columns

• CUSTOMER_TRX_ID / CUSTOMER_TRX_LINE_ID — Identify the Receivables transaction and transaction line to which the tax line belongs; these are the primary join keys to transaction tables.
• LINK_TO_CUST_TRX_LINE_ID — Associates the tax line with the specific transaction line it links to, supporting line-level tax reconciliation.
• PREVIOUS_CUSTOMER_TRX_ID / PREVIOUS_CUSTOMER_TRX_LINE_ID — Capture the prior transaction and line, providing audit lineage for credits and adjustments.
• LINE_NUMBER — Appears from both the transaction line and the tax line sources, giving the display order of the line and the tax line respectively.
• TAX_PRECEDENCE — Indicates the order in which tax was applied, relevant for compound or cascading tax calculations.
• TAX_CODE / VAT_TAX_ID / VALIDATE_FLAG — Resolved from AR_VAT_TAX; identify the tax code, its internal identifier, and whether the tax is subject to validation.
• TAX_RATE — The rate applied to derive the tax amount for the line.
• EXTENDED_AMOUNT — The extended tax amount for the tax line.
• AMOUNT_INCLUDES_TAX_FLAG — Indicates whether the line amount is inclusive of tax.
• AUTOTAX — Flags whether the tax was derived automatically by the tax engine.
• INTERFACE_LINE_CONTEXT / INTERFACE_LINE_ATTRIBUTE1..15 — Descriptive flexfield context and attribute values carried through from the interface, used for tax and interface mapping.
• DEFAULT_USSGL_TRANSACTION_CODE / DEFAULT_USSGL_TRX_CODE_CONTEXT — Default transaction code and its context for subledger accounting.
• ATTRIBUTE_CATEGORY / ATTRIBUTE1..15 and GLOBAL_ATTRIBUTE_CATEGORY / GLOBAL_ATTRIBUTE1..7 — Descriptive flexfield and global descriptive flexfield columns available for client-specific reporting.

Common Use Cases and Queries

Typical use cases include reporting tax by invoice line, reconciling tax amounts against general ledger balances, auditing automatic tax determination, and building extract files that feed tax reporting or analytics. Because the view exposes both the primary and credit-side tax lines, it is also useful for reviewing credit memo tax reversal detail.

A basic query to list tax lines for a given transaction:

• SELECT customer_trx_id, customer_trx_line_id, line_number, tax_code, tax_rate, extended_amount, amount_includes_tax_flag FROM ar_tax_lines_v WHERE customer_trx_id = :p_trx_id ORDER BY line_number;

A query to summarize tax by tax code for a transaction, useful in reconciliation:

• SELECT tax_code, SUM(extended_amount) tax_amount FROM ar_tax_lines_v WHERE customer_trx_id = :p_trx_id GROUP BY tax_code;

Because AR_TAX_LINES_V dates to early Receivables releases and its structure is documented primarily from Release 10SC, implementations should treat its column set as legacy and verify against the current data dictionary before depending on it for new development; the base transaction and tax tables, or the current tax views, are generally preferred for forward-looking integration.