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_PROCESS_RETURNS dependencies on AR_CASH_RECEIPTS

Line 413: l_refund_amount ar_cash_receipts.amount%type;

409: l_apply_failed EXCEPTION;
410: l_activity_app_failed EXCEPTION;
411: l_on_account_app_failed EXCEPTION;
412: l_total_unapp_amount NUMBER;
413: l_refund_amount ar_cash_receipts.amount%type;
414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;

Line 414: l_pay_refund_amount ar_cash_receipts.amount%type;

410: l_activity_app_failed EXCEPTION;
411: l_on_account_app_failed EXCEPTION;
412: l_total_unapp_amount NUMBER;
413: l_refund_amount ar_cash_receipts.amount%type;
414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;

Line 415: l_on_account_amount ar_cash_receipts.amount%type;

411: l_on_account_app_failed EXCEPTION;
412: l_total_unapp_amount NUMBER;
413: l_refund_amount ar_cash_receipts.amount%type;
414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;

Line 416: l_old_refund_amount ar_cash_receipts.amount%type;

412: l_total_unapp_amount NUMBER;
413: l_refund_amount ar_cash_receipts.amount%type;
414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;

Line 417: l_receipt_amount ar_cash_receipts.amount%type;

413: l_refund_amount ar_cash_receipts.amount%type;
414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;
421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;

Line 418: l_reapply_amount ar_cash_receipts.amount%type;

414: l_pay_refund_amount ar_cash_receipts.amount%type;
415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;
421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;
422: l_total_unapp_amount NUMBER;

Line 419: l_new_apply_amount ar_cash_receipts.amount%type;

415: l_on_account_amount ar_cash_receipts.amount%type;
416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;
421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;
422: l_total_unapp_amount NUMBER;
423: l_rec_in_doubt VARCHAR2(1):='N';

Line 420: l_new_apply_amount_fr ar_cash_receipts.amount%type;

416: l_old_refund_amount ar_cash_receipts.amount%type;
417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;
421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;
422: l_total_unapp_amount NUMBER;
423: l_rec_in_doubt VARCHAR2(1):='N';
424: l_rid_reason VARCHAR2(2000):= null;

Line 421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;

417: l_receipt_amount ar_cash_receipts.amount%type;
418: l_reapply_amount ar_cash_receipts.amount%type;
419: l_new_apply_amount ar_cash_receipts.amount%type;
420: l_new_apply_amount_fr ar_cash_receipts.amount%type;
421: l_ch_apply_amount_fr ar_cash_receipts.amount%type;
422: l_total_unapp_amount NUMBER;
423: l_rec_in_doubt VARCHAR2(1):='N';
424: l_rid_reason VARCHAR2(2000):= null;
425: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1022: ,ar_cash_receipts cr

1018: ra.amount_applied,
1019: ra.amount_applied_from
1020: FROM
1021: ar_receivable_applications ra
1022: ,ar_cash_receipts cr
1023: ,ar_receipt_methods rm
1024: ,ra_customer_trx inv
1025: WHERE
1026: ra.applied_customer_trx_id = p_customer_trx_id

Line 1367: ar_cash_receipts cr,

1363: INTO
1364: l_total_payment_types,
1365: l_total_cc_pmts
1366: FROM AR_RECEIVABLE_APPLICATIONS ra,
1367: ar_cash_receipts cr,
1368: ar_receipt_methods rm
1369: WHERE ra.applied_customer_trx_id = p_inv_customer_trx_id
1370: AND ra.cash_receipt_id = cr.cash_receipt_id
1371: AND cr.receipt_method_id = rm.receipt_method_id;

Line 1417: FROM ar_cash_receipts cr, ar_receivable_applications ra

1413: IF x_rec_proc_option = 'REFUND' THEN
1414:
1415: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1416: INTO x_receipt_amount, x_refund_amount
1417: FROM ar_cash_receipts cr, ar_receivable_applications ra
1418: WHERE cr.cash_receipt_id = p_cash_receipt_id
1419: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1420: AND ra.applied_payment_schedule_id(+) = -6
1421: AND ra.display(+) = 'Y'

Line 1427: FROM ar_cash_receipts cr, ar_receivable_applications ra

1423:
1424: ELSIF x_rec_proc_option = 'PAY_REFUND' THEN
1425: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1426: INTO x_receipt_amount, x_refund_amount
1427: FROM ar_cash_receipts cr, ar_receivable_applications ra
1428: WHERE cr.cash_receipt_id = p_cash_receipt_id
1429: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1430: AND ra.applied_payment_schedule_id(+) = -8
1431: AND ra.display(+) = 'Y'

Line 1604: FROM ar_cash_receipts cr1

1600: WHERE
1601: EXISTS
1602: (
1603: SELECT 1
1604: FROM ar_cash_receipts cr1
1605: WHERE cr1.cash_receipt_id = p_cash_receipt_id
1606: AND cr1.reversal_date is not null
1607: );
1608: EXCEPTION