DBA Data[Home] [Help]

APPS.ARP_PROCESS_RETURNS dependencies on AR_PAYMENT_SCHEDULES

Line 124: ar_payment_schedules invps,

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

Line 399: ar_payment_schedules invps

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