302: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
303: ard.activity_bucket activity_bucket,
304: ard.ref_account_class ref_account_class,
305: ard.ref_customer_trx_line_id ref_customer_trx_line_id
306: from ar_distributions_all ard
307: WHERE ard.source_table = 'RA'
308: AND ard.source_id IN
309: (select receivable_application_id
310: from ar_receivable_applications_all
402: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
403: ard.activity_bucket activity_bucket,
404: ard.ref_account_class ref_account_class,
405: ard.ref_customer_trx_line_id ref_customer_trx_line_id
406: from ar_distributions_all ard
407: WHERE ard.source_table = 'RA'
408: AND ard.source_id IN
409: (select receivable_application_id
410: from ar_receivable_applications_all
496: (select SUM(NVL(ard.amount_cr,0) - NVL(ard.amount_dr,0)) amt,
497: ard.activity_bucket activity_bucket,
498: ard.ref_account_class ref_account_class,
499: ard.ref_customer_trx_line_id ref_customer_trx_line_id
500: from ar_distributions_all ard
501: WHERE ard.source_table = 'RA'
502: AND ard.source_id IN
503: (select receivable_application_id
504: from ar_receivable_applications_all