531: WHERE wip_entity_id = l_wip_entity_id
532: AND organization_id = l_organization_id
533: AND operation_seq_num = 1;
534:
535: UPDATE wip_eam_direct_items
536: SET operation_seq_num = (SELECT MIN(operation_seq_num)
537: FROM wip_operations
538: WHERE wip_entity_id = l_wip_entity_id
539: AND organization_id = l_organization_id)
629: FROM DUAL
630: WHERE EXISTS
631: (
632: SELECT 1
633: FROM wip_eam_direct_items wedi
634: WHERE wedi.wip_entity_id = l_wip_entity_id
635: AND wedi.organization_id = l_organization_id
636: )
637: OR EXISTS