Search Results additional_cvd

Overview

JAI_PO_RCV_TAXES_V is an APPS-owned database view in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, delivered as part of the JA (Asia/Pacific Localizations) product family. Its documented purpose is to expose PO/RCV tax information, consolidating receipt-matching tax lines sourced from the Indian localizations tax schema. The view is a UNION of two queries: the first labelled NON_PPA reports standard receipt-matching tax lines from JAI_RCV_LINE_TAXES, and the second labelled PPA (Post-Payment Adjustment, or retro tax change) reports adjustments calculated as the delta between modified and original tax amounts. The view is intended primarily for reporting and downstream integration, providing a uniform projection of tax amounts, tax identity, precedence, and recovery flags across both normal and retro-adjusted receipt transactions.

Underlying Base Objects

The ETRM metadata for 12.2.2 lists the referenced base objects as JAI_CMN_DOCUMENT_TAXES, JAI_CMN_LINES, JAI_CMN_TAXES_ALL, JAI_PO_TAXES, JAI_RCV_LINE_TAXES, JAI_RETRO_LINE_CHANGES, JAI_RETRO_TAX_CHANGES, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, all accessed through APPS synonyms. These synonyms point to the JAI (Japanese/Asia-Pacific localization) and RCV (Receiving) base tables. The core join pattern links JAI_RCV_LINE_TAXES to RCV_SHIPMENT_LINES and RCV_TRANSACTIONS via SHIPMENT_LINE_ID, and enriches each tax row with its definition from JAI_CMN_TAXES_ALL. The PPA branch joins JAI_RETRO_TAX_CHANGES, JAI_RETRO_LINE_CHANGES, and JAI_RCV_LINE_TAXES to derive adjustment deltas. JAI_PO_TAXES, JAI_CMN_LINES, and JAI_CMN_DOCUMENT_TAXES are referenced in the broader view definition to supply purchase-order-side tax context.

Key Columns

• MATCH_TYPE – Constant RCV_MATCHING, identifying the row as receipt-matching tax data.
• SOURCE – Either NON_PPA (standard receipt tax) or PPA (retro/post-payment adjustment).
• TRX_ID – The RCV transaction identifier, derived from RCV_TRANSACTIONS.TRANSACTION_ID as a character value.
• VENDOR_ID – Supplier identifier associated with the tax line.
• TAX_ID – Reference to the tax definition in JAI_CMN_TAXES_ALL.
• TAX_AMOUNT – Tax value; for PPA rows this equals MODIFIED_TAX_AMOUNT minus ORIGINAL_TAX_AMOUNT.
• CURRENCY – Currency code of the tax amount.
• TAX_TYPE – Tax classification; the view filters out TDS, CVD, and customs variants.
• TAX_LINE_NO – Line number of the tax within the transaction.
• PRECEDENCE_1 through PRECEDENCE_10 – Ordered calculation precedence for stacked taxes.
• MODVAT_FLAG – Recovery indicator; defaults to Y for NON_PPA and sourced from RECOVERABLE_FLAG for PPA.
• INC_TAX_FLAG, VAT_FLAG, ADHOC_FLAG, REVERSE_CHARGE_FLAG – Tax attributes from JAI_CMN_TAXES_ALL, defaulting to N.

Common Use Cases and Queries

The view supports reconciliation of receipt tax amounts, analysis of recoverable versus non-recoverable tax, and reporting on retro tax adjustments. Because the source column distinguishes NON_PPA from PPA, analysts can isolate adjustment impact. Note that the user search term doc_line_id does not appear as an exposed column in this view; document/line linkage is achieved indirectly, and callers seeking doc_line_id typically trace it through JAI_CMN_DOCUMENT_TAXES or the underlying JAI_RCV_LINE_TAXES. A representative query enumerating standard receipt taxes for a transaction is:

• SELECT trx_id, tax_id, tax_amount, currency, tax_type, modvat_flag FROM apps.jai_po_rcv_taxes_v WHERE source = 'NON_PPA' AND trx_id = :p_trx_id;
• SELECT source, SUM(tax_amount) FROM apps.jai_po_rcv_taxes_v WHERE vendor_id = :p_vendor GROUP BY source;

These patterns allow localization reporting on India/Asia-Pacific receipt taxes alongside their retro adjustments.