Search Results taxable_amount




Overview
Explore in AI Chat

Overview

OKL_AR_TAX_LINES_ALL_UV is a read-only view owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It belongs to the OKL — Lease and Finance Management product family and serves as the bridge between Lease Center and Oracle Receivables (AR) tax data. Specifically, the view exposes the tax lines that AR has generated for a given tax schedule so that Lease Center can retrieve, display, and reconcile those lines against the lease contract.

Because tax calculation for leases is ultimately performed within Receivables through the E-Business Tax / VAT engine, Lease Management does not store its own tax amounts. Instead, it queries AR transaction and tax records through this view, which flattens the join across invoice headers, invoice lines, tax lines, and tax codes into a single, denormalized result set. This makes it suitable for reporting, integration, and programmatic consumption where the caller needs the taxable base, tax rate, and computed tax amount for each tax line tied to a lease contract invoice.

Underlying Base Objects

The view is defined over four objects, three of which are documented base objects (presented as synonyms in the APPS schema):

  • RA_CUSTOMER_TRX_ALL — the AR transaction (invoice/credit memo) header.
  • RA_CUSTOMER_TRX_LINES_ALL — the AR transaction lines; it appears twice in the FROM clause, once as the lease contract line (RTRL) and once as the tax line (RTRL1).
  • AR_VAT_TAX_ALL — the tax code definition, supplying tax code and rate.

The join is driven by CUSTOMER_TRX_ID linking header to line, and by LINK_TO_CUST_TRX_LINE_ID linking the tax line back to its parent contract line. Two filters shape the result: the contract line must have INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS', and the related line must have LINE_TYPE = 'TAX'. This restricts output to lease contract invoices and their corresponding tax lines.

Key Columns

  • CUSTOMER_TRX_ID — identifier of the AR transaction header.
  • CUSTOMER_TRX_LINE_ID — identifier of the lease contract line to which the tax applies.
  • TAX_DATE — the transaction date, aliased from TRX_DATE.
  • TAX_CODE — the tax code from AR_VAT_TAX_ALL.
  • TAX_RATE — the tax rate applied.
  • TAXABLE_AMOUNT — the base on which tax is calculated. It uses NVL(RTRL1.TAXABLE_AMOUNT, RTRL.EXTENDED_AMOUNT), so if the tax line does not carry its own taxable amount, the contract line's extended amount is substituted.
  • TAX_AMOUNT — the extended amount of the tax line (RTRL1.EXTENDED_AMOUNT).
  • CURRENCY_CODE — the invoice currency, aliased from INVOICE_CURRENCY_CODE.
  • TBC — sourced from RTRL.ATTRIBUTE12, a descriptive attribute used by Lease Center.

Common Use Cases and Queries

Typical scenarios include reconciling lease tax schedules, feeding tax data into Lease Center screens, and building custom reports that compare taxable base against computed tax. A representative query filtering on the taxable amount is:

  • SELECT customer_trx_id, customer_trx_line_id, tax_code, taxable_amount, tax_amount FROM okl_ar_tax_lines_all_uv WHERE taxable_amount > 0;
  • Aggregating tax by code: SELECT tax_code, SUM(taxable_amount), SUM(tax_amount) FROM okl_ar_tax_lines_all_uv GROUP BY tax_code;
  • Retrieving all tax lines for one transaction: SELECT * FROM okl_ar_tax_lines_all_uv WHERE customer_trx_id = :p_trx_id;

Because the object is a view with no DML support, it should be used strictly for read operations. Reports should filter by transaction or date to avoid the cost of scanning the underlying AR tables.