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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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