362: AND ri.status_type = 5 -- Cancelled
363: AND ri.organization_id = org_id
364: AND ri.change_notice = change_order
365: ) ;
366: -- Insert the cancelled rev operations into eng_revised_operations
367: INSERT INTO ENG_REVISED_OPERATIONS (
368: operation_sequence_id
369: , routing_sequence_id
370: , operation_seq_num
363: AND ri.organization_id = org_id
364: AND ri.change_notice = change_order
365: ) ;
366: -- Insert the cancelled rev operations into eng_revised_operations
367: INSERT INTO ENG_REVISED_OPERATIONS (
368: operation_sequence_id
369: , routing_sequence_id
370: , operation_seq_num
371: , last_update_date