Why are you inserting into a table variable and then selecting from it instead of doing the select directly as you do with your original query?
Sean, I can't see why you say that it's Oracle. The queries look like SQL Server and I suppose Luka is using user defined data types.