Search Results cst_xla_inv_system_items_ref_v




Overview
Explore in AI Chat

Overview

CST_XLA_INV_SYSTEM_ITEMS_REF_V is an APPS-owned database view in Oracle E-Business Suite, registered under the Bills of Material (BOM) product family. It functions as a denormalized reference view of inventory item definitions, exposing item attribute and control flags from the master item tables alongside item cost classification data. The view is documented in ETRM for both 12.1.1 and 12.2.2 and holds a VALID status in the APPS schema.

Its principal role is to provide a stable, flattened projection of MTL_SYSTEM_ITEMS item attributes that subledger accounting and cost management processes can consume without repeatedly joining the key flexfield view. Because the view carries the CST_XLA_ prefix, it is associated with the Cost Management / Subledger Accounting (XLA) infrastructure, where item-level attributes are required to derive accounting rules, valuation methods, and transaction accounting for inventory and work in process activity. The view is therefore a reporting and integration artifact rather than a transactional object: it contains no data of its own and performs no DML.

Underlying Base Objects

According to the documented ETRM metadata for release 12.2.2, the view is defined over the following referenced base objects, all accessed through APPS synonyms:

  • MTL_SYSTEM_ITEMS (SYNONYM) — the primary source of item attribute and control flags, aliased as MSI.
  • MTL_SYSTEM_ITEMS_KFV (SYNONYM) — supplies the concatenated key flexfield segments exposed as ITEM_CONCATENATED_SEGMENTS, aliased as MSIK.
  • MTL_PARAMETERS (SYNONYM) — referenced for organization-level inventory parameters such as the inventory asset flag.
  • CST_ITEM_COSTS (SYNONYM) — referenced for cost-related attributes, aliased as CIC.

The view text joins MTL_SYSTEM_ITEMS to MTL_SYSTEM_ITEMS_KFV on the item and organization identifiers and enriches the result with the inventory asset flag and cost attributes from the parameters and cost tables. Because the definition is anchored on MTL_SYSTEM_ITEMS, the view inherits that table's organization-level granularity: item attributes are reported per inventory organization, not merely per master item.

Key Columns

The projection is broad and attributes are exposed under aliases that map directly to the underlying columns of MTL_SYSTEM_ITEMS. Notable columns include:

The presence of SOURCE_SUBINVENTORY is directly relevant to the user search term wip_supply_subinventory: sourcing attributes at this granularity are the same class of data used by WIP supply defaults, allowing report authors to correlate an item's default supply subinventory with WIP component supply settings.

Common Use Cases and Queries

Typical scenarios include validating item setups prior to cost roll-up, identifying items referenced by XLA accounting rules, and auditing which items are asset-tracked, buildable in WIP, or enabled for stock transactions. A representative query follows:

  • SELECT inventory_item_id, organization_id, item_concatenated_segments, inventory_asset_flag, build_in_wip_flag, bom_item_type, source_type, source_subinventory FROM cst_xla_inv_system_items_ref_v WHERE organization_id = :org_id AND bom_enabled_flag = 'Y';
  • SELECT item_concatenated_segments, inventory_asset_flag FROM cst_xla_inv_system_items_ref_v WHERE organization_id = :org_id AND stock_enabled_flag = 'Y' AND NVL(inventory_asset_flag,'N') = 'N'; — to isolate expense items.
  • SELECT item_concatenated_segments, source_subinventory FROM cst_xla_inv_system_items_ref_v WHERE organization_id = :org_id AND source_type = 1 AND source_subinventory IS NOT NULL; — to review default supply subinventories relevant to WIP supply assignment.

Queries should always filter by ORGANIZATION_ID to avoid cross-organization duplication and should be executed under a read-only or reporting responsibility in the APPS schema context.