Search Results to_opratn_effectivity_date




Overview
Explore in AI Chat

Overview

APPS.BOMBV_OPERATION_NETWORKS is a Business Intelligence System view in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2) that presents the network of manufacturing operations and the sequence in which those operations must be performed to build a product. It exposes operation-to-operation relationships defined within Oracle Bills of Material and Routing, allowing the logical flow of a routing to be queried as a set of directed links rather than as a flat sequence list. Because it is a view, it delivers read-only, denormalized access to routing network data without exposing the consumer to the underlying normalized tables, and it is primarily used for reporting, integration extracts, and analytical queries against routing structures.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects, all resolved through synonyms: BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_NETWORKS, BOM_OPERATION_SEQUENCES, HR_ALL_ORGANIZATION_UNITS, MTL_PARAMETERS, and MTL_SYSTEM_ITEMS_B. BOM_OPERATION_NETWORKS supplies the operation-to-operation linkage records that constitute the network, BOM_OPERATION_SEQUENCES provides the individual operation sequence details, and BOM_OPERATIONAL_ROUTINGS supplies routing header context. HR_ALL_ORGANIZATION_UNITS and MTL_PARAMETERS resolve organization identifiers into codes and names, while MTL_SYSTEM_ITEMS_B supports item identification used by the key flexfield roles in the view. Its FND design data reference is BOM.BOMBV_OPERATION_NETWORKS.

Key Columns

The view exposes identifiers and descriptive attributes on both the "from" and "to" sides of each network connection, which is central to interpreting routing flow:

Common Use Cases and Queries

Typical use cases include generating routing network reports, validating network definitions across organizations, and feeding downstream planning or MES integrations. The alternate routing columns support isolating links by alternate routing code.

To list all network links for a given source alternate routing code:

SELECT FROM_ALTERNATE_ROUTING_CODE,
       TO_ALTERNATE_ROUTING_CODE,
       FROM_OPERATION_SEQ_NUM,
       TO_OPERATION_SEQ_NUM,
       CONNECTION_TYPE,
       PLANNING_PERCENT
FROM   APPS.BOMBV_OPERATION_NETWORKS
WHERE  FROM_ALTERNATE_ROUTING_CODE = :from_alternate_routing_code;

To report network connections with organization context:

SELECT FROM_ORGANIZATION_CODE,
       TO_ORGANIZATION_CODE,
       FROM_OPERATION_SEQ_NUM,
       TO_OPERATION_SEQ_NUM,
       START_EFFECTIVITY_DATE,
       END_EFFECTIVITY_DATE
FROM   APPS.BOMBV_OPERATION_NETWORKS
WHERE  TRUNC(SYSDATE) BETWEEN START_EFFECTIVITY_DATE AND NVL(END_EFFECTIVITY_DATE, SYSDATE);