XTR Intercompany - Letters

select sum(a.balance_out)        BAL_OUT,
       max(a.transaction_number) T_NUM,
       a.currency                CCY
from XTR_INTERGROUP_TRANSFERS_V a
 where a.party_code = :PTY_CODE
 and   a.transfer_date||to_char(a.transaction_number) =
         (select max(b.transfer_date)||max(to_char(b.transaction_number))
           from XTR_INTERGROUP_TRANSFERS_V b
           where b.transfer_date <= :P_TO
		   and b.PARTY_CODE = :PTY_CODE)
		   group by a.party_code,a.currency