Search Results to_subinv

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:

• JAI_MTL_TRXS (SYNONYM) — the localization-specific transaction table, alias JMT, supplying the transfer header identity, from/to organizations, subinventories, item, quantity, and India-specific excise and VAT invoice numbers.
• MTL_MATERIAL_TRANSACTIONS (SYNONYM) — alias MMT, contributing SHIPMENT_NUMBER.
• MTL_UNITS_OF_MEASURE_VL (VIEW) and ORG_ORGANIZATION_DEFINITIONS (VIEW) — alias UOM and OOD1/OOD2, resolving unit of measure and source/target organization names.
• GL_JE_HEADERS, GL_JE_LINES, GL_JE_CATEGORIES, GL_JE_SOURCES, GL_DAILY_CONVERSION_TYPES, and GL_IMPORT_REFERENCES (SYNONYMS) — alias GJH, GJL, GJC, GJS, GLCT, and GJR, providing journal header, line, and currency conversion context.
• HR_GENERAL and HR_SECURITY (PACKAGES) — supporting organization and security access resolution.

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

• TRX_HDR_ID / TRX_HDR_TABLE — the transaction identifier and source table (JAI_MTL_TRXS), establishing event lineage.
• INVENTORY_ORG_ID — the from-organization identifier (JMT.FROM_ORGANIZATION).
• SOURCE_ORG / TO_ORG — human-readable organization names resolved via ORG_ORGANIZATION_DEFINITIONS.
• ITEM_ID, QUANTITY, UOM, FROM_SUBINV, TO_SUBINV — the item and movement detail of the transfer.
• JE_HEADER_ID, JE_LINE_NUM, ACCOUNT_ID, ACCOUNTING_DATE — the GL accounting linkage.
• ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — debit and credit amounts in entered and accounted currency.
• ENTERED_CURRENCY, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE — currency and conversion metadata.
• JE_CATEGORY, USER_JE_CATEGORY_NAME, JE_SOURCE, USER_JE_SOURCE_NAME — journal classification.
• SHIPMENT_NUMBER, EXCISE_INVOICE_NO, VAT_INVOICE_NO — logistics and India localization tax references.

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.