USP_DATALIST_R68COMMITEXCEPTION

create procedure dbo.USP_DATALIST_R68COMMITEXCEPTION

AS

select 
    rce.ID,
    rce.[MESSAGE],
    [R68PROCESSCOMMITPARAMETERSID],
    rpc.NAME,
    rce.[REVENUESPLITID],
    ft.CALCULATEDUSERDEFINEDID,
    rce.DATEADDED,
    rce.TYPECODE
from 
    [dbo].[R68PROCESSCOMMITEXCEPTION] rce
left join 
    [dbo].[R68PROCESSCOMMITPARAMETERS] rpc ON rpc.id = rce.R68PROCESSCOMMITPARAMETERSID
left join
    [dbo].[FINANCIALTRANSACTIONLINEITEM] ftli ON ftli.id = rce.REVENUESPLITID
left join
    [dbo].[FINANCIALTRANSACTION] ft ON ft.ID = ftli.FINANCIALTRANSACTIONID