aaasasdafdisov nscjo

begin;
CREATE TABLE m_sell_price_product_20220329 AS(
        SELECT distinct A.*
        FROM m_sell_price_product A
        INNER JOIN m_product B ON A.product_id = B.product_id
        INNER JOIN m_ou_structure C ON A.ou_id = A.ou_id AND f_get_ou_code(C.ou_bu_id) = 'ACHSADA'
        WHERE B.active = 'Y' AND A.active = 'Y'
        AND tax_id <> -99
        AND '20220331' BETWEEN A.date_from AND A.date_to
        Order by A.product_id
);

UPDATE m_sell_price_product A
SET date_to = '20220331',
VERSION = A.version+1,
update_datetime = to_char(NOW(), 'YYYYMMDDHH24MIss'),
update_user_id  = -1
FROM m_sell_price_product_20220329 B
WHERE A.tenant_id = B.tenant_id
AND A.sell_price_product_id = B.sell_price_product_id;

INSERT INTO m_sell_price_product(tenant_id,ou_id,product_id,date_from,date_to,curr_code,gross_sell_price,
                                                                flg_tax_amount,tax_id,tax_amount,sell_price,min_sell_price,create_datetime,
                                                                create_user_id,update_datetime,update_user_id,version,active,active_datetime,non_active_datetime)
SELECT A.tenant_id,A.ou_id,A.product_id,'20220401','30001231',A.curr_code,A.gross_sell_price,
                                                                A.flg_tax_amount,B.tax_id,A.tax_amount,A.sell_price,A.min_sell_price,to_char(NOW(), 'YYYYMMDDHH24MIss'),
                                                                -1,to_char(NOW(), 'YYYYMMDDHH24MIss'),-1,0,'Y',to_char(NOW(), 'YYYYMMDDHH24MIss'),''
FROM m_sell_price_product_20220329 A
INNER JOIN m_tax B ON B.tax_code = 'PPN11%'
WHERE A.tenant_id = B.tenant_id;
--rollback