DBA Data[Home] [Help]

APPS.AR_IDEP_UTILS dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 171: ra_customer_trx_lines_all line

167: --
168: SELECT NVL(SUM(-1 * line.extended_amount),0)
169: INTO l_credit_memo_amount
170: FROM ra_customer_trx_all trx,
171: ra_customer_trx_lines_all line
172: WHERE trx.customer_trx_id = line.customer_trx_id
173: AND trx.org_id = line.org_id
174: AND trx.previous_customer_trx_id = p_customer_trx_id
175: AND trx.complete_flag = 'Y';