Search Results mtl_effectivity_control

Overview

APPS.WIP_FLOW_ASSEMBLIES_V is a Work in Process (WIP) view that serves as the Flow Workstation base view. It presents assemblies that participate in a flow manufacturing routing environment, exposing the item, routing, operation, and control-attribute context required by the Flow Workstation user interface and downstream flow scheduling logic. Rather than storing data, the view is a join-based projection over routing definitions, routing revisions, item master information, and manufacturing lookups, returning one row per eligible line operation node.

Because the view is defined in the APPS schema in Oracle EBS 12.1.1 and 12.2.2, it is accessible to any responsibility or concurrent program with the appropriate grants, and it is a common source for custom reports, Discoverer workbooks, and integration extracts that need to surface the flow assembly structure for a given organization.

Underlying Base Objects

The view is defined over the following referenced objects, as documented in the ETRM 12.2.2 metadata:

• BOM_OPERATIONAL_ROUTINGS (synonym) — supplies the assembly routing header, including the alternate routing designator, line identifier, common routing sequence, and the CFM routing flag.
• BOM_OPERATION_SEQUENCES (synonym) — supplies the operation-level detail, including the standard operation, operation sequence number, and operation type.
• MTL_ROUTING_REV_HIGHDATE_V (view) — supplies the process revision and its effective date for the assembly/organization combination.
• MTL_SYSTEM_ITEMS_KFV (synonym) — supplies the concatenated segment assembly name, primary UOM, description, and the control-attribute codes (lot, serial, effectivity).
• MFG_LOOKUPS (view) — resolved three times to translate the lot control, serial control, and effectivity control codes into their meaningful display values.
• WIP_SFCB_UTILITIES (package) — invoked as LINE_OP_IS_PENDING, a filter that restricts the result set to line operations considered pending for the given routing sequence, item, organization, and alternate routing.

The assembly join is anchored on INVENTORY_ITEM_ID plus ORGANIZATION_ID across the item, routing, and revision sources; the routing header is tied to its operation sequences through ROUTING_SEQUENCE_ID. Only routings with CFM_ROUTING_FLAG = 1 and operations of type 3 (line operation) are returned.

Key Columns

• NODE_LABEL — a composite key built as concatenated segments, alternate routing designator, process revision, and operation sequence number; used to identify the node uniquely in the Flow Workstation.
• ORGANIZATION_ID — the inventory organization owning the assembly.
• ASSEMBLY_NAME — the concatenated item segments, the human-readable assembly identifier.
• INVENTORY_ITEM_ID — the item primary key, also acting as a routing key.
• ALTERNATE_ROUTING_DESIGNATOR and LINE_ID — routing identity attributes; the line identifier is a foreign key to the flow line.
• STANDARD_OPERATION_ID, ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID — foreign and primary keys linking to the standard operation and the operation sequence definition.
• PROCESS_REVISION and EFFECTIVITY_DATE — the revision and truncated effective date of the routing revision in force.
• PRIMARY_UOM_CODE — the assembly's primary unit of measure.
• LOT_CONTROL, SERIAL_CONTROL, EFFECTIVITY_CONTROL — decoded lookup meanings for the item's control attributes. The view filters effectivity control to lookup code 1, so only effectivity-controlled items are surfaced by that predicate.
• DESCRIPTION — the item description, and NODE_TYPE — a constant value of 1 identifying the node classification.

Common Use Cases and Queries

Typical uses include building flow assembly pick lists, driving Flow Workstation navigation, and auditing which line operations remain pending. The lot control attribute is frequently queried in traceability and lot-routing reports. A representative query listing pending flow line operations with their control attributes is:

• SELECT node_label, assembly_name, operation_sequence_id, process_revision, lot_control, serial_control FROM wip_flow_assemblies_v WHERE organization_id = :org_id ORDER BY assembly_name, operation_sequence_id;
• SELECT assembly_name, inventory_item_id, alternate_routing_designator, process_revision FROM wip_flow_assemblies_v WHERE organization_id = :org_id AND lot_control = 'Full Control';
• SELECT COUNT(*), assembly_name FROM wip_flow_assemblies_v WHERE organization_id = :org_id GROUP BY assembly_name;

Because pending-operation filtering is delegated to WIP_SFCB_UTILITIES.LINE_OP_IS_PENDING, queries against this view can be moderately expensive; restricting by ORGANIZATION_ID and assembly is recommended where the result set is large.