Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
2.7 kB
2
Indexable
Never
 update account_move_line set date = '2021-07-24 07:00:00', date_maturity = '2021-07-24 07:00:00' where move_id in (select pos.stock_move_id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

 update account_move set date = '2021-07-24 07:00:00' where id in (select pos.stock_move_id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update stock_move_line set date = '2021-07-24 07:00:00' where picking_id in (select pos.picking_id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update stock_move set date = '2021-07-24 07:00:00', date_expected = '2021-07-24 07:00:00' where picking_id in (select pos.picking_id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update stock_picking set date = '2021-07-24 07:00:00', date_done = '2021-07-24 07:00:00', scheduled_date = '2021-07-24 07:00:00' where id in (select pos.picking_id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update account_move_line set date = '2021-07-24 07:00:00' , date_maturity = '2021-07-24 07:00:00' where move_id in (select move_id from account_move_line where statement_id in (select statement_id from account_bank_statement_line where pos_statement_id in (select pos.id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337 )));

update account_move set date = '2021-07-24 07:00:00' where id in (select move_id from account_move_line where statement_id in (select statement_id from account_bank_statement_line where pos_statement_id in (select pos.id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337)));

update account_move set date = '2021-07-24 07:00:00' where id in (select pos.account_move from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update account_move_line set date = '2021-07-24 07:00:00', date_maturity = '2021-07-24 07:00:00' where move_id in (select pos.account_move from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337);

update account_bank_statement set date = '2021-07-24 07:00:00' where id in (select statement_id from account_bank_statement_line where pos_statement_id in (select pos.id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337));

update account_bank_statement_line set date = '2021-07-24 07:00:00' where id in (select id from account_bank_statement_line where pos_statement_id in (select pos.id from pos_order pos inner join res_users ru on ru.id = pos.user_id where pos.id = 1875337));

commit;