Search Results calculated_elapsed_time




Overview
Explore in AI Chat

Overview

The APPS.BOMBV_FLOW_ROUTING_EVENTS view is a Bills of Material (BOM) reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes routing event (operation sequence) information for flow manufacturing environments, presenting calculated and user-entered operation times, yields, and effectivity data in a flattened, business-friendly format. The view is flagged in ETRM as "Retrofitted," meaning it was carried forward to preserve backward compatibility for existing reports, concurrent programs, and integrations that reference it. Its primary role is to serve as a read-only data source for reporting and integration, not for transactional data entry.

Underlying Base Objects

BOMBV_FLOW_ROUTING_EVENTS is defined over five documented synonyms, each resolving to an underlying application table:

These are joined on ORGANIZATION_ID and, for the item, on INVENTORY_ITEM_ID. The view also embeds Oracle Forms-style flexfield and lookup references (for example, _KF:INV:MSTK:SY for routing item name and _LA:EV.COUNT_POINT_TYPE:MFG_LOOKUPS...), plus a security predicate _SEC:OP.ORGANIZATION_ID that enforces organization-level access control at runtime.

Key Columns

Common Use Cases and Queries

The view supports reporting on flow routing operation times, comparing user-entered versus system-calculated labor, machine, and elapsed times, and auditing effectivity and yield data by organization. A typical query retrieving entered labor time is:

SELECT organization_code, sequence_number, description, entered_labor_time, calculated_labor_time, operation_yield, start_effective_date, end_effective_date FROM apps.bombv_flow_routing_events WHERE organization_code = :org AND entered_labor_time IS NOT NULL ORDER BY sequence_number;

Additional scenarios include reconciling entered versus calculated times across departments, and joining operation identifiers (OPERATION_SEQUENCE_ID, DEPARTMENT_ID) to downstream costing or capacity reports. Because the view enforces the organization security predicate, results are automatically filtered to the organizations the querying user is authorized to access.