4737: sum(Nvl(rcv_lines.tax_discount,0)) tax_disc,
4738: sum(NVl(rcv_lines.freight_discount,0)) frt_disc,
4739: sum(Nvl(rcv_lines.allocated_receipt_amount,0)) allocated
4740: from ar_Activity_details rcv_lines,
4741: ra_customer_trx_lines_all trx_lines
4742: where trx_lines.customer_trx_id = pf_ct_id
4743: and rcv_lines.cash_receipt_id = pf_cr_id
4744: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111
4745: and trx_lines.line_type in ('FREIGHT','CHARGES')