Search Results cst_xla_interorg_params_ref_v




Overview
Explore in AI Chat

Overview

The CST_XLA_INTERORG_PARAMS_REF_V view is an Oracle EBS subledger accounting (SLA) reference object owned by the APPS schema, supplied as part of the BOM (Bills of Material) product family. Its documented purpose is to expose inter-organization general ledger accounts for AX backward compatibility. In the EBS 12.1.1 and 12.2.2 architectures, inter-organization transfers are accounted through the Subledger Accounting engine (XLA) rather than through the legacy transaction-based posting that existed before R12. This view is the compatibility bridge that allows the XLA costing and accounting programs to resolve inter-organization account assignments in the same manner as the prior AX (Accounting) model.

The view dynamically resolves the correct GL account set for a given inter-organization event by joining the active XLA events in the current batch (via the global temporary table XLA_EVENTS_GT) to the inventory header context view and the inter-organization parameter setup, then filtering by transaction action and event class. Users searching for interorg_price_var_account will find that this identifier surfaces here as the INTERORG_PRICE_VAR_ACCOUNT column, which represents the account used to absorb price variances arising between the sending and receiving organizations.

Underlying Base Objects

The documented base objects referenced by the view are:

  • CSTPSCHK (PACKAGE) — the costing process package whose logic drives the inter-organization accounting flow.
  • CST_XLA_INV_HEADERS_V (VIEW) — supplies transaction header context, including ORGANIZATION_ID, TRANSFER_ORGANIZATION_ID, and TRANSACTION_ACTION_ID.
  • MTL_INTERORG_PARAMETERS (SYNONYM) — the setup table holding the GL accounts defined per from/to organization pair; aliased as IORGP in the view text.
  • XLA_EVENTS_GT (SYNONYM) — the global temporary table containing the event IDs currently being processed by the accounting engine.

The view is therefore a runtime resolver rather than a persisted accounting record. It inherits its account values directly from MTL_INTERORG_PARAMETERS and correlates them to open XLA events on the basis of event class code and transaction action.

Key Columns

Common Use Cases and Queries

This view is primarily used to diagnose which accounts the SLA engine will apply to inter-organization transactions — receipts against internal orders, direct inter-organization receipts, FOB receipt/ship flows, and user-defined event classes. A typical query to examine the price variance account for a transfer is:

SELECT from_organization_id, to_organization_id, interorg_price_var_account FROM apps.cst_xla_interorg_params_ref_v;

To restrict results to a specific event, join on EVENT_ID from XLA_EVENTS. Note that because the view reads from XLA_EVENTS_GT, it returns rows only within the context of an accounting batch; standalone ad-hoc queries against it outside event processing will generally not return the global temporary data expected.