UFN_INSTALLMENT_GETINFO_BULK

CREATE function dbo.UFN_INSTALLMENT_GETINFO_BULK ()
returns table
as
return (
    select I.ID
      ,I.REVENUEID
      ,I.SEQUENCE
      ,I.[DATE]
      ,I.TRANSACTIONAMOUNT
      ,I.AMOUNT
      ,I.ORGANIZATIONAMOUNT
      ,I.TRANSACTIONCURRENCYID
      ,I.BASECURRENCYID
      ,I.BASEEXCHANGERATEID
      ,I.ORGANIZATIONEXCHANGERATEID
      ,I.DATEADDED
      ,I.DATECHANGED
      ,I.ADDEDBYID
      ,I.CHANGEDBYID
      ,COALESCE(IP.TRANSACTIONAMOUNT, 0) AMOUNTPAID
      ,COALESCE(IWO.TRANSACTIONAMOUNT, 0) AMOUNTWRITTENOFF
      ,COALESCE(IP.[COUNT], 0) PAYMENTCOUNT
      ,COALESCE(IWO.[COUNT], 0) WRITEOFFCOUNT
      ,I.RECEIPTAMOUNT
    ,I.TRANSACTIONRECEIPTAMOUNT
    ,I.ORGANIZATIONRECEIPTAMOUNT
    from dbo.INSTALLMENT I
    left join (
      select INSTALLMENTID
        ,SUM(AMOUNT) TRANSACTIONAMOUNT
        ,COUNT(INSTALLMENTID) [COUNT]
      from dbo.INSTALLMENTPAYMENT
      group by INSTALLMENTID
      ) IP on I.ID = IP.INSTALLMENTID
    left join (
      select INSTALLMENTID
        ,SUM(TRANSACTIONAMOUNT) TRANSACTIONAMOUNT
        ,COUNT(INSTALLMENTID) [COUNT]
      from dbo.INSTALLMENTWRITEOFF
      group by INSTALLMENTID
      ) IWO on I.ID = IWO.INSTALLMENTID
    )