select sum(stotal) from Numeracion_remesa nr, sucursal s where nr.scve_sucursal = S.scve_sucursal and cstatus = 'G'