USP_DATALIST_REVENUETRIBUTE

create procedure dbo.USP_DATALIST_REVENUETRIBUTE
(
  @REVENUEID uniqueidentifier
)
as
    set nocount on;

    select 
                    REVENUETRIBUTE.ID,
                    TRIBUTE.ID as TRIBUTEID,
                    TRIBUTE.TRIBUTETEXT,
                    TYPE.DESCRIPTION as TRIBUTETYPE,
                    REVENUETRIBUTE.AMOUNT,
                    coalesce(REVENUETRIBUTE.AMOUNT + RTTCA.TAXCLAIMAMOUNT, REVENUETRIBUTE.AMOUNT) as GROSSAMOUNT,
                    REVENUETRIBUTE.BASECURRENCYID,
          REVENUETRIBUTE.ISTRIBUTEANONYMOUS
                    from 
                        dbo.REVENUETRIBUTE
          inner join dbo.REVENUE on REVENUE.ID = REVENUETRIBUTE.REVENUEID
                    inner join dbo.TRIBUTE on REVENUETRIBUTE.TRIBUTEID = TRIBUTE.ID
                    inner join dbo.TRIBUTETYPECODE TYPE on TRIBUTE.TRIBUTETYPECODEID = TYPE.ID
                    left join dbo.REVENUETRIBUTETAXCLAIMAMOUNT RTTCA on REVENUETRIBUTE.ID = RTTCA.ID
                    where 
                        REVENUETRIBUTE.REVENUEID = @REVENUEID and REVENUE.TRANSACTIONTYPECODE in (0,1,2,3);