489: WHERE wip_entity_id = l_wip_entity_id
490: AND organization_id = l_organization_id
491: AND operation_seq_num = 1;
492:
493: UPDATE wip_eam_direct_items
494: SET operation_seq_num = (SELECT MIN(operation_seq_num)
495: FROM wip_operations
496: WHERE wip_entity_id = l_wip_entity_id
497: AND organization_id = l_organization_id)
584: FROM DUAL
585: WHERE EXISTS
586: (
587: SELECT 1
588: FROM wip_eam_direct_items wedi
589: WHERE wedi.wip_entity_id = l_wip_entity_id
590: AND wedi.organization_id = l_organization_id
591: )
592: OR EXISTS