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 |