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 410: l_refund_amount ar_cash_receipts.amount%type;

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

Line 411: l_pay_refund_amount ar_cash_receipts.amount%type;

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

Line 412: l_on_account_amount ar_cash_receipts.amount%type;

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

Line 413: l_old_refund_amount ar_cash_receipts.amount%type;

409: l_total_unapp_amount NUMBER;
410: l_refund_amount ar_cash_receipts.amount%type;
411: l_pay_refund_amount ar_cash_receipts.amount%type;
412: l_on_account_amount ar_cash_receipts.amount%type;
413: l_old_refund_amount ar_cash_receipts.amount%type;
414: l_receipt_amount ar_cash_receipts.amount%type;
415: l_reapply_amount ar_cash_receipts.amount%type;
416: l_new_apply_amount ar_cash_receipts.amount%type;
417: l_new_apply_amount_fr ar_cash_receipts.amount%type;

Line 414: l_receipt_amount ar_cash_receipts.amount%type;

410: l_refund_amount ar_cash_receipts.amount%type;
411: l_pay_refund_amount ar_cash_receipts.amount%type;
412: l_on_account_amount ar_cash_receipts.amount%type;
413: l_old_refund_amount ar_cash_receipts.amount%type;
414: l_receipt_amount ar_cash_receipts.amount%type;
415: l_reapply_amount ar_cash_receipts.amount%type;
416: l_new_apply_amount ar_cash_receipts.amount%type;
417: l_new_apply_amount_fr ar_cash_receipts.amount%type;
418: l_ch_apply_amount_fr ar_cash_receipts.amount%type;

Line 415: l_reapply_amount ar_cash_receipts.amount%type;

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

Line 416: l_new_apply_amount ar_cash_receipts.amount%type;

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

Line 417: l_new_apply_amount_fr ar_cash_receipts.amount%type;

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

Line 418: l_ch_apply_amount_fr ar_cash_receipts.amount%type;

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

Line 1008: ,ar_cash_receipts cr

1004: ra.amount_applied,
1005: ra.amount_applied_from
1006: FROM
1007: ar_receivable_applications ra
1008: ,ar_cash_receipts cr
1009: ,ar_receipt_methods rm
1010: ,ra_customer_trx inv
1011: WHERE
1012: ra.applied_customer_trx_id = p_customer_trx_id

Line 1339: ar_cash_receipts cr,

1335: INTO
1336: l_total_payment_types,
1337: l_total_cc_pmts
1338: FROM AR_RECEIVABLE_APPLICATIONS ra,
1339: ar_cash_receipts cr,
1340: ar_receipt_methods rm
1341: WHERE ra.applied_customer_trx_id = p_inv_customer_trx_id
1342: AND ra.cash_receipt_id = cr.cash_receipt_id
1343: AND cr.receipt_method_id = rm.receipt_method_id;

Line 1389: FROM ar_cash_receipts cr, ar_receivable_applications ra

1385: IF x_rec_proc_option = 'REFUND' THEN
1386:
1387: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1388: INTO x_receipt_amount, x_refund_amount
1389: FROM ar_cash_receipts cr, ar_receivable_applications ra
1390: WHERE cr.cash_receipt_id = p_cash_receipt_id
1391: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1392: AND ra.applied_payment_schedule_id(+) = -6
1393: AND ra.display(+) = 'Y'

Line 1399: FROM ar_cash_receipts cr, ar_receivable_applications ra

1395:
1396: ELSIF x_rec_proc_option = 'PAY_REFUND' THEN
1397: SELECT NVL(amount, 0), NVL(SUM(amount_applied) , 0)
1398: INTO x_receipt_amount, x_refund_amount
1399: FROM ar_cash_receipts cr, ar_receivable_applications ra
1400: WHERE cr.cash_receipt_id = p_cash_receipt_id
1401: AND cr.cash_receipt_id = ra.cash_receipt_id(+)
1402: AND ra.applied_payment_schedule_id(+) = -8
1403: AND ra.display(+) = 'Y'

Line 1576: FROM ar_cash_receipts cr1

1572: WHERE
1573: EXISTS
1574: (
1575: SELECT 1
1576: FROM ar_cash_receipts cr1
1577: WHERE cr1.cash_receipt_id = p_cash_receipt_id
1578: AND cr1.reversal_date is not null
1579: );
1580: EXCEPTION