Can any one help me in writing this query please

we have order history table where I am trying to get the next row when an order got reprocessed

order history table

1234-2-05-jun-07 11:12:34AM-reporcessed
1234-2-05-jun-07 11:12:34AM-missing part

7723-5-06-jun-07 2:02:59AM - reprocessed
7723-5-06-jun-07 2:02:59AM -wrong part

I am trying to get the row after the reprocess. they will have same orderstage_id and process date

can anyone help me in getting a query