'SO-22/03806','SO-22/03807','SO-22/03808','SO-22/03809','SO-22/03810','SO-22/03811','SO-22/03812','SO-22/03813','SO-22/03814','SO-22/03815','SO-22/03816','SO-22/03817','SO-22/03818','SO-22/03819','SO-22/03820','SO-22/03821','SO-22/03822','SO-22/03823','SO-22/03824','SO-22/03825','SO-22/03826','SO-22/03827','SO-22/03828','SO-22/03829','SO-22/03830','SO-22/03831','SO-22/03832','SO-22/03833','SO-22/03834','SO-22/03835','SO-22/03836','SO-22/03837','SO-22/03838','SO-22/03839','SO-22/03840','SO-22/03841','SO-22/03842','SO-22/03843','SO-22/03844','SO-22/03845','SO-22/03846','SO-22/03847','SO-22/03848','SO-22/03849','SO-22/03850','SO-22/03851','SO-22/03852','SO-22/03853','SO-22/03854','SO-22/03855','SO-22/03856','SO-22/03857','SO-22/03858','SO-22/03859','SO-22/03860','SO-22/03861','SO-22/03862','SO-22/03863','SO-22/03864','SO-22/03865','SO-22/03866','SO-22/03867','SO-22/03868','SO-22/03869','SO-22/03870','SO-22/03871','SO-22/03872','SO-22/03873','SO-22/03874','SO-22/03875','SO-22/03876','SO-22/03877','SO-22/03878','SO-22/03879','SO-22/03880'




delete d from 0p4_sale_order_detail d 
left join 0p4_sale_order s on s.sale_order_id=d.sale_order_id where  s.sale_order_no in('SO-22/03806','SO-22/03807','SO-22/03808','SO-22/03809','SO-22/03810','SO-22/03811','SO-22/03812','SO-22/03813','SO-22/03814','SO-22/03815','SO-22/03816','SO-22/03817','SO-22/03818','SO-22/03819','SO-22/03820','SO-22/03821','SO-22/03822','SO-22/03823','SO-22/03824','SO-22/03825','SO-22/03826','SO-22/03827','SO-22/03828','SO-22/03829','SO-22/03830','SO-22/03831','SO-22/03832','SO-22/03833','SO-22/03834','SO-22/03835','SO-22/03836','SO-22/03837','SO-22/03838','SO-22/03839','SO-22/03840','SO-22/03841','SO-22/03842','SO-22/03843','SO-22/03844','SO-22/03845','SO-22/03846','SO-22/03847','SO-22/03848','SO-22/03849','SO-22/03850','SO-22/03851','SO-22/03852','SO-22/03853','SO-22/03854','SO-22/03855','SO-22/03856','SO-22/03857','SO-22/03858','SO-22/03859','SO-22/03860','SO-22/03861','SO-22/03862','SO-22/03863','SO-22/03864','SO-22/03865','SO-22/03866','SO-22/03867','SO-22/03868','SO-22/03869','SO-22/03870','SO-22/03871','SO-22/03872','SO-22/03873','SO-22/03874','SO-22/03875','SO-22/03876','SO-22/03877','SO-22/03878','SO-22/03879','SO-22/03880');


delete s from 0p4_sale_order s where s.sale_order_no in('SO-22/03806','SO-22/03807','SO-22/03808','SO-22/03809','SO-22/03810','SO-22/03811','SO-22/03812','SO-22/03813','SO-22/03814','SO-22/03815','SO-22/03816','SO-22/03817','SO-22/03818','SO-22/03819','SO-22/03820','SO-22/03821','SO-22/03822','SO-22/03823','SO-22/03824','SO-22/03825','SO-22/03826','SO-22/03827','SO-22/03828','SO-22/03829','SO-22/03830','SO-22/03831','SO-22/03832','SO-22/03833','SO-22/03834','SO-22/03835','SO-22/03836','SO-22/03837','SO-22/03838','SO-22/03839','SO-22/03840','SO-22/03841','SO-22/03842','SO-22/03843','SO-22/03844','SO-22/03845','SO-22/03846','SO-22/03847','SO-22/03848','SO-22/03849','SO-22/03850','SO-22/03851','SO-22/03852','SO-22/03853','SO-22/03854','SO-22/03855','SO-22/03856','SO-22/03857','SO-22/03858','SO-22/03859','SO-22/03860','SO-22/03861','SO-22/03862','SO-22/03863','SO-22/03864','SO-22/03865','SO-22/03866','SO-22/03867','SO-22/03868','SO-22/03869','SO-22/03870','SO-22/03871','SO-22/03872','SO-22/03873','SO-22/03874','SO-22/03875','SO-22/03876','SO-22/03877','SO-22/03878','SO-22/03879','SO-22/03880');