480: );
481:
482: END IF;
483:
484: UPDATE wip_requirement_operations
485: SET operation_seq_num = (SELECT MIN(operation_seq_num)
486: FROM wip_operations
487: WHERE wip_entity_id = l_wip_entity_id
488: AND organization_id = l_organization_id)
591: )
592: OR EXISTS
593: (
594: SELECT 1
595: FROM wip_requirement_operations wro, mtl_system_items_b msi
596: WHERE wro.wip_entity_id = l_wip_entity_id
597: AND wro.organization_id = l_organization_id
598: AND wro.inventory_item_id = msi.inventory_item_id
599: AND wro.organization_id = msi.organization_id