SQL for sub-ledger to Cash Management Tables

Content

Hi,

 

 

I am trying to develop a report that will give me detail from the cash management CE_ tables joined to the GL subledger tables ( xla_ae_lines, xla_ae_headers, GL_IMPORT_REFERENCES ), I have joins from the receipts source relating to cash management, but I am looking for joins where the source is 'Cash Management', anyone help with any pointers on joins.

I found something joins via ce_statement_reconciliations (to join to ce_statement_headers / ce_statement_lines) but in the case in question the table is entirely unpopulated, so this will not work for me.