SELECT
    cr.receipt_number,
    cr.receipt_date,
    substrb(party.party_name,1,50),
    cust.account_number,
    cr.amount,
    SUM( (to_number(app.amount_applied) ) )
FROM
    ar.ar_cash_receipts_all cr,
    ar.ar_collectors collector_name,
    ar.ar_receivable_applications_all app,
    ar.ar_payment_schedules_all ps_inv,
    ar.hz_cust_accounts cust,
    ar.hz_parties party,
    ar.ra_customer_trx_all ct,
    ar.ra_cust_trx_types_all ctt,
    ar.ra_customer_trx_lines_all ctl,
    ar.ra_batch_sources_all bs,
    ar.hz_cust_site_uses_all su,
    ar.ar_cons_inv_all ci,
    apps.ar_lookups l_class,
    ar.ar_receipt_methods rm,
    ar.ar_receivables_trx_all art,
    ar.hz_customer_profiles prof
WHERE
    (
        (
            (
                cust.account_number IN (
                    '01102.0123UT'
                )
                OR    cust.account_number IN (
                    '03251.08019S'
                )
                OR    cust.account_number IN (
                    '04221.0K035M'
            )
        )
    )
    AND   app.cash_receipt_id = cr.cash_receipt_id (+)
    AND   ct.customer_trx_id (+) = ps_inv.customer_trx_id
    AND   ctt.cust_trx_type_id (+) = ps_inv.cust_trx_type_id
    AND   cust.cust_account_id (+) = ps_inv.customer_id
    AND   bs.batch_source_id (+) = ct.batch_source_id
    AND   cust.party_id = party.party_id (+)
    AND   su.site_use_id (+) = ps_inv.customer_site_use_id
    AND   ctl.customer_trx_line_id (+) = app.applied_customer_trx_line_id
    AND   ps_inv.class = l_class.lookup_code
    AND   cr.receipt_method_id = rm.receipt_method_id (+)
    AND   l_class.lookup_type = 'INV/CM'
    AND   ci.cons_inv_id (+) = ps_inv.cons_inv_id
    AND   app.applied_payment_schedule_id (+) = ps_inv.payment_schedule_id
    AND   su.site_use_id = prof.site_use_id (+)
    AND   prof.collector_id = collector_name.collector_id (+)
    AND   art.receivables_trx_id (+) = app.receivables_trx_id
GROUP BY
    cr.receipt_number,
    cr.receipt_date,
    substrb(party.party_name,1,50),
    cust.account_number,
    cr.amount
HAVING ( ( SUM( (to_number(app.amount_applied) ) ) ) <> 0 );