DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 435: | ar_receivable_applications.

431: | 08-SEP-95 Charlie Tomberg Created
432: | 7/16/1996 Harri Kaukovuo Bug 382421. Line level adjustment
433: | check was looking for header level
434: | applications from
435: | ar_receivable_applications.
436: +===========================================================================*/
437:
438: PROCEDURE validate_inv_line_amount(p_adj_rec IN
439: ar_adjustments%rowtype,

Line 667: FROM ar_receivable_applications ra

663: SUM(ra.amount_applied )
664: , 0
665: )
666: INTO l_line_applied
667: FROM ar_receivable_applications ra
668: WHERE applied_payment_schedule_id = p_adj_rec.payment_schedule_id
669: AND applied_customer_trx_id = p_adj_rec.customer_trx_id;
670: */
671: /* SELECT NVL(

Line 676: FROM ar_receivable_applications ra

672: SUM(ra.amount_applied )
673: , 0
674: )
675: INTO l_line_applied
676: FROM ar_receivable_applications ra
677: WHERE
678: ra.applied_customer_trx_id = p_adj_rec.customer_trx_id
679: AND ra.applied_customer_trx_line_id= p_adj_rec.customer_trx_line_id;
680:

Line 1254: ar_receivable_applications ra,

1250:
1251: SELECT ps.amount_due_remaining-ofc.amount+p_adj_rec.amount,ofc.amount into v_cont,v_claim_amt ---Modified for the bug 14500887
1252: FROM ra_customer_trx rct,
1253: ar_payment_schedules ps,
1254: ar_receivable_applications ra,
1255: ozf_claims ofc
1256: WHERE rct.customer_trx_id=ps.customer_trx_id
1257: AND ra.applied_customer_trx_id=rct.customer_trx_id
1258: AND ofc.source_object_id = rct.customer_trx_id