Results for “revision_label”

50+ results




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

Overview

The view APPS.CST_XLA_INV_ITEM_REVS_REF_V is a Costing-subscribed reference view delivered as part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 distributions. It belongs to the Bills of Material (BOM) product family and is registered in the ETRM (E-Business Suite Technical Reference Manual) with a status of VALID in the APPS schema. Its purpose is to expose revision-level attributes for inventory items in a denormalized, prefixed form suitable for consumption by the Subledger Accounting (XLA) and Costing (CST) engines, and by downstream reporting and integration layers.

The object is a simple SELECT-based view rather than a materialized view, and its name encodes its lineage: CST (Costing), XLA (Subledger Accounting), INV_ITEM_REVS (inventory item revisions), and REF_V (reference view). Because the column names are aliased with an ITEM_ prefix, the view avoids ambiguity when joined to the broader Costing/XLA reference set, in which columns such as ORGANIZATION_ID and INVENTORY_ITEM_ID recur across many objects. This aliasing convention is characteristic of the reference views that populate the XLA transaction and event data model.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, the view is defined over a single referenced base object: the synonym MTL_ITEM_REVISIONS. The view text is:

The owner is APPS, and the underlying MTL_ITEM_REVISIONS table is the Oracle Inventory base table that stores revision definitions and revision control information for items. The view introduces no filtering, joins, or aggregation; it is a column-renaming projection only. Consequently, all validation, row volume, and data quality characteristics originate in MTL_ITEM_REVISIONS. Access is governed by the standard APPS schema grants and any responsibility- or MOAC-based access controls that apply to the base synonym.

Key Columns

The view exposes six columns, each carrying a specific semantic role:

  • ITEM_INVENTORY_ITEM_ID — The surrogate key of the inventory item. Renamed from INVENTORY_ITEM_ID to disambiguate when combined with other Costing and XLA reference views.
  • ITEM_ORGANIZATION_ID — The inventory organization in which the revision is defined. Renamed from ORGANIZATION_ID.
  • REVISION_ID — The unique identifier of the revision record. This is the column most commonly targeted by searches such as "revision_id" and is the primary join key back to revision-level transaction data.
  • ITEM_REVISION — The revision name (for example, "A", "B", or "C") used by the item, renamed from REVISION.
  • REVISION_LABEL — The descriptive label associated with the revision.
  • REVISION_REASON — The reason code or text explaining why the revision was created or changed.

Common Use Cases and Queries

The view is typically joined to Costing and XLA transaction lines on ITEM_INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID, and REVISION_ID to enrich material transactions and accounting events with revision context. A representative query resolving a revision identifier is:

  • SELECT item_inventory_item_id, item_organization_id, revision_id, item_revision, revision_label, revision_reason FROM apps.cst_xla_inv_item_revs_ref_v WHERE revision_id = :revision_id;

For organization-level reporting of all revisions defined for an item:

  • SELECT revision_id, item_revision, revision_label, revision_reason FROM apps.cst_xla_inv_item_revs_ref_v WHERE item_inventory_item_id = :item_id AND item_organization_id = :org_id ORDER BY item_revision;

Because the view performs no filtering, it is suitable for extraction into staging tables and for reconciliation between Inventory revision definitions and the revision references captured in Costing and XLA transaction data.