Search Results bombv_flow_routing_processes




Overview
Explore in AI Chat

Overview

BOMBV_FLOW_ROUTING_PROCESSES is an APPS-owned database view within the Oracle E-Business Suite Bills of Material (BOM) module. It is classified as a business view (the "BV" prefix) and is retrofitted into the ETRM (E-Business Suite Technical Reference Manual) for both 12.1.1 and 12.2.2 environments, with a documented status of VALID. The view presents a flattened, reporting-oriented projection of routing operations associated specifically with flow manufacturing processes. It joins routing header and operation-sequence data against organization and item master information to expose process attributes — sequence numbers, alternate routing designators, yield figures, calculated and user-entered time values, and descriptive flexfield prompts — in a single readable result set.

Its principal role is to support inquiry, reporting, and integration scenarios where flow routing process content must be retrieved without navigating the normalized base tables directly. Because it is defined with the READ ONLY clause, it is intended purely for retrieval and cannot participate in DML. The view also embeds reference and lookup encoding conventions (for example _KF, _LA, and _SEC tokens), indicating it was designed as a foundation for Oracle's descriptive flexfield and multi-organization security frameworks.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over five referenced base objects, all resolved through APPS synonyms:

  • BOM_OPERATIONAL_ROUTINGS — routing headers, supplying the alternate routing designator, routing sequence identifier, and the CFM routing flag.
  • BOM_OPERATION_SEQUENCES — the routing operation lines, supplying sequence numbers, effectivity dates, yields, and time values.
  • HR_ALL_ORGANIZATION_UNITS — the organization name associated with the owning organization identifier.
  • MTL_PARAMETERS — organization parameters, providing the organization code join path.
  • MTL_SYSTEM_ITEMS_B — the item master, used to validate the assembly item against the routing.

The join logic links operational routings to operation sequences on COMMON_ROUTING_SEQUENCE_ID, restricts to flow routings with CFM_ROUTING_FLAG = 1, and filters operation lines to OPERATION_TYPE = 2, isolating flow process operations from standard routing operations.

Key Columns

Common Use Cases and Queries

The view is typically queried for flow manufacturing process analysis, routing effectivity reporting, and yield or time-value comparison between calculated and entered figures.

  • Listing all flow processes for a specific organization by filtering on ORGANIZATION_CODE.
  • Comparing calculated versus entered labor and machine times for capacity analysis.
  • Identifying active processes using START_EFFECTIVE_DATE and END_EFFECTIVITY_DATE.

A representative query is:

SELECT ORGANIZATION_CODE, SEQUENCE_NUMBER, ALTERNATE_ROUTING_CODE, DESCRIPTION, OPERATION_YIELD, CALCULATED_ELAPSED_TIME, USER_ELAPSED_TIME FROM APPS.BOMBV_FLOW_ROUTING_PROCESSES WHERE ORGANIZATION_CODE = :org_code ORDER BY SEQUENCE_NUMBER;