45: FROM
46: wip_flow_schedules wfs,
47: mtl_system_items_kfv msik,
48: mtl_sales_orders_kfv mso,
49: mtl_parameters mp,
50: wip_lines wl,
51: wip_schedule_groups wsg
52: WHERE
53: wfs.organization_id = orgID
113: bom_operation_sequences bos2,
114: bom_operational_routings bor,
115: bom_departments bd,
116: bom_standard_operations bso,
117: mtl_parameters mp
118: WHERE bor.organization_id = wfs.organization_id
119: and bor.assembly_item_id = wfs.primary_item_id
120: and bor.line_id = wfs.line_id
121: and bor.cfm_routing_flag = 1