Search Results inc_tax_flag

Overview

APPS.JAI_PO_RCV_TAXES_V is a SQL view in Oracle E-Business Suite that consolidates India-localized (JAI) tax information associated with purchasing and receiving transactions. Its principal role is to expose, in a single unified structure, the tax lines captured against receipt and receiving-matching activity, and to distinguish those lines according to whether they originate from non-PPA (non-purchase-price-adjustment) processing or from PPA/retro-tax-adjustment processing. The user query "non_ppa" maps directly to the SOURCE column value 'NON_PPA' emitted by the first branch of the view's UNION. This makes the view the reference object for reporting on standard receiving tax lines as opposed to retroactive or modified tax lines.

The view is defined as a UNION of two queries, each tagged with a match_type of 'RCV_MATCHING' and a SOURCE of either 'NON_PPA' or 'PPA'. This dual-branch design allows downstream consumers such as tax registers, reconciliation reports, and integrations to retrieve both populations consistently while still being able to filter by origin.

Underlying Base Objects

The view is defined over both JAI and standard receiving objects, documented as synonyms in APPS. In the NON_PPA branch, the driving table is JAI_RCV_LINE_TAXES (aliased jrl), joined to RCV_SHIPMENT_LINES and RCV_TRANSACTIONS on shipment_line_id, and to JAI_CMN_TAXES_ALL on tax_id. The PPA branch introduces JAI_RETRO_TAX_CHANGES, JAI_RETRO_LINE_CHANGES, and reuses JAI_RCV_LINE_TAXES as the precedence source.

The documented referenced base objects include 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. The view therefore bridges the receiving transaction model with the JAI tax configuration and retro-adjustment model.

Key Columns

• match_type — constant 'RCV_MATCHING' identifying the process context.
• SOURCE — 'NON_PPA' for standard receiving tax lines; 'PPA' for retro price-adjustment tax lines. This is the column relevant to the "non_ppa" search.
• trx_id — character representation of RCV_TRANSACTIONS.transaction_id.
• vendor_id, tax_id, tax_type, tax_line_no — supplier, tax identifier, classification, and line sequence.
• tax_amount — for NON_PPA, the recorded tax_amount; for PPA, the difference between modified and original tax amounts.
• currency — tax currency.
• precedence_1 … precedence_10 — the JAI tax precedence attributes used for tax determination and reporting.
• modvat_flag — recoverable/Modvat indicator; NVL defaults to 'Y' in NON_PPA and uses recoverable_flag in PPA.
• inc_tax_flag, vat_flag, adhoc_flag, reverse_charge_flag — tax configuration attributes sourced from JAI_CMN_TAXES_ALL, with NVL defaults of 'N'.

The NON_PPA branch explicitly excludes tax types TDS, CVD, ADDITIONAL_CVD, CUSTOMS, and the customs cess variants, using NVL(UPPER(tax_type),'TDS'). This filtering ensures only relevant indirect taxes are exposed.

Common Use Cases and Queries

Typical uses include India tax register reporting, reconciliation of receiving tax lines against supplier invoices, and integrations extracting receipt-linked taxes. To isolate non-PPA lines, filter on SOURCE = 'NON_PPA'.

Sample query:

• SELECT trx_id, vendor_id, tax_id, tax_type, tax_amount, currency, modvat_flag FROM apps.jai_po_rcv_taxes_v WHERE SOURCE = 'NON_PPA';
• SELECT SOURCE, COUNT(*), SUM(tax_amount) FROM apps.jai_po_rcv_taxes_v GROUP BY SOURCE;
• SELECT trx_id, tax_type, tax_amount FROM apps.jai_po_rcv_taxes_v WHERE SOURCE = 'NON_PPA' AND reverse_charge_flag = 'Y';

Because the view performs a UNION across receipt, retro-change, and tax-configuration tables, queries should filter by SOURCE or trx_id where possible to limit row volume in 12.1.1 and 12.2.2 environments.