1738: ) ;
1739:
1740: -- Delete operation resources of all pending revised items on ECO
1741:
1742: DELETE FROM BOM_OPERATION_RESOURCES bor
1743: WHERE EXISTS (SELECT NULL
1744: FROM BOM_OPERATION_SEQUENCES bos
1745: , ENG_REVISED_ITEMS ri
1746: WHERE bor.operation_sequence_id = bos.operation_sequence_id