CREATE PROCEDURE [dbo].[XLedgerTransactionsForUploadFailure]
    @xledgerUploadFailureId int
as
begin
    set nocount on

    select
        XledgerJournalEntryBatchItemId = XLedgerJournalEntryBatchItem.XLedgerJournalEntryBatchItemId,
        TransactionType = AcctTransactions.TransactionType,
        TransactionAmount = AcctTransactions.TransactionAmount,
        ItemCode = AcctTransactions.ItemCode,
        [ItemDescription] = AcctTransactions.ItemDescription,
        SubledgerNumber = case
            when isnull( AcctTransactions.VendorNumber, '' ) != '' then AcctTransactions.VendorNumber
            else AcctTransactions.CustomerNumber
        end,
        SubledgerName = case
            when isnull( AcctTransactions.VendorNumber, '' ) != '' then AcctTransactions.VendorName
            else AcctTransactions.CustomerName
        end
    from XLedgerTransactionUploadFailure
    inner join XLedgerJournalEntryBatchItem on
        XLedgerJournalEntryBatchItem.XLedgerTransactionUploadFailureFid = XLedgerTransactionUploadFailure.XLedgerTransactionUploadFailureId
    inner join AcctTransactions on
        AcctTransactions.ATPriKey = XLedgerJournalEntryBatchItem.AcctTransactionFid
    where XLedgerTransactionUploadFailure.XLedgerTransactionUploadFailureId = @xledgerUploadFailureId and
        XLedgerJournalEntryBatchItem.Resolved = 0
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerTransactionsForUploadFailure] TO [MssExec]
GO