Search Results vat_tax_rate




Overview
Explore in AI Chat

Overview

AR_TRX_TAX_L_V is a reporting and extraction view owned by the APPS schema in Oracle E-Business Suite, delivered under the Receivables (AR) product family. Its documented purpose is to provide a transaction tax line extract — a denormalized, query-friendly projection of Receivables tax lines that consolidates tax setup attributes, tax exemption attributes, VAT tax attributes, and the associated accounting flexfield identifiers required for downstream subledger accounting and tax reporting.

The view is directly relevant to searches for the keyword vat_tax_rate, since it explicitly projects the VAT tax rate column as VAT_TAX_TAX_RATE (aliased from AR_VAT_TAX_ALL_B.TAX_RATE), alongside a parallel Sales Tax rate column SALES_TAX_RATE (aliased from AR_SALES_TAX.SALES_TAX_RATE). This makes AR_TRX_TAX_L_V a convenient single source for tax rate, taxable basis, tax code, tax class, and tax type information without requiring joins to multiple AR tax setup tables. In 12.1.1 and 12.2.2 the object remains valid and is used principally by tax extraction programs, Subledger Accounting extracts, and custom reconciliation reports.

Underlying Base Objects

The view is defined over five documented base objects (all referenced through APPS synonyms):

The view is therefore a tax-specific slice of the broader AR extract model: it joins the XLA extract line to the tax setup definitions so that reporting consumers obtain both the transaction accounting context and the statutory tax attributes.

Key Columns

Common Use Cases and Queries

Typical uses include VAT rate validation, tax account reconciliation, and extraction of taxable basis and exemption data for reporting and audit.

  • Listing VAT tax rates applied to transactions:
  • SELECT VAT_TAX_TAX_CODE, VAT_TAX_TAX_RATE, VAT_TAX_TAXABLE_BASIS, VAT_TAX_TAX_TYPE FROM APPS.AR_TRX_TAX_L_V WHERE VAT_TAX_TAX_RATE IS NOT NULL;
  • Comparing VAT and sales tax rates per transaction:
  • SELECT SALES_TAX_ID, SALES_TAX_RATE, VAT_TAX_VAT_TAX_ID, VAT_TAX_TAX_RATE FROM APPS.AR_TRX_TAX_L_V;
  • Reviewing exemptions alongside the exempted tax code:
  • SELECT TAX_EXEMPTION_NUMBER, TAX_EXEMPTION_TYPE, TAX_EXEMPTION_PERCENT_EXEMPT, TAX_CODE_EXEMPTED FROM APPS.AR_TRX_TAX_L_V WHERE TAX_EXEMPTION_STATUS = 'A';

Because the view carries a hint forcing AR_XLA_LINES_EXTRACT_N1, performance is best when queries are driven by extract line identifiers. Standard recommendations apply: qualify the view with APPS., avoid functions on indexed extract columns, and grant the necessary responsibilities access to the underlying XLA extract data.