USP_DATALIST_EVENTSPONSORRECOGINITIONTRANSACTIONS

CREATE procedure dbo.USP_DATALIST_EVENTSPONSORRECOGINITIONTRANSACTIONS
(
  @CONTEXTID uniqueidentifier,
  @TRANSACTIONTYPECODE tinyint = null,
  @NAME nvarchar(210) = null
)
as
    set nocount on;

  select 
    R.ID, 
    CDONOR.ID as DONORCONSTITUENTID, 
    CDONOR.NAME, 
    RS.AMOUNT, 
    R.[DATE], 
    R.TRANSACTIONTYPE, 
    R.LOOKUPID, 
    RPM.PAYMENTMETHOD,
    RS.[TYPE] as REVENUETYPE
  from EVENTSPONSOR ES
  join dbo.EVENT E on ES.EVENTID = E.ID
  join REVENUE R on R.APPEALID = E.APPEALID
    and (R.CONSTITUENTID = ES.CONSTITUENTID or R.CONSTITUENTID = ES.ORGANIZATIONCONSTITUENTID)
  join REVENUESPLIT RS on RS.REVENUEID= R.ID
  left join REVENUEPAYMENTMETHOD RPM on RPM.REVENUEID = R.ID
  left join CONSTITUENT CDONOR on CDONOR.ID = R.CONSTITUENTID    
  where ES.ID = @CONTEXTID
    and (R.TRANSACTIONTYPECODE = @TRANSACTIONTYPECODE or @TRANSACTIONTYPECODE is null)
    and (CDONOR.NAME like '%' + @NAME + '%' or @NAME is null);