176:
177: SELECT NVL(SUM(adj.amount),0)
178: INTO commit_adjustments
179: FROM ra_customer_trx trx,
180: ra_cust_trx_types type,
181: ar_adjustments adj
182: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
183: AND type.type in ('INV', 'CM')
184: AND trx.complete_flag ='Y'
193:
194: SELECT NVL(SUM(line.extended_amount),0)
195: INTO commit_total_activity
196: FROM ra_customer_trx trx,
197: ra_cust_trx_types type,
198: ra_customer_trx_lines line
199: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
200: AND trx.customer_trx_id = line.customer_trx_id
201: AND type.type = 'CM'
348:
349: SELECT NVL(SUM(adj.amount),0)
350: INTO commit_adjustments
351: FROM ra_customer_trx trx,
352: ra_cust_trx_types type,
353: ar_adjustments adj
354: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
355: AND type.type in ('INV', 'CM')
356: AND trx.complete_flag ='Y'
365:
366: SELECT NVL(SUM(line.extended_amount),0)
367: INTO commit_total_activity
368: FROM ra_customer_trx trx,
369: ra_cust_trx_types type,
370: ra_customer_trx_lines line
371: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
372: AND trx.customer_trx_id = line.customer_trx_id
373: AND type.type = 'CM'