917: routing_sequence_id
918: INTO l_query_op_seq_num ,
919: l_query_effective_date,
920: l_routing_sequence_id
921: FROM BOM_OPERATION_SEQUENCES
922: WHERE operation_sequence_id
923: = l_rev_op_unexp_rec.operation_sequence_id ;
924: EXCEPTION
925: WHEN OTHERS THEN