In a Transaction search if you set the Criteria of Type = Opportunity, you should be able to use the join of Applying Transaction to get SO data in results. I would also add to the Criteria that Applying Transaction Type = Sales Order so you don't get extra data.