Search Results tax_code_name




Overview
Explore in AI Chat

Overview

APPS.AR_INVOICE_TAX_SUMMARY_V is a Receivables (AR) reporting view that consolidates tax information for customer transactions. It aggregates tax line details from RA_CUSTOMER_TRX_LINES and joins them to transaction headers, customer tax profiles, and Oracle E-Business Tax (EBTax) tax code definitions. The view is designed to present, per transaction, the total tax amount, the applied tax rate, the tax code name, the tax precedence, exemption references, and the Euro taxable base amount. It is commonly consumed by tax reporting, reconciliation, and invoice print/archive processes that require a summarized tax picture rather than the granular line-level detail.

The object is owned by the APPS schema and is documented as VALID in ETRM 12.2.2. Its structure is essentially unchanged between 12.1.1 and 12.2.2, with the notable dependency on MO_GLOBAL reflecting Multi-Org Access Control (MOAC) enforcement. The view abstracts the complexity of joining transaction lines to EBTax tax codes through the AR_INVOICE_SQL_FUNC_PUB package, which resolves the displayable tax code name based on ship-to site, customer profile, and printing option.

Because the view returns one row per combination of transaction, tax description, tax rate, exemption, sales tax, and precedence, it is a summarized rather than fully detailed line repository. Consumers must account for this grouping when performing further aggregation.

Underlying Base Objects

The view is defined over the following documented base objects:

The tax line join is outer to AR_VAT_TAX_VL (VAT_TAX_ID = VAT.VAT_TAX_ID(+)), allowing tax lines without a matching EBTax record to remain visible.

Key Columns

  • CUSTOMER_TRX_ID — identifier of the transaction header; primary grouping key.
  • TAX_PRINTING_OPTION — controls whether the tax code or printed tax name is used for display.
  • DESCRIPTION — tax line description.
  • TAX_AMOUNT — NVL(SUM(EXTENDED_AMOUNT), 0) of tax lines, the summarized tax value.
  • TAX_RATE — rate applied to the tax line.
  • TAX_CODE_NAME — resolved name from the AR function using ship-to site, account, printing option, printed tax name, and tax code.
  • TAX_EXEMPTION_ID — the exemption that applied to the line; central to determining tax-exempt transactions.
  • SALES_TAX_ID — legacy sales tax identifier.
  • TAX_PRECEDENCE — ordering value when multiple taxes apply.
  • EURO_TAXABLE_AMOUNT — sum of extended amounts from the linked (non-tax) lines.

Common Use Cases and Queries

Typical scenarios include tax reconciliation, exemption analysis, and invoice tax reporting. A representative query filtering on the search term is shown below.

Retrieve transactions whose tax lines carry a specific exemption:

  • SELECT customer_trx_id, tax_code_name, tax_rate, tax_amount, tax_exemption_id
  • FROM apps.ar_invoice_tax_summary_v
  • WHERE tax_exemption_id = :p_exemption_id;

Summarize total tax per transaction:

  • SELECT customer_trx_id, SUM(tax_amount) total_tax, SUM(euro_taxable_amount) taxable
  • FROM apps.ar_invoice_tax_summary_v
  • GROUP BY customer_trx_id;

List all tax codes applied to a transaction:

  • SELECT tax_code_name, tax_rate, tax_amount, tax_precedence
  • FROM apps.ar_invoice_tax_summary_v
  • WHERE customer_trx_id = :p_trx_id
  • ORDER BY tax_precedence;

Because the view applies EBTax and MOAC logic through underlying objects, queries should be executed in the correct operating unit context, and callers should account for the view's grouped grain when aggregating further.