update <@PREFIX>vm_orders set order_status = (select order_status_code from <@PREFIX>vm_order_status where order_status_id = <@UPDTOCODE@>) where order_id = <@ORDERS_ID@>
