[Home] [Help]
471: -- Flow ER 14595064
472: if p_create_flow_schedule = 2 then
473: sql_stmt := sql_stmt ||
474: 'and not exists (select ''1'' '||
475: 'from bom_operational_routings bor ' ||
476: 'where bor.assembly_item_id = oel.inventory_item_id '||
477: 'and bor.organization_id = oel.ship_from_org_id ' ||
478: 'and bor.alternate_routing_designator is NULL '||
479: 'and nvl(bor.cfm_routing_flag, 2) = 1) ' ;
1146: -- Checking whether the routings are flow or discrete.
1147: select NVL(cfm_routing_flag,2)
1148: into l_supply_type
1149: from oe_order_lines_all oel,
1150: bom_operational_routings bor
1151: where oel.line_id = to_number(WorkOrder_Rec.line_id)
1152: and oel.inventory_item_id = bor.assembly_item_id (+)
1153: and oel.ship_from_org_id = bor.organization_id (+)
1154: and bor.alternate_routing_designator (+) is NULL;