CM: Fetch Invoices related Reconciliation Per Currency

SELECT DISTINCT cel.*

FROM   CE_STATEMENT_LINES cel,

       CE_STATEMENT_HEADERS ceh,

       CE_STATEMENT_RECONCILS_ALL csr,

       AP_INVOICE_PAYMENTS_ALL aip,

       AP_CHECKS_ALL ac

WHERE cel.statement_header_id   = ceh.statement_header_id

AND   ac.check_id               = aip.check_id

AND   aip.invoice_id            = '166014'

AND   aip.check_id              = ac.check_id

AND   ac.bank_account_id        = ceh.bank_account_id

AND   TO_CHAR(ac.check_number)  = cel.bank_trx_number

AND   csr.statement_line_id     = cel.statement_line_id;