eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_RECEIPTS

Line 160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE

156: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
157: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
158: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
159: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
160: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
161: , x_out_amount_to_apply OUT NOCOPY NUMBER
162: , x_out_discount_to_take OUT NOCOPY NUMBER);
163:
164: PROCEDURE calc_amt_applied_from(

Line 475: l_receipt_date_low AR_CASH_RECEIPTS.receipt_date%TYPE;

471: l_use_cust VARCHAR2(1) := 'N';
472: l_use_party VARCHAR2(1) := 'N';
473: l_worker_number NUMBER;
474: l_complete BOOLEAN := FALSE;
475: l_receipt_date_low AR_CASH_RECEIPTS.receipt_date%TYPE;
476: l_receipt_date_high AR_CASH_RECEIPTS.receipt_date%TYPE;
477: l_errbuf VARCHAR2(1000);
478: l_retcode NUMBER;
479:

Line 476: l_receipt_date_high AR_CASH_RECEIPTS.receipt_date%TYPE;

472: l_use_party VARCHAR2(1) := 'N';
473: l_worker_number NUMBER;
474: l_complete BOOLEAN := FALSE;
475: l_receipt_date_low AR_CASH_RECEIPTS.receipt_date%TYPE;
476: l_receipt_date_high AR_CASH_RECEIPTS.receipt_date%TYPE;
477: l_errbuf VARCHAR2(1000);
478: l_retcode NUMBER;
479:
480: insert_gt INTEGER;

Line 615: , AR_CASH_RECEIPTS cr ';

611: ref.BATCH_ID,
612: MOD( ref.CASH_RECEIPT_ID, :b_total_workers) + 1';
613:
614: l_from_clause := ' FROM AR_CASH_REMIT_REFS ref
615: , AR_CASH_RECEIPTS cr ';
616:
617: l_where_clause := ' WHERE ref.auto_applied = ''N''
618: AND ref.manually_applied = ''N''
619: AND ref.resolved_matching_number = ''NULL''

Line 780: ar_cash_receipts cr

776: WHERE cri.cash_receipt_id IN (
777: SELECT distinct cr.cash_receipt_id
778: FROM ar_cash_remit_refs_interim cri1,
779: ar_cash_auto_rule_sets aca,
780: ar_cash_receipts cr
781: WHERE cr.cash_receipt_id = cri1.cash_receipt_id
782: AND cr.automatch_set_id = aca.automatch_set_id
783: AND (cr.receipt_date < NVL(aca.start_date, cr.receipt_date)
784: OR cr.receipt_date > NVL(aca.end_date, to_date('31/12/4712','DD/MM/YYYY'))

Line 898: UPDATE ar_cash_receipts_all cr

894:
895: /* * If a receipt has any unapplied remittance line, update the *
896: * receipt work_item_exception_reason with the exception reason *
897: * defined at the AutoMatchRule Setup * */
898: UPDATE ar_cash_receipts_all cr
899: SET WORK_ITEM_EXCEPTION_REASON =
900: (SELECT exception_reason
901: FROM ar_cash_auto_rule_sets
902: WHERE automatch_set_id = cr.automatch_set_id)

Line 1233: ar_cash_receipts cr,

1229: ORDER BY ps.payment_schedule_id) AS reco_num
1230: FROM ar_cash_automatches am,
1231: ar_cash_automatch_rule_map amp,
1232: ar_cash_remit_refs_interim ref,
1233: ar_cash_receipts cr,
1234: ar_payment_schedules ps,
1235: ra_customer_trx trx,
1236: ra_cust_trx_types ctt,
1237: ra_terms tr

Line 1480: ar_cash_receipts cr,

1476: ORDER BY ps.payment_schedule_id) AS reco_num
1477: FROM ar_cash_automatches am,
1478: ar_cash_automatch_rule_map amp,
1479: ar_cash_remit_refs_interim ref,
1480: ar_cash_receipts cr,
1481: ra_customer_trx trx,
1482: ar_payment_schedules ps,
1483: ra_cust_trx_types ctt,
1484: ra_terms tr

Line 1721: ar_cash_receipts cr,

1717: ORDER BY ps.payment_schedule_id) AS reco_num
1718: FROM ar_cash_automatches am,
1719: ar_cash_automatch_rule_map amp,
1720: ar_cash_remit_refs_interim ref,
1721: ar_cash_receipts cr,
1722: ra_customer_trx_lines lin,
1723: ar_payment_schedules ps,
1724: ra_customer_trx trx,
1725: ra_cust_trx_types ctt,

