Search Results excise_invoice_no




Overview
Explore in AI Chat

Overview

JAI_INV_INTERORG_AEL_V is a valid APPS-owned database view within the JA (Asia/Pacific Localizations) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata identifies it as the "Base view of OFI inter org transfer UI," meaning it serves as the foundational query layer that surfaces inter-organization inventory transfer activity for the Oracle Financials Intelligence / Subledger Accounting event infrastructure.

The view is engineered to emit records in the standard subledger accounting "AEL" (Accounting Event Line) column shape—APPLICATION_ID, EVENT_TYPE, TRX_CLASS, TRX_HDR_ID, TRX_HDR_TABLE, and the full complement of GL journal columns. This shape allows downstream accounting programs and reports in the localization layer to consume inter-org transfer transactions uniformly with other event sources. It carries a literal APPLICATION_ID of 7000 and an EVENT_TYPE of 'INTER ORG TRANSFER', with TRX_CLASS 'JAI INV INORGTRANSF'.

Underlying Base Objects

The view is defined over a join across the inventory, general ledger, and organization definition schemas. Documented referenced base objects include:

Joins are driven primarily by the GL journal header category equating to the JE category name, linking the captured transfer to its accounting representation.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling inter-org transfer journals for India localization reporting, tracing the GL accounting generated from an inventory transfer, and reviewing excise/VAT invoice references tied to stock movements.

A representative query:

  • SELECT trx_hdr_id, source_org, to_org, item_id, quantity, uom, je_header_id, entered_dr, entered_cr, accounting_date FROM apps.jai_inv_interorg_ael_v WHERE je_header_id IS NOT NULL;
  • To filter by organization: ... WHERE inventory_org_id = :org_id;
  • To isolate localization tax lines: ... WHERE excise_invoice_no IS NOT NULL OR vat_invoice_no IS NOT NULL;

Because the view is the documented base for the OFI inter-org transfer UI, it is also the appropriate source for any custom report or interface that must present transfer transactions in subledger accounting form.