APPS.AR_INVOICE_SQL_FUNC_PUB dependencies on AR_ADJUSTMENTS

Line 181: ar_adjustments adj

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'
185: AND trx.initial_customer_trx_id = p_init_cust_trx_id

Line 236: FROM ar_adjustments

232: +----------------------------------------------------------*/
233:
234: SELECT SUM(Amount)
235: INTO commit_this_invoice
236: FROM ar_adjustments
237: WHERE adjustment_type = 'C'
238: AND ( ((customer_trx_id = p_customer_trx_id )
239: AND (subsequent_trx_id is null))
240: OR subsequent_trx_id = p_customer_trx_id);

Line 302: FROM ar_adjustments

298: BEGIN
299:
300: SELECT SUM(Amount)
301: INTO commit_this_invoice
302: FROM ar_adjustments
303: WHERE adjustment_type = 'C'
304: AND ( ((customer_trx_id = p_customer_trx_id )
305: AND (subsequent_trx_id is null))
306: OR subsequent_trx_id = p_customer_trx_id) ;

Line 353: ar_adjustments adj

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'
357: AND trx.initial_customer_trx_id = p_init_cust_trx_id