Line 1965: ar_cash_receipts cr,

1961: ORDER BY ps.payment_schedule_id) AS reco_num
1962: FROM ar_cash_automatches am,
1963: ar_cash_automatch_rule_map amp,
1964: ar_cash_remit_refs_interim ref,
1965: ar_cash_receipts cr,
1966: ra_customer_trx_lines lin,
1967: ar_payment_schedules ps,
1968: ra_customer_trx trx,
1969: ra_cust_trx_types ctt,

Line 2212: ar_cash_receipts cr,

2208: ORDER BY ps.payment_schedule_id) AS reco_num
2209: FROM ar_cash_automatches am,
2210: ar_cash_automatch_rule_map amp,
2211: ar_cash_remit_refs_interim ref,
2212: ar_cash_receipts cr,
2213: ra_customer_trx trx,
2214: ar_payment_schedules ps,
2215: ra_cust_trx_types ctt,
2216: ra_terms tr

Line 2473: ar_cash_receipts cr,

2469: ORDER BY ps.payment_schedule_id) AS reco_num
2470: FROM ar_cash_automatches am,
2471: ar_cash_automatch_rule_map amp,
2472: ar_cash_remit_refs_interim ref,
2473: ar_cash_receipts cr,
2474: ra_customer_trx trx,
2475: ar_payment_schedules ps,
2476: ra_cust_trx_types ctt,
2477: ra_terms tr

Line 2694: ar_cash_receipts cr,

2690: ORDER BY ps.due_date, ps.payment_schedule_id) AS reco_num
2691: FROM ar_cash_automatches am,
2692: ar_cash_automatch_rule_map amp,
2693: ar_cash_remit_refs_interim ref,
2694: ar_cash_receipts cr,
2695: ar_cons_inv ci,
2696: ar_payment_schedules ps,
2697: ra_customer_trx trx,
2698: ra_cust_trx_types ctt,

Line 2940: ar_cash_receipts cr,

2936: ORDER BY ps.payment_schedule_id) AS reco_num
2937: FROM ar_cash_automatches am,
2938: ar_cash_automatch_rule_map amp,
2939: ar_cash_remit_refs_interim ref,
2940: ar_cash_receipts cr,
2941: ar_payment_schedules ps,
2942: ra_customer_trx trx,
2943: ra_cust_trx_types ctt,
2944: ra_terms tr

Line 3506: FROM ar_cash_receipts cr,

3502: WHERE remit_reference_id IN (SELECT remit_reference_id
3503: FROM ar_cash_remit_refs_interim ref1
3504: WHERE cash_receipt_id IN (
3505: SELECT cr.cash_receipt_id
3506: FROM ar_cash_receipts cr,
3507: ar_cash_remit_refs_interim ref,
3508: ar_cash_recos rec,
3509: ar_cash_reco_lines recl
3510: WHERE cr.autoapply_flag = 'Y'

Line 3596: ar_cash_receipts cr,

3592: FROM ar_cash_remit_refs_interim
3593: WHERE cash_receipt_id IN (
3594: SELECT ps.cash_receipt_id
3595: FROM ar_payment_schedules ps,
3596: ar_cash_receipts cr,
3597: ar_cash_remit_refs_interim ref,
3598: ar_cash_recos rec,
3599: ar_cash_reco_lines recl
3600: WHERE ps.cash_receipt_id = cr.cash_receipt_id

Line 3766: l_rec_currency_code ar_cash_receipts.currency_code%TYPE;

3762: l_old_remit_reference_id NUMBER := -1;
3763: l_ref_amt_applied NUMBER;
3764: loop_index NUMBER;
3765: l_ref_amt_applied_from NUMBER;
3766: l_rec_currency_code ar_cash_receipts.currency_code%TYPE;
3767: l_amount_applied BOOLEAN;
3768: l_amount_applied_from BOOLEAN;
3769:
3770: CURSOR app_reco_cur IS

Line 3811: ar_cash_receipts cr

3807: ref.cash_receipt_id,
3808: cr.currency_code
3809: FROM ar_cash_recos rec,
3810: ar_cash_remit_refs_interim ref,
3811: ar_cash_receipts cr
3812: WHERE rec.request_id = p_req_id
3813: AND rec.match_reason_code = 'AR_AM_INV_THRESHOLD'
3814: AND rec.match_resolved_using = 'BALANCE FORWARD BILL'
3815: AND ref.remit_reference_id = rec.remit_reference_id

Line 4117: l_receipt_currency_code AR_CASH_RECEIPTS.currency_code%TYPE;

4113: l_ref_rem_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4114: l_trans_to_receipt_rate AR_CASH_REMIT_REFS.trans_to_receipt_rate%TYPE;
4115: l_res_matching_date AR_PAYMENT_SCHEDULES.trx_date%TYPE;
4116: l_match_score_value AR_CASH_RECOS.match_score_value%TYPE;
4117: l_receipt_currency_code AR_CASH_RECEIPTS.currency_code%TYPE;
4118: l_resolved_match_currency AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE;
4119: l_trx_amt_due_rem AR_CASH_REMIT_REFS.amount_applied%TYPE := 0;
4120: l_discount_taken AR_CASH_RECO_LINES.discount_taken_earned%TYPE := 0;
4121: l_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE;

Line 4489: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)

4485:
4486: FUNCTION get_cross_curr_rate(p_amount_applied IN ar_cash_remit_refs.amount_applied%TYPE
4487: , p_amount_applied_from IN ar_cash_remit_refs.amount_applied_from%TYPE
4488: , p_inv_curr_code IN ar_payment_schedules.invoice_currency_code%TYPE
4489: , p_rec_curr_code IN ar_cash_receipts.currency_code%TYPE)
4490: RETURN NUMBER IS
4491: l_cross_curr_rate NUMBER;
4492: l_amount_applied ar_cash_remit_refs.amount_applied%TYPE;
4493: l_amount_applied_from ar_cash_remit_refs.amount_applied_from%TYPE;

Line 4495: l_rec_curr_code ar_cash_receipts.currency_code%TYPE;

4491: l_cross_curr_rate NUMBER;
4492: l_amount_applied ar_cash_remit_refs.amount_applied%TYPE;
4493: l_amount_applied_from ar_cash_remit_refs.amount_applied_from%TYPE;
4494: l_inv_curr_code ar_payment_schedules.invoice_currency_code%TYPE;
4495: l_rec_curr_code ar_cash_receipts.currency_code%TYPE;
4496: BEGIN
4497: l_amount_applied := NVL(p_amount_applied, 0);
4498: l_amount_applied_from := NVL(p_amount_applied_from, 0);
4499: l_inv_curr_code := p_inv_curr_code;

Line 4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE

4523: , p_amount_due_original IN AR_PAYMENT_SCHEDULES.amount_due_original%TYPE
4524: , p_amount_due_remaining IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE
4525: , p_discount_taken_earned IN AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE
4526: , p_discount_taken_unearned IN AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE
4527: , p_cash_receipt_id IN AR_CASH_RECEIPTS.cash_receipt_id%TYPE
4528: , x_out_amount_to_apply OUT NOCOPY NUMBER
4529: , x_out_discount_to_take OUT NOCOPY NUMBER) IS
4530: l_customer_id AR_PAYMENT_SCHEDULES.customer_id%TYPE;
4531: l_bill_to_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;

Line 4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;

4540: l_amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
4541: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4542: l_discount_taken_earned AR_PAYMENT_SCHEDULES.discount_taken_earned%TYPE;
4543: l_discount_taken_unearned AR_PAYMENT_SCHEDULES.discount_taken_unearned%TYPE;
4544: l_cash_receipt_id AR_CASH_RECEIPTS.cash_receipt_id%TYPE;
4545:
4546: ln_earned_disc_pct NUMBER;
4547: ln_best_disc_pct NUMBER;
4548: ln_out_discount_date DATE;