[Home] [Help]
41: select nvl(sum(nvl(amount,0)),0)
42: from ar_adjustments
43: where customer_trx_id in (select customer_trx_id
44: from ra_customer_trx,
45: fv_finance_charge_controls fcc
46: where related_customer_trx_id = v_process_inv_id
47: and cust_trx_type_id in (select cust_trx_type_id
48: from ra_cust_trx_types
49: where type = 'DM')