UPDATE_INDOCOM_640

UPDATE sl_so_balance_invoice Z
        SET flg_invoice_temp = 'N', invoice_id = -99
    FROM sl_do_item B
    WHERE B.do_item_id = Z.ref_item_id
        AND Z.flg_invoice_temp NOT IN ('N', 'V')
        AND B.ref_id in (
            select so_item_id from sl_so_item where so_id = 12297
        )
        AND Z.flg_invoice NOT IN ('Y', 'V')
        AND do_receipt_item_id = -99