APPS.AR_IDEP_UTILS dependencies on AR_ADJUSTMENTS_ALL

Line 150: ar_adjustments_all adj

146: SELECT ( NVL(SUM( ADJ.AMOUNT),0) * -1)
147: INTO l_invoiced_amount
148: FROM ra_customer_trx_all trx,
149: ra_cust_trx_types_all type,
150: ar_adjustments_all adj
151: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
152: AND trx.org_id = type.org_id
153: AND trx.initial_customer_trx_id = p_customer_trx_id
154: AND trx.complete_flag = 'Y'

Line 197: FROM ar_adjustments_all

193: +------------------------------------------------------------*/
194:
195: SELECT NVL( SUM( amount ), 0)
196: INTO l_credit_memo_amount
197: FROM ar_adjustments_all
198: WHERE customer_trx_id = p_customer_trx_id
199: AND adjustment_type <> 'C';
200:
201: END IF; -- end Guarantee case