Search Results jai_ap_taxes_v

Overview

JAI_AP_TAXES_V is a consolidated reporting view owned by the APPS schema within the JA (Asia/Pacific Localizations) product family. Its documented purpose is to fetch tax information attached to a standalone Oracle Payables invoice, providing a single, uniform access point for tax lines regardless of whether the invoice was created standalone or matched against a purchase order. Because the user search term "tax_rate" maps directly to a column exposed by this view, JAI_AP_TAXES_V is frequently the object of interest for consultants and developers reporting on tax computations in the Asia/Pacific localization. The view is registered as VALID and is exposed as an APPS object in both 12.1.1 and 12.2.2, maintaining a consistent interface across the two releases.

Underlying Base Objects

JAI_AP_TAXES_V is not defined over physical base tables directly; it is a UNION ALL of two other localization views, JAI_AP_STANDALONE_TAXES_V and JAI_AP_MATCH_INV_TAX_V. The first branch of the union selects from JAI_AP_STANDALONE_TAXES_V, renaming SOURCE_DOC_ID to INVOICE_ID and SOURCE_DOC_PARENT_LINE_NO to PARENT_LINE_NUMBER. The second branch selects from JAI_AP_MATCH_INV_TAX_V, renaming INVOICE_ID, PARENT_INVOICE_LINE_NUMBER and CURRENCY into the same normalized column set. This union strategy means the view presents a harmonized picture of taxes for both standalone AP invoices and invoices derived from matching, without requiring the calling report or interface to distinguish the source. Both underlying objects are themselves views within the same JA localization schema, so the full lineage extends further into the JA tax schema, but the documented referenced base objects are limited to these two views.

Key Columns

• INVOICE_ID — The AP invoice header identifier to which the tax line belongs; derived from SOURCE_DOC_ID or INVOICE_ID depending on the union branch.
• PARENT_LINE_NUMBER — The invoice line number that the tax line is attached to, taken from SOURCE_DOC_PARENT_LINE_NO or PARENT_INVOICE_LINE_NUMBER.
• TAX_LINE_NO — Sequential identifier for the tax line itself.
• TAX_ID — Identifier of the tax or tax regime applied to the line.
• TAX_TYPE — Classification of the tax, for example whether it is a withholding, excise, VAT or similar localization tax category.
• CURRENCY_CODE — Currency in which the tax is expressed, sourced from CURRENCY_CODE or CURRENCY.
• TAX_RATE — The rate applied to compute the tax; this is the column most commonly referenced when users search for "tax_rate".
• QTY_RATE — A quantity-based rate used for taxes calculated per unit of measure rather than as a percentage of value.
• UOM — Unit of measure associated with QTY_RATE where applicable.
• TAX_AMT — The computed tax amount for the line.
• MODVAT_FLAG — Indicator of MODVAT treatment, relevant to Indian localization excise handling.
• PRECEDENCE_1 through PRECEDENCE_10 — Ten ordered columns reflecting the tax precedence rules used in the JA tax engine to determine how multiple taxes are cascaded and calculated.

Common Use Cases and Queries

The view is typically joined to AP invoice headers and lines (AP_INVOICES_ALL, AP_INVOICE_LINES_ALL) using INVOICE_ID and PARENT_LINE_NUMBER to produce tax detail reports. It is also used in reconciliations between the JA tax engine output and standard Payables tax, and for auditing the effective tax rate applied to imported or externally loaded invoices.

A representative query retrieving tax rates for an invoice is:

• SELECT INVOICE_ID, PARENT_LINE_NUMBER, TAX_LINE_NO, TAX_TYPE, CURRENCY_CODE, TAX_RATE, TAX_AMT FROM APPS.JAI_AP_TAXES_V WHERE INVOICE_ID = :p_invoice_id ORDER BY PARENT_LINE_NUMBER, TAX_LINE_NO;

To examine how precedence cascades drive the tax calculation, the PRECEDENCE_1 through PRECEDENCE_10 columns can be selected alongside TAX_RATE. Because the view is a UNION ALL over two views, queries filtering on a specific invoice typically touch only one branch, while unfiltered queries scan both; adding a selective predicate on INVOICE_ID or TAX_ID is the standard tuning approach.