Search Results h_subinventory_code

Overview

The CST_XLA_INV_HEADERS_V view is an Oracle E-Business Suite (EBS) dictionary object owned by the APPS schema. It is classified under the BOM (Bills of Material) product family and is registered as a VALID database view in both EBS 12.1.1 and 12.2.2. The view functions as a bridge between the subledger accounting architecture (XLA) and the inventory and Cost Management transaction model. It exposes event header information held in the XLA events interface and enriches it with detail attributes drawn from material transaction records. Its primary role is to present a flattened, query-friendly projection of inventory cost events so that downstream reporting, reconciliation, and integration logic can associate an XLA event with its underlying inventory transaction, organization, item, cost group, subinventory, and locator context.

A distinctive characteristic of this view is its explicit handling of the CG_TXFR event type, which corresponds to a Cost Group Transfer. The view text uses DECODE(XEG.EVENT_TYPE_CODE, 'CG_TXFR', ...) expressions to substitute fixed transaction type, source type, and action identifiers for cost group transfer events, while retaining the standard MTL_MATERIAL_TRANSACTIONS values for all other event types. This design ensures that cost group transfers, which may not map cleanly onto a conventional inventory transaction, are still presented with valid transaction taxonomy.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, the view references the following base objects:

• CSTPSCHK (PACKAGE) – a Cost Management package associated with transaction validation and processing.
• MTL_MATERIAL_TRANSACTIONS (SYNONYM) – the core inventory transaction table supplying transaction identifiers, quantities, item, revision, organization, cost group, subinventory, and locator details.
• MTL_PARAMETERS (SYNONYM) – organization-level inventory parameters used for validation and defaulting.
• WSH_SHIPPING_PARAMETERS (SYNONYM) – shipping parameter information, typically relevant to transfer and shipping-related inventory events.
• XLA_EVENTS_GT (SYNONYM) – the global temporary table holding XLA event records, aliased as XEG in the view text, which supplies EVENT_ID, LEDGER_ID, EVENT_TYPE_CODE, and the SOURCE_ID_INT_2 organization reference.

The view text applies a CARDINALITY(XEG, 1) optimizer hint, reflecting an expectation that the XLA events global temporary table contributes a single row per event in the join.

Key Columns

• EVENT_ID – identifier of the XLA accounting event.
• H_LEDGER_ID – ledger associated with the event, renamed to distinguish it from transaction-level ledger attributes.
• DISTRIBUTION_TYPE – constant value 'MTL_TRANSACTION_ACCOUNTS', indicating the distribution category.
• TRANSACTION_ID – the underlying MTL_MATERIAL_TRANSACTIONS transaction identifier.
• TRANSACTION_TYPE_ID / TRANSACTION_SOURCE_TYPE_ID / TRANSACTION_ACTION_ID – transaction taxonomy columns, conditionally overridden for CG_TXFR events with values 86, 13, and 55 respectively.
• PRIMARY_QUANTITY – the primary quantity of the material transaction.
• ORGANIZATION_ID – derived from XEG.SOURCE_ID_INT_2.
• INVENTORY_ITEM_ID and REVISION – item and revision being transacted.
• TRANSFER_ORGANIZATION_ID, H_COST_GROUP_ID, H_TRANSFER_COST_GROUP_ID, H_SUBINVENTORY_CODE, H_TRANSFER_SUBINVENTORY, H_LOCATOR_ID – paired "from/to" attributes resolved via DECODE logic that compares the event organization against the transaction organization, correctly orienting source and destination values for cost group transfers where the from and to organizations may be identical.

Common Use Cases and Queries

This view is typically queried to reconcile inventory cost events with material transaction detail, to report on cost group transfers, and to feed downstream accounting or integration extracts. A representative query follows:

• SELECT EVENT_ID, TRANSACTION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, H_COST_GROUP_ID, H_TRANSFER_COST_GROUP_ID, PRIMARY_QUANTITY FROM APPS.CST_XLA_INV_HEADERS_V WHERE H_LEDGER_ID = :ledger_id;
• Analysts investigating cost group transfer activity may filter on the transaction taxonomy columns to isolate events transformed by the CG_TXFR logic.
• Integration processes join this view to XLA distributions and accounting lines to construct complete journal entry mappings for inventory transactions.