CE Bank Statement Loader Execution - draft

Description

Categories
BI Publisher
Application
Cash Management
Source
Bank Statement Loader Execution Report (XML) - Not Supported: Reserved For Future Use
Short Name
CEBSLERR_XML
DB package
CE_CEBSLERR_XMLP_PKG

SQL 5 lines

SELECT e.rec_no , lu.meaning meaning1, e.message_text message_text1, e.bank_account_num bank_account_num2, e.statement_number statement_number2
FROM CE_SQLLDR_ERRORS e, CE_LOOKUPS lu
WHERE  e.rec_no <> 0 AND e.bank_account_num = :bank_account_num AND e.statement_number = :statement_number AND (lu.lookup_type = 'ERROR_STATUS' AND lu.lookup_code = e.status)
ORDER BY	lu.meaning, e.rec_no