Search Results taxable_amount




Overview
Explore in AI Chat

Overview

OKL_CS_AR_TAX_LINES_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Lease and Finance Management (OKL) product family. Its documented purpose is to serve the Lease Center screen, where it displays tax lines associated with a given tax schedule. As a reporting and integration object, it consolidates header-level invoice information, line-level details, and tax configuration attributes into a single denormalized projection that application code and ad hoc reporting can consume without re-implementing the join logic.

The view is exposed through a naming convention typical of ETRM-style user views, where the "UV" suffix indicates a user-facing view intended to be queried directly by application screens or external reports. Because it is a view rather than a table, it is always valid against current transactional data and requires no separate maintenance.

Underlying Base Objects

The ETRM metadata documents three referenced base objects, all resolved through APPS-layer synonyms:

  • RA_CUSTOMER_TRX (synonym) — supplies the transaction header, aliased as RTRH. Provides CUSTOMER_TRX_ID and the transaction date used as the tax date.
  • RA_CUSTOMER_TRX_LINES_ALL (synonym) — referenced twice: once as RTRL (the contract line) and once as RTRL1 (the associated tax line). The self-join via LINK_TO_CUST_TRX_LINE_ID ties each tax line to its parent contract line.
  • AR_VAT_TAX_ALL (synonym) — aliased as ATX, supplying the tax code and tax rate configured for the applicable VAT tax identifier.

The join conditions restrict the result set to lines where INTERFACE_LINE_CONTEXT equals 'OKL_CONTRACTS', isolating lease-originated transactions, and where the related line's LINE_TYPE equals 'TAX'. Linkage between the tax line and the header is established through CUSTOMER_TRX_ID, while linkage between the tax line and the taxable parent line is established through VAT_TAX_ID and LINK_TO_CUST_TRX_LINE_ID.

Key Columns

  • CUSTOMER_TRX_ID — Identifier of the AR transaction header, enabling drill-back to the invoice.
  • CUSTOMER_TRX_LINE_ID — Identifier of the underlying contract line against which tax is assessed.
  • TAX_DATE — Aliased from RTRH.TRX_DATE; the transaction date that governs tax reporting periods. This is the column most relevant to date-based filtering of tax schedules.
  • TAX_CODE — Tax code or tax regime name from AR_VAT_TAX_ALL.
  • TAX_RATE — Configured tax rate applied to the taxable amount.
  • TAXABLE_AMOUNT — Derived via NVL(RTRL1.TAXABLE_AMOUNT, RTRL.EXTENDED_AMOUNT); falls back to the contract line's extended amount when the tax line carries no explicit taxable amount.
  • TAX_AMOUNT — Extended amount of the tax line, expressing the tax charged.
  • CURRENCY_CODE — Invoice currency inherited from the transaction header.
  • TBC — Mapped from RTRL.ATTRIBUTE12, a descriptive flexfield attribute used for tax-specific supplementary data.

Common Use Cases and Queries

Typical scenarios include lease tax reconciliations, period-end tax reporting, and Lease Center screen rendering. A representative query filtering by tax date is:

  • SELECT tax_date, tax_code, tax_rate, taxable_amount, tax_amount, currency_code FROM okl_cs_ar_tax_lines_uv WHERE tax_date BETWEEN :start_date AND :end_date;
  • SELECT tax_code, SUM(tax_amount) FROM okl_cs_ar_tax_lines_uv WHERE tax_date >= :period_start GROUP BY tax_code;
  • SELECT customer_trx_id, tax_amount FROM okl_cs_ar_tax_lines_uv WHERE customer_trx_id = :trx_id;

Queries should be directed at the APPS schema or executed through a responsibility with appropriate AR and OKL read privileges, as the view inherits security from its base tables.