a

BEGIN;


create table in_log_product_balance_stock_20211208 as (
SELECT * FROM in_log_product_balance_stock
WHERE doc_type_id =  311
AND ref_id = 95
AND doc_no = 'DO-2111-000001'
AND doc_date ='20211110'
);


DELETE FROM in_log_product_balance_stock
WHERE doc_type_id =  311
AND ref_id = 95
AND doc_no = 'DO-2111-000001'
AND doc_date ='20211110'
--rollback
--commit;