Something like this:

SELECT top 250000

x1.wo_ref AS [z13031322175522447287ca90],

sum(wta.approved_ts_amount) AS [z13031322175522447289ca90]

FROM

dbo.wo AS x1

INNER JOIN dbo.wocc AS x3

ON x1.wo_id = x3.wo_id

CROSS APPLY dbo.woccsr_ts_amt(20, x3.wo_id,x3.cc_id, x3.gl_id) wta(approved_ts_amount)

WHERE

status != 17 and

x1.b_code in ('GOOG')

GROUP BY

x1.wo_ref