522: );
523:
524: END IF;
525:
526: UPDATE wip_requirement_operations
527: SET operation_seq_num = (SELECT MIN(operation_seq_num)
528: FROM wip_operations
529: WHERE wip_entity_id = l_wip_entity_id
530: AND organization_id = l_organization_id)
636: )
637: OR EXISTS
638: (
639: SELECT 1
640: FROM wip_requirement_operations wro, mtl_system_items_b msi
641: WHERE wro.wip_entity_id = l_wip_entity_id
642: AND wro.organization_id = l_organization_id
643: AND wro.inventory_item_id = msi.inventory_item_id
644: AND wro.organization_id = msi.organization_id