Declare you variables, and populate them:
DECLARE
 @BULKID    varchar(50) = 5006,
 @BAN   varchar(50) = null,-- '955932237',
 @FROM_DATE  date = NULL,
 @TO_DATE  date = NULL,
 @IMEI    varchar(100) = NULL
Create a temporary...

;WITH myTable AS
(
  SELECT * FROM (VALUES(1001), (1001), (1002), (1002), (1003), (1003), (1004), (1004), (1005), (1005),
    (1006), (1006), (1007), (1007), (1008), (1008), (1009), (1009),...

Your query is equivalent to this:
SELECT *
  FROM myTable
 WHERE Account# = @account#
 UNION
SELECT *
  FROM myTable
 WHERE BulkID = @BulkID
 UNION

Should say: I get all rows for all statuses where  oh.OrderTotal > 0

There's a nice style update statement you can use:
;WITH CTE AS
(
    SELECT ROW_NUMBER() OVER (PARTITION BY kultivar,GroepperingsGroep ORDER BY LaasteOntledingsdatum Asc, Laastesuiker Desc)...

IF OBJECT_ID('tempdb..#table1','U') IS NOT NULL DROP TABLE #table1
SELECT *
INTO #table1
FROM (VALUES
('User1','Accepted',39,5000),
('User1','Cancelled',31,250),
('User1','Completed',4,1200),
('User1','Created',23,9000),
('User1','Declined',43,863),
('User1','Issued',389,145269),
('User1','Underway',1,0),
('User2','Accepted',4,12000),
('User2','Created',187,150000),
('User2','Issued',2,4600),
('User3','Accepted',19,8600),
('User3','Cancelled',6,350),
('User3','Created',22,140000)

Output the results to text, and generate a script:
declare @sSqlTemplate as nvarchar(MAX)=
'declare @AlLChars varchar(100) = ''ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789''
update AgentMaster set MY_COLUMN = (
SELECT RIGHT( LEFT(@AlLChars,ABS(BINARY_CHECKSUM(NEWID())%35) + 1 ),1) + RIGHT(...

https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/
https://sqlquantumleap.com/2018/06/11/changing-the-collation-of-the-instance-and-all-columns-across-all-user-databases-what-could-possibly-go-wrong/

SELECT T.Main,
   IIF(T.Main='N',cus_nm,'') AS JobAccount
  ,*
FROM arrcus_rec
CROSS APPLY(SELECT CASE
   WHEN (
      cus_nm LIKE '%(%'
      AND cus_lkp_nm NOT LIKE '%REG%'