Build views to join PAY/CAS - AR Invoices - Online Banking / PAD / Routing Slips

[seeker25]

select ir.invoice_number, i.id, total, invoice_status_code, payment_method_code, art.txn_amount as cas_total from invoices i join invoice_references ir on i.id = ir.invoice_id join cas.ar_transactions art on art.txn_number = ir.invoice_number where payment_method_code in ('PAD', 'ONLINE_BANKING', 'INTERNAL') and total > 0 and art.txn_type = 'BC_REGISTRIES';