APPS.ARP_COLL_IND dependencies on RA_CUSTOMER_TRX_ALL

Line 175: ra_customer_trx_all trx

171: + Get_Adj_For_Tot_Rec_GL(ps.payment_schedule_id,pend_date)
172: )
173: INTO tot_rec
174: FROM ar_payment_schedules_all ps,
175: ra_customer_trx_all trx
176: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
177: AND ps.payment_schedule_id <> -1
178: AND ps.customer_trx_id = trx.customer_trx_id
179: AND trx.set_of_books_id = psob_id

Line 262: ra_customer_trx_all trx

258: Get_Adj_Total_GL(ps.payment_schedule_id,pend_date) +
259: nvl(ps.acctd_amount_due_remaining,0))
260: INTO rem_sales
261: FROM ar_payment_schedules_all ps,
262: ra_customer_trx_all trx
263: WHERE ps.gl_date between pstart_date and pend_date
264: AND ps.class in ('INV','DEP','DM','CB')
265: AND ps.customer_trx_id = trx.customer_trx_id
266: AND trx.set_of_books_id = psob_id