2165: ) ;
2166:
2167: -- Delete operation resources of all pending revised items on ECO
2168:
2169: DELETE FROM BOM_OPERATION_RESOURCES bor
2170: WHERE EXISTS (SELECT NULL
2171: FROM BOM_OPERATION_SEQUENCES bos
2172: , ENG_REVISED_ITEMS ri
2173: WHERE bor.operation_sequence_id = bos.operation_sequence_id