USP_DATALIST_R68COMMITEXCEPTIONDETAIL

create procedure dbo.USP_DATALIST_R68COMMITEXCEPTIONDETAIL
(
    @ID uniqueidentifier
)
as
    set nocount on;

select 
    rce.ID,
    rce.FULLMESSAGE,
    rpc.NAME,
    ft.CALCULATEDUSERDEFINEDID,
    rce.DATEADDED,
    ftli.FINANCIALTRANSACTIONID,
    rce.REVENUESPLITID,
    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
where
    rce.ID = @ID