USP_DATALIST_FENXT_SYNCHRONIZEEXCEPTIONS

CREATE procedure dbo.USP_DATALIST_FENXT_SYNCHRONIZEEXCEPTIONS
(
    @BUSINESSPROCESSSTATUSID uniqueidentifier
)
as
    set nocount on;
    select
        FENXTSYNCPROCESSEXCEPTIONS.ID,
        PDACCOUNTSYSTEM.NAME as ACCOUNTSYSTEMNAME,
        FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPE as OBJECTTYPE,
        case
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 1 then FENXTACCOUNT.ACCOUNTNUMBER
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 2 then FENXTPROJECT.UIPROJECTID
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 3 then ''
                end as RECORDVALUE,
        case
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 1 then FENXTACCOUNT.DESCRIPTION
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 2 then FENXTPROJECT.DESCRIPTION
                when FENXTSYNCPROCESSEXCEPTIONS.SYNCOPERATIONTYPECODE = 3 then ''
                end as DESCRIPTION,
        FENXTSYNCPROCESSEXCEPTIONS.RAISERRORID as ERRORMESSAGE
    from dbo.FENXTSYNCPROCESSEXCEPTIONS
        join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.ID = FENXTSYNCPROCESSEXCEPTIONS.PDACCOUNTSYSTEMID
        left join dbo.FENXTACCOUNT on FENXTSYNCPROCESSEXCEPTIONS.EXCEPTIONRECORDID = FENXTACCOUNT.ID
        left join dbo.FENXTPROJECT on FENXTSYNCPROCESSEXCEPTIONS.EXCEPTIONRECORDID = FENXTPROJECT.ID
            where FENXTSYNCPROCESSEXCEPTIONS.BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID;