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
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