Results for “ar_tax_summ_v”

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

Overview

AR_TAX_SUMM_V is a view owned by the APPS schema in Oracle E-Business Suite Receivables. Its documented status is VALID, and it is classified as an AR - Receivables object. The view presents a summarized, per-transaction tax picture derived from tax lines on customer transactions, aggregating extended tax amounts grouped by tax precedence, tax code, tax-inclusiveness flag, tax rate, and customer transaction identifier. In effect, it reconciles tax lines against their parent inventory or freight lines and against the VAT tax definitions that qualify them.

ETRM documentation annotates this view with the qualifier "(Release 10SC Only)". This indicates the view originated in an early Receivables release and was retained for backward compatibility. In Oracle EBS 12.1.1 and 12.2.2 the view remains valid but should be treated as a legacy reporting and integration artifact rather than a strategically supported interface. Customers upgrading to 12.x still find it referenced by custom reports, reconciliation extracts, and downstream tax interfaces written against Release 10SC semantics, which is the principal reason it survives in the APPS data dictionary.

Underlying Base Objects

The documented base objects for AR_TAX_SUMM_V are two synonyms: RA_CUSTOMER_TRX_LINES and AR_VAT_TAX. The view references RA_CUSTOMER_TRX_LINES four times under the aliases CTL_INV_LINE, CTL_INV_TAX, CTL_LINE, and CTL_TAX, forming a self-join chain that separates invoice lines, their linked tax lines, and the tax line's own predecessor relationships. AR_VAT_TAX is outer-joined twice, as VAT and INV_VAT, supplying the tax code that qualifies the current tax line and its referenced prior tax line respectively.

The join logic keys on LINK_TO_CUST_TRX_LINE_ID, PREVIOUS_CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_LINE_ID, and VAT_TAX_ID. The filter CTL_TAX.LINE_TYPE = 'TAX' restricts the driving row set to tax lines, while the outer joins preserve tax rows whose VAT definition or predecessor line is absent. Because the underlying objects are synonyms, the physical tables reside in the Receivables product schema and are exposed to APPS through standard synonym definitions.

Key Columns

• TAX_PRECEDENCE — Ordering value indicating the sequence in which the tax applies relative to other taxes on the transaction.
• VAT_TAX_CODE — Tax code from AR_VAT_TAX. The ETRM column listing shows AVT_TAX_CODE; the view text selects VAT.TAX_CODE.
• TAX_INCLUSIVE_FLAG — Corresponds to AMOUNT_INCLUDES_TAX_FLAG; indicates whether the tax amount is embedded in the line amount or added to it.
• TAX_RATE — The rate applied to the taxable base for the tax line.
• CUSTOMER_TRX_ID — Identifier of the customer transaction to which the summarized tax belongs.
• EXTENDED_AMOUNT — The aggregation target; SUM of EXTENDED_AMOUNT across qualifying tax lines for the grouping key.

Common Use Cases and Queries

Typical uses include per-transaction tax rollups, reconciliation of tax lines to VAT tax definitions, and feeds into legacy tax reporting extracts. A representative query follows.

• SELECT customer_trx_id, vat_tax_code, tax_rate, tax_inclusive_flag, tax_precedence, extended_amount FROM apps.ar_tax_summ_v WHERE customer_trx_id = :p_trx_id ORDER BY tax_precedence;
• Aggregated reporting by code, for example grouping extended_amount by vat_tax_code across a period's transactions, is supported directly by the view's GROUP BY.
• Because grouping is fixed in the view definition, users needing base-line detail must query RA_CUSTOMER_TRX_LINES directly.