Search Results start_effectivity_date




Overview
Explore in AI Chat

Overview

The APPS.BOMBV_BOM_REVISIONS view is a read-only, Business Intelligence (BOMBV) integration object shipped with the Oracle Bills of Material module. It presents item revision and change-order effectivity information in a denormalized, human-readable form intended for reporting, extraction, and downstream integration rather than transactional update. In Oracle EBS 12.1.1 and 12.2.2 the view is flagged as VALID and is documented under the BOM - Bills of Material product line; the ETRM metadata labels it as "Retrofitted," reflecting its migration into the standard 12.x schema. Its principal value lies in exposing the effectivity date of each revision—surfaced through the alias START_EFFECTIVITY_DATE—alongside descriptive organization, item, and engineering change order (ECO) attributes. Because it joins organization and item master data, it allows users to report revisions without repeatedly navigating to MTL_ITEM_REVISIONS. The view is defined WITH READ ONLY and enforces an organization security predicate ('_SEC:RV.ORGANIZATION_ID' IS NOT NULL), so results are automatically restricted to the operating units accessible to the querying responsibility.

Underlying Base Objects

The view is defined over four referenced base objects, all accessed through APPS synonyms:

All joins are equijoins on the organization identifier, and the view carries the '_KF:INV:MSTK:SY' key flexfield token for the item name, indicating flexfield-aware item identification. Documented metadata (ETRM 12.2.2) confirms the APPS owner and these four base objects.

Key Columns

Common Use Cases and Queries

Typical usage includes revision effectivity reporting, ECO audit extracts, and feeding external PLM or data-warehouse systems. A representative query returning revisions effective within a date range is:

SELECT organization_code, organization_name, item_revision,
       start_effectivity_date, eco_implementation_date, change_notice
FROM   apps.bombv_bom_revisions
WHERE  start_effectivity_date BETWEEN :p_from AND :p_to
ORDER BY organization_code, start_effectivity_date;

To isolate the latest effective revision for a given item, users filter on inventory_item_id and order by start_effectivity_date descending. Because the security predicate is embedded, no additional organization filtering is required for responsibilities with restricted operating unit access.