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:
SELECT INVENTORY_ITEM_ID ITEM_INVENTORY_ITEM_ID, ORGANIZATION_ID ITEM_ORGANIZATION_ID, REVISION_ID REVISION_ID, REVISION ITEM_REVISION, REVISION_LABEL REVISION_LABEL, REVISION_REASON REVISION_REASON FROM MTL_ITEM_REVISIONS
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 fromINVENTORY_ITEM_IDto disambiguate when combined with other Costing and XLA reference views.ITEM_ORGANIZATION_ID— The inventory organization in which the revision is defined. Renamed fromORGANIZATION_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 fromREVISION.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.
-
APPS.CST_XLA_INV_ITEM_REVS_REF_V·↳ MTL_ITEM_REVISIONS·Explore BOM module →
-
View for SLA ADR sources from item revisions
APPS.GMF_XLA_ITEM_REVISIONS_V·↳ MTL_ITEM_REVISIONS·Explore GMF module →
-
APPS.CST_XLA_INV_ITEM_REVS_REF_V·↳ MTL_ITEM_REVISIONS·Explore BOM module →
-
Item current revisions
APPS.BOM_ITEM_CURRENT_REV_VIEW·↳ MTL_ITEM_REVISIONS_B·Explore BOM module →
-
View for SLA ADR sources from item revisions
APPS.GMF_XLA_ITEM_REVISIONS_V·↳ MTL_ITEM_REVISIONS·Explore GMF module →
-
Item current revisions
APPS.BOM_ITEM_CURRENT_REV_VIEW·↳ MTL_ITEM_REVISIONS_B·Explore BOM module →
-
Item revisions
-
APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V·↳ ENG_CHANGE_OBJ_RELATIONSHIPS·↳ ENG_CHANGE_ORDER_TYPES·↳ ENG_CHANGE_ORDER_TYPES_TL·Explore ENG module →
-
APPS.ENG_CHANGE_OBJ_RELATIONSHIPS_V·↳ ENG_CHANGE_OBJ_RELATIONSHIPS·↳ ENG_CHANGE_ORDER_TYPES·↳ ENG_CHANGE_ORDER_TYPES_TL·Explore ENG module →
-
View: BOM_IMPL_INQUIRY_V 12.2.2
Item usage information
APPS.BOM_IMPL_INQUIRY_V·↳ BOM_GLOBALS·↳ BOM_SMALL_IMPL_TEMP·↳ FND_GLOBAL·Explore BOM module →
-
View: MTL_ITEM_REVISIONS_VL 12.2.2
Item Revisions multilingual view
APPS.MTL_ITEM_REVISIONS_VL·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·Explore INV module →
-
View: BOM_IMPLOSIONS_V 12.2.2
View for displaying BOM implosions
APPS.BOM_IMPLOSIONS_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_GLOBALS·↳ BOM_SMALL_IMPL_TEMP·Explore BOM module →
-
This table holds the Item data for Mass Update flows
-
View: BOM_PLM_EXPLOSION_TEMP 12.2.2
APPS.BOM_PLM_EXPLOSION_TEMP·↳ BOM_EXPLOSION_TEMP·Explore BOM module →
-
View: BOM_EXPLOSIONS_ALL_V 12.1.1
View over BOM_EXPLOSIONS_ALL Table
APPS.BOM_EXPLOSIONS_ALL_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_COMPONENTS_B·↳ BOM_EXPLODER_PUB·Explore BOM module →
-
Item Revisions interface
-
10SC ONLY
APPS.MTL_ITEM_REVISIONS_ALL_V·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·Explore INV module →
-
10SC ONLY
APPS.MTL_ITEM_REVISIONS_ALL_V·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·Explore INV module →
-
View: BOM_PLM_EXPLOSION_TEMP 12.1.1
APPS.BOM_PLM_EXPLOSION_TEMP·↳ BOM_EXPLOSION_TEMP·Explore BOM module →
-
View: MTL_ITEM_REVISIONS_VL 12.1.1
Item Revisions multilingual view
APPS.MTL_ITEM_REVISIONS_VL·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·Explore INV module →
-
View: BOM_COPY_EXPLOSIONS_V 12.1.1
View for Multi level copy structure
APPS.BOM_COPY_EXPLOSIONS_V·↳ BOM_EXPLODER_PUB·↳ BOM_EXPLOSIONS_ALL·↳ BOM_GLOBALS·Explore BOM module →
-
View: BOM_COPY_EXPLOSIONS_V 12.2.2
View for Multi level copy structure
APPS.BOM_COPY_EXPLOSIONS_V·↳ BOM_EXPLODER_PUB·↳ BOM_EXPLOSIONS_ALL·↳ BOM_GLOBALS·Explore BOM module →
-
View: BOM_IMPL_INQUIRY_V 12.1.1
Item usage information
APPS.BOM_IMPL_INQUIRY_V·↳ BOM_GLOBALS·↳ BOM_SMALL_IMPL_TEMP·↳ FND_GLOBAL·Explore BOM module →
-
Item revisions
-
View: MTL_ITEM_ORG_REV_V 12.1.1
10SC ONLY
APPS.MTL_ITEM_ORG_REV_V·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·↳ MTL_PARAMETERS·Explore INV module →
-
View: MTL_ITEM_ORG_REV_V 12.2.2
10SC ONLY
APPS.MTL_ITEM_ORG_REV_V·↳ MTL_ITEM_REVISIONS_B·↳ MTL_ITEM_REVISIONS_TL·↳ MTL_PARAMETERS·Explore INV module →
-
View: BOM_IMPLOSIONS_V 12.1.1
View for displaying BOM implosions
APPS.BOM_IMPLOSIONS_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_GLOBALS·↳ BOM_SMALL_IMPL_TEMP·Explore BOM module →
-
Item Revisions interface
-
View: BOM_EXPLOSIONS_ALL_V 12.2.2
View over BOM_EXPLOSIONS_ALL Table
APPS.BOM_EXPLOSIONS_ALL_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_COMPONENTS_B·↳ BOM_EXPLODER_PUB·Explore BOM module →
-
This table holds the Item data for Mass Update flows
-
Temporary data for indented bills of material (batch processes)
-
Temporary data for indented bills of material (batch processes)
-
Item Revision Attribute Code to Database Column Mapping
-
Item Revision Attribute Code to Database Column Mapping