Search Results ar_vat_tax_all




Overview
Explore in AI Chat

Overview

OKL_AR_TAX_LINES_ALL_UV is an APPS-owned database view within Oracle E-Business Suite that consolidates tax line information originating from Oracle Lease and Finance Management (OKL) contract billing and passed into Oracle Receivables. The view joins transactional header and line records from the Receivables transaction tables with the VAT tax configuration table, producing a flattened, reporting-friendly projection of tax data associated with lease contract invoices. Because its defining query filters on INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS' and LINE_TYPE = 'TAX', the view is scoped specifically to tax lines generated for OKL contracts rather than to the full breadth of Receivables transactions. This makes it a convenient single source for tax codes, rates, taxable amounts, and tax amounts without requiring report authors or integration developers to reconstruct the multi-table join themselves. The view name carries the "_UV" suffix convention, indicating a user view intended for consumption rather than as a base application object.

Underlying Base Objects

The ETRM metadata documents three base objects, all referenced through synonyms in the APPS schema:

The join path links header to line on CUSTOMER_TRX_ID, links the tax line (RTRL1) to the original line (RTRL) through LINK_TO_CUST_TRX_LINE_ID, and links the tax line to tax configuration through VAT_TAX_ID. The design assumes a one-to-many relationship between contract lines and their tax counterparts.

Key Columns

  • CUSTOMER_TRX_ID — identifier of the Receivables transaction header.
  • CUSTOMER_TRX_LINE_ID — identifier of the underlying contract line, not the tax line itself.
  • TAX_DATE — alias for the transaction date, useful for period-based tax reporting.
  • TAX_CODE and TAX_RATE — sourced from AR_VAT_TAX_ALL, describing the applicable tax classification and rate.
  • TAXABLE_AMOUNT — uses NVL to fall back to the original line's extended amount when no taxable amount is recorded on the tax line.
  • TAX_AMOUNT — the extended amount of the tax line.
  • CURRENCY_CODE — the invoice currency from the transaction header.
  • TBC — alias for ATTRIBUTE12 of the original line, an OKL-specific descriptive attribute.

Common Use Cases and Queries

The view supports VAT reconciliation for lease billings, tax audit extracts, and integration feeds requiring per-line tax detail. A representative query aggregates tax by code and period:

SELECT tax_code, tax_rate, currency_code, SUM(taxable_amount) taxable, SUM(tax_amount) tax
FROM apps.okl_ar_tax_lines_all_uv
WHERE tax_date BETWEEN :from_date AND :to_date
GROUP BY tax_code, tax_rate, currency_code;

A detail-level query joining on transaction identity retrieves line-level tax data for a specific contract invoice, while reconciliation against Receivables tax registers uses CUSTOMER_TRX_LINE_ID and CUSTOMER_TRX_ID as the driving keys.