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.AR_IREC_APPLY_CREDITS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 481: from ar_receivable_applications app

477: --Bug 4000279 - Modified to check for 'UNAPP' status only
478: IF (l_trx_class = 'PMT') THEN
479: select -sum(app.amount_applied)
480: into l_amount_due_remaining
481: from ar_receivable_applications app
482: where nvl( app.confirmed_flag, 'Y' ) = 'Y'
483: AND app.status = 'UNAPP'
484: AND app.cash_receipt_id = l_cash_receipt_id;
485:

Line 1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

1175: l_msg_data VARCHAR2(255);
1176:
1177: l_sel_cash_receipt_id NUMBER;
1178:
1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1176:
1177: l_sel_cash_receipt_id NUMBER;
1178:
1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1184:

Line 1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

1177: l_sel_cash_receipt_id NUMBER;
1178:
1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1184:
1185: l_procedure_name VARCHAR2(50);

Line 1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

1178:
1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1184:
1185: l_procedure_name VARCHAR2(50);
1186: l_debug_info VARCHAR2(200);

Line 1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

1179: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1180: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1181: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
1182: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1183: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1184:
1185: l_procedure_name VARCHAR2(50);
1186: l_debug_info VARCHAR2(200);
1187:

Line 1586: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1582: l_debit_application_amount NUMBER;
1583: l_credit_application_amount NUMBER;
1584: l_credit_trx_class VARCHAR2(20);
1585:
1586: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1587: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1588: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1589:
1590: l_return_status VARCHAR2(10);

Line 1587: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

1583: l_credit_application_amount NUMBER;
1584: l_credit_trx_class VARCHAR2(20);
1585:
1586: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1587: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1588: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1589:
1590: l_return_status VARCHAR2(10);
1591: l_msg_count NUMBER;

Line 1588: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

1584: l_credit_trx_class VARCHAR2(20);
1585:
1586: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1587: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1588: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1589:
1590: l_return_status VARCHAR2(10);
1591: l_msg_count NUMBER;
1592: l_msg_data VARCHAR2(255);

Line 1736: from ar_receivable_applications rap

1732: BEGIN
1733:
1734: select 'Y'
1735: into l_found
1736: from ar_receivable_applications rap
1737: where rap.payment_schedule_id = credit_trx_record.payment_schedule_id
1738: and rap.applied_payment_schedule_id = debit_trx_record.payment_schedule_id
1739: and rap.display = 'Y'
1740: and rap.status = 'APP';

Line 2089: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2085: and acgt.trx_class = 'PMT'
2086:
2087: or ( (
2088: select sum(amount_applied)
2089: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2090: where acgt1.currency_code = p_currency_code
2091: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2092: and arp.payment_schedule_id = acgt.payment_schedule_id) = 0
2093: )

Line 2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1

2098: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2099:
2100: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2101: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2103: where acgt.currency_code = p_currency_code
2104: and acgt.trx_class = 'PMT'
2105: and acgt.payment_schedule_id = arp.payment_schedule_id
2106: and acgt1.currency_code = p_currency_code

Line 2110: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2106: and acgt1.currency_code = p_currency_code
2107: and acgt1.payment_schedule_id = arp.applied_payment_schedule_id
2108: and (
2109: select sum(amount_applied)
2110: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2111: where acgt1.currency_code = p_currency_code
2112: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2113: and arp.payment_schedule_id = acgt.payment_schedule_id) > 0;
2114: