Join AP payments (AP_CHECKS_ALL) with Bank statements (CE_STATEMENT_LINES)
I'm working on the financial module of ERP Cloud via BI publisher.
In a report I need to cross Bank statement informations with AP payment information.
More precisely, I need to join CE_STATEMENT_LINES and CE_RECON_HISTORY to AP_CHECKS_ALL.
I tried to use the "CHECK_NUMBER" attribute which is present in both AP_CHECK_ALL and CE_STATEMENT_LINES but it's not filled in in CE_STATEMENT_LINES.
Does someone has any idea on how to join those tables ?