Results for “jai_inv_interorg_ael_sl_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view APPS.JAI_INV_INTERORG_AEL_SL_V is a subledger accounting (SLA) presentation view delivered as part of the JA – Asia/Pacific Localizations product family within Oracle E-Business Suite. It exposes inter-organization inventory accounting line information in a structure conforming to the standard Subledger Accounting (XLA) accounting event line model, allowing the localizations to feed or reference general ledger accounting entries generated from inter-org inventory transactions.

Its status is VALID in the ETRM 12.2.2 repository, and the object is owned by the APPS schema. The view serves as a localization-specific analogue of the standard SLA accounting line views (such as XLA_AE_LINES), re-mapping inter-org inventory AEL data into the canonical column set expected by accounting extract, reconciliation, and transfer-to-GL reporting processes. Because it selects from JAI_INV_INTERORG_AEL_V, it is a thin presentation layer rather than a source of new accounting logic; the underlying localization view holds the substantive derivation rules and joins.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects:

• JAI_INV_INTERORG_AEL_V (VIEW) — the immediate parent view from which all data is projected. This is the primary data source and carries the inter-org accounting event line columns.
• HR_GENERAL (PACKAGE) — the standard HR security utility used to resolve the current user's accessible business groups and organizations.
• HR_SECURITY (PACKAGE) — used in conjunction with HR_GENERAL to enforce organization-level (MO: Security Profile / security profile) access restrictions so that users only see accounting lines for organizations they are authorized to view.

The dependency on HR_SECURITY and HR_GENERAL confirms that the view is secured at the organization level, a common requirement for inventory and inter-org reporting in multi-org environments. Practically, this means query results are filtered by the caller's security profile, and two users running the same SQL may see different row sets. The view does not introduce its own joins to the accounting tables; instead, it standardizes and renames the columns returned by JAI_INV_INTERORG_AEL_V.

Key Columns

The view text maps source columns into the standardized SLA accounting-line interface. Significant columns include:

• ACCOUNTED_DR / ACCOUNTED_CR — the accounted (functional currency) debit and credit amounts for the accounting line.
• ENTERED_DR / ENTERED_CR — the entered (transaction currency) debit and credit amounts.
• CURRENCY_CODE — the entered currency, aliased from ENTERED_CURRENCY, accompanied by CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, and CURRENCY_USER_CONVERSION_TYPE.
• CODE_COMBINATION_ID — the accounting flexfield combination, aliased from ACCOUNT_ID.
• SET_OF_BOOKS_ID — the ledger (set of books) to which the accounting line belongs.
• ACCOUNTING_DATE — the GL accounting date for the line.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — the SLA accounting line type code and its descriptive name, derived from EVENT_TYPE.
• TRX_CLASS / TRX_CLASS_NAME — the transaction class of the originating inter-org inventory transaction.
• TRX_DATE — the transaction date, aliased from TRANSACTION_DATE.
• TRX_HDR_ID / TRX_HDR_TABLE — the transaction header identifier and its source table, used to link the accounting line back to the underlying inventory transaction.
• SOURCE_ID — aliased from JE_HEADER_ID, identifying the journal entry header.
• DOC_SEQUENCE_ID — the document sequence, aliased from JE_LINE_NUM.
• APPLICATION_ID — the owning application of the accounting event.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Many SLA-interface columns (AEH_ID, AEL_ID, AEL_TABLE, GL_TRANSFER_STATUS, TAX_* , THIRD_PARTY_*, ORG_ID, REQUEST_ID) are cast as NULL or TO_NUMBER(NULL), indicating that the view presents a deliberately simplified projection rather than a full SLA row set.

Common Use Cases and Queries

Typical uses include reconciliation of inter-org inventory accounting to the general ledger, verifying accounted versus entered amounts, and building localization-specific accounting extracts. A basic query is:

• SELECT accounting_date, trx_class_name, code_combination_id, entered_dr, entered_ccr, accounted_dr, accounted_cr, currency_code FROM apps.jai_inv_interorg_ael_sl_v WHERE set_of_books_id = :ledger_id AND accounting_date BETWEEN :from_date AND :to_date; — to review accounting lines for a ledger over a period.
• SELECT trx_hdr_id, trx_hdr_table, SUM(accounted_dr), SUM(accounted_cr) FROM apps.jai_inv_interorg_ael_sl_v GROUP BY trx_hdr_id, trx_hdr_table; — to reconcile line-level amounts back to each inter-org transaction header.
• Joining the view to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID and to GL_LEDGERS on SET_OF_BOOKS_ID for reporting and extract programs.

Because the view is secured via HR_GENERAL and HR_SECURITY, reports and extracts built on it automatically respect organizational access, and users should generally avoid querying it outside an appropriately set security context.