Search Results vat_inv_num




Overview
Explore in AI Chat

Overview

JAI_PO_REC_VAT_AEL_V is a reporting view owned by the APPS schema within the JA (Asia/Pacific Localizations) product family of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to fetch accounting entries generated for the 'VAT CLAIM' event arising from purchasing and receiving activity. The view functions as an accounting event line (AEL) source: it presents subledger accounting lines, joined to their General Ledger journal header and line detail, in a denormalized form suitable for reconciliation, audit, tax reporting, and downstream integration interfaces.

The view exposes a fixed APPLICATION_ID of 7000 and a hard-coded EVENT_TYPE of 'VAT CLAIM', with transaction classification values 'JAI PO REC VAT' and 'JAI PO REC'. This confirms its role as a specialized extract over the JAI purchasing receipt VAT accounting stream, where recoverable VAT on receipts is claimed and posted to the ledger. Because the view surfaces both entered and accounted amounts alongside conversion attributes, it is directly usable by reporting tools, custom concurrent programs, and ETL routines that must reproduce or validate posted VAT claim entries without navigating the underlying subledger accounting tables directly.

Underlying Base Objects

The view is defined across a mix of synonyms and views. The transaction spine is supplied by JAI_RCV_TRANSACTIONS, JAI_RCV_HEADERS, JAI_RGM_TRX_RECORDS, and RCV_SHIPMENT_LINES. Receiving line context (line number, receiving subinventory, location) is drawn from RCV_SHIPMENT_LINES and HR_LOCATIONS. Supplier identification comes from PO_VENDORS and PO_VENDOR_SITES_ALL. Item and unit of measure detail is joined via MTL_UNITS_OF_MEASURE_VL.

The accounting side draws from GL_JE_LINES, GL_JE_HEADERS, GL_JE_CATEGORIES, GL_JE_SOURCES, GL_DAILY_CONVERSION_TYPES, and GL_IMPORT_REFERENCES. Supporting packages FND_GLOBAL and HR_GENERAL supply environment context such as organization and user identifiers. The joins assemble a single row per journal line associated with the VAT claim event, enriching each line with receipt, supplier, item, and shipment attributes.

Key Columns

Common Use Cases and Queries

The view supports VAT claim reconciliation, period-end tax reporting, and drill-down from GL journals back to receiving transactions. The SUB_INVENTORY column is frequently used to isolate VAT claims by inventory destination. A representative query is:

  • SELECT je_header_id, je_line_num, receipt_num, sub_inventory, vat_inv_num, vat_invoice_date, accounted_dr, accounted_cr FROM jai_po_rec_vat_ael_v WHERE sub_inventory = '&p_sub_inventory' AND accounting_date BETWEEN :p_from AND :p_to ORDER BY je_header_id, je_line_num;
  • SELECT party_name, party_number, SUM(accounted_dr) vat_claimed FROM jai_po_rec_vat_ael_v WHERE accounting_date BETWEEN :p_from AND :p_to GROUP BY party_name, party_number;
  • SELECT je_header_id, je_line_num, receipt_num, quantity, uom, vat_inv_num FROM jai_po_rec_vat_ael_v WHERE receipt_num = :p_receipt_num;

These patterns make the view effective for tax audits, supplier VAT analysis, and journal-to-receipt reconciliation, particularly where subinventory-level segmentation of claimed VAT is required.