USP_DATALIST_BBNCTRANSACTIONDOWNLOADEXCEPTION

        CREATE procedure dbo.USP_DATALIST_BBNCTRANSACTIONDOWNLOADEXCEPTION(  
        @BATCHTEMPLATEID uniqueidentifier = null,
        @TRANSACTIONTYPEID varchar(40) = null
        )  
        as
            set nocount on;

          select 
              tex.ID, 
              tex.BBNCTRANID,
            t.TRANSACTIONTYPE,
            tex.BATCHTEMPLATEID,
              dbo.UFN_BATCHTEMPLATE_GETDESCRIPTION(tex.BATCHTEMPLATEID) as TEMPLATENAME, 
              --tex.EXCEPTIONMESSAGE, 

              tex.DATEADDED, 
              dbo.UFN_CLIENTUSER_GETBYID(t.BBNCUserID, 1) as BBNCUSER, 
              --dbo.UFN_BBNC_TRANSACTION_GETDATEADDED(t.ID, t.TransactionType) as TRANSACTIONDATEADDED,

            'bd702a1b-13fe-4f4a-9395-8e5fe559e6db' as ViewFormID,
                  tex.PROCESSORID as TRANSACTIONPROCESSORID
          from 
              dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION tex inner join 
              dbo.Transactions t on tex.BBNCTRANID = t.ID
          where 
            (@TRANSACTIONTYPEID is null or t.TRANSACTIONTYPE = @TRANSACTIONTYPEID) and
            (@BATCHTEMPLATEID is null or tex.BATCHTEMPLATEID = @BATCHTEMPLATEID)