-- apps_transaction.upHeaderTransactionOwner1StatusOrderIDWithOutletID (PROCEDURE) begin UPDATE header_transaction_owner1 SET StatusOrderID=4 WHERE OutletID = outletID1; end