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
Source: Bank Statement Loader Execution Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEBSLERR_XML
DB package: CE_CEBSLERR_XMLP_PKG
Run
CE Bank Statement Loader Execution - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |