DBA Data[Home] [Help]

APPS.ARP_PROCESS_RETURNS dependencies on AR_PAYMENT_SCHEDULES

Line 127: ar_payment_schedules invps,

123: NVL(SUM(DECODE(adj.adjustment_type, 'C', 0, adj.amount)), 0) /
124: COUNT(DISTINCT invps.payment_schedule_id) adj_amount
125: FROM
126: ra_customer_trx inv,
127: ar_payment_schedules invps,
128: ra_cust_trx_types itt,
129: ra_batch_sources cmbs,
130: ra_customer_trx cm,
131: ar_adjustments adj

Line 402: ar_payment_schedules invps

398: inv.exchange_rate,
399: invps.amount_due_remaining inv_balance
400: FROM
401: ra_customer_trx inv,
402: ar_payment_schedules invps
403: WHERE
404: invps.payment_schedule_id = p_payment_schedule_id
405: AND inv.customer_trx_id = invps.customer_trx_id;
406: