Search Results jai_ap_standalone_taxes_v




Overview
Explore in AI Chat

Overview

JAI_AP_STANDALONE_TAXES_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Asia/Pacific Localizations (JA) product family. Its documented purpose is to list the taxes applicable to a standalone AP invoice. In the EBS 12.1.1 and 12.2.2 architectures, the JA localizations deliver a common tax engine that captures tax determination and calculation results in a central repository rather than relying solely on the standard Payables tax columns. This view exposes one slice of that repository — the records whose source document type identifies them as belonging to a standalone invoice — in a denormalized, reporting-friendly form.

The view is defined with a status of VALID and is intended for read access by reporting tools, custom concurrent programs, and integration layers that must retrieve the tax lines of a standalone AP invoice without re-implementing the aggregation logic performed by the tax engine.

Underlying Base Objects

The view is defined over a single documented base object, JAI_CMN_DOCUMENT_TAXES (referenced in the metadata via a synonym). JAI_CMN_DOCUMENT_TAXES is the central tax line table of the JA common tax engine, holding one row per calculated tax line for each source document. The view filters that table with the predicate SOURCE_DOC_TYPE = 'STANDALONE_INVOICE', so only tax lines originating from standalone invoices are returned. The remaining rows of the base table, which correspond to other source document types such as regular invoices, credit memos, and requisitions, are intentionally excluded.

Key Columns

Common Use Cases and Queries

The view is typically joined to AP invoice headers or lines through SOURCE_DOC_ID and SOURCE_DOC_LINE_ID to produce tax summaries for standalone invoices, to reconcile calculated tax against the invoice total, or to feed downstream tax reporting extracts. A representative query is shown below.

SELECT doc_tax_id,
       tax_line_no,
       tax_id,
       tax_rate,
       tax_amt,
       func_tax_amt,
       source_doc_id,
       source_doc_line_id
FROM   apps.jai_ap_standalone_taxes_v
WHERE  source_doc_id = :p_invoice_id
ORDER  BY tax_line_no;

Because the view already restricts SOURCE_DOC_TYPE and applies the GROUP BY aggregation documented in its definition, consumers receive consolidated tax amounts per line without needing to duplicate that logic. Access is granted through the APPS schema, and the object is documented as Oracle proprietary and confidential.