Search Results taxable_amount




Overview
Explore in AI Chat

Overview

AR_XML_INVOICE_TAX_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite Receivables. It exposes tax line information for customer transactions in a flattened, eXtensible Markup Language (XML)-friendly format, intended for use by the Receivables XML invoice generation and e-invoicing/print infrastructure. In release 12.1.1 and 12.2.2, the view supplies tax detail records that correspond to individual invoice lines so that third-party or Oracle-delivered XML publishing programs can render tax amounts, taxable bases, rates, and tax codes alongside the parent transaction lines.

The view is not a transactional object; it is a reporting and integration construct. Because its output is keyed to customer transaction lines and only returns rows where the tax line is linked to a parent transaction line, it presents a clean, purpose-built dataset rather than the full set of tax lines held in Receivables.

Underlying Base Objects

The 12.2.2 metadata documents the view as defined over the following base objects:

The core join is L.VAT_TAX_ID = V.VAT_TAX_ID, filtered by L.LINE_TYPE = 'TAX' and L.LINK_TO_CUST_TRX_LINE_ID IS NOT NULL, with results ordered by LINE_NUMBER. The dependency on AR_XML_VIEW_FUNCTIONS makes the view non-deterministic in cost terms: each function call executes against the transaction context, so performance is driven by row count and function logic rather than by simple table access.

Key Columns

  • CUSTOMER_TRX_LINE_ID — primary identifier of the tax line in RA_CUSTOMER_TRX_LINES.
  • LINK_TO_CUST_TRX_LINE_ID — the parent invoice line to which the tax line is attributed; the mandatory filter on this column ensures only attached tax lines are returned.
  • TAX_AMOUNT — mapped from the tax line's EXTENDED_AMOUNT.
  • TAXABLE_AMOUNT — the base amount on which tax was assessed.
  • TAX_RATE — the rate applied to the taxable amount.
  • TAX_CODE — the tax code from AR_VAT_TAX.
  • LINE_NUMBER and DESCRIPTION — line sequencing and descriptive text forwarded from the transaction line.
  • USER1–USER5 — values returned by AR_XML_VIEW_FUNCTIONS.TAX_FUNCTION1–5, used to feed XML descriptive flexfield segments.

Common Use Cases and Queries

The view is typically consumed by XML invoice templates and reconciliation reports that must show the tax breakdown per invoice line.

  • Retrieving tax lines for a specific invoice count.
  • Feeding an XML publishing template with tax_code, tax_rate, taxable_amount, and tax_amount.
  • Auditing tax against the parent line.
SELECT t.customer_trx_line_id,
       t.link_to_cust_trx_line_id,
       t.tax_code,
       t.tax_rate,
       t.taxable_amount,
       t.tax_amount
FROM   ar_xml_invoice_tax_v t,
       ra_customer_trx_lines l
WHERE  t.customer_trx_line_id = l.customer_trx_line_id
AND    l.customer_trx_id = :p_trx_id
ORDER  BY t.line_number;

Because USER1–USER5 invoke packaged functions, queries returning large row sets should be restricted by transaction identifiers to avoid excessive function executions.