FIX ORDER PACK RECORDS

fix_pack.sql

insert into 
    order_pickpack (order_id, product_id, container_id, quantity)
select 
    '101813.2886', product_id, container_id, allocated
from
    inventory_history
where
    transaction_id = 9450767;

update order_inventory 
set 
    order_inventory.container_id = (select 
            order_pickpack.container_id
        from
            order_pickpack
        where
            order_pickpack.order_id = '101813.2886'
                and order_pickpack.product_id = order_inventory.product_id)
where
    order_inventory.order_id = '101813.2886';