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 1582: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1578: l_debit_application_amount NUMBER;
1579: l_credit_application_amount NUMBER;
1580: l_credit_trx_class VARCHAR2(20);
1581:
1582: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1583: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1584: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1585:
1586: l_return_status VARCHAR2(10);

Line 1583: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

1579: l_credit_application_amount NUMBER;
1580: l_credit_trx_class VARCHAR2(20);
1581:
1582: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1583: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1584: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1585:
1586: l_return_status VARCHAR2(10);
1587: l_msg_count NUMBER;

Line 1584: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

1580: l_credit_trx_class VARCHAR2(20);
1581:
1582: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1583: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
1584: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
1585:
1586: l_return_status VARCHAR2(10);
1587: l_msg_count NUMBER;
1588: l_msg_data VARCHAR2(255);

Line 1732: from ar_receivable_applications rap

1728: BEGIN
1729:
1730: select 'Y'
1731: into l_found
1732: from ar_receivable_applications rap
1733: where rap.payment_schedule_id = credit_trx_record.payment_schedule_id
1734: and rap.applied_payment_schedule_id = debit_trx_record.payment_schedule_id
1735: and rap.display = 'Y'
1736: and rap.status = 'APP';

Line 2085: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2081: and acgt.trx_class = 'PMT'
2082: and (not exists
2083: (
2084: select arp.payment_schedule_id
2085: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2086: where acgt1.currency_code = p_currency_code
2087: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2088: and arp.payment_schedule_id = acgt.payment_schedule_id
2089: )

Line 2092: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2088: and arp.payment_schedule_id = acgt.payment_schedule_id
2089: )
2090: or ( (
2091: select sum(amount_applied)
2092: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2093: where acgt1.currency_code = p_currency_code
2094: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2095: and arp.payment_schedule_id = acgt.payment_schedule_id) = 0
2096: )

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

2100: /*
2101:
2102: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2103: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2104: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2105: where acgt.currency_code = p_currency_code
2106: and acgt.trx_class = 'PMT'
2107: and acgt.payment_schedule_id = arp.payment_schedule_id
2108: and acgt1.currency_code = p_currency_code

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

2112: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2113:
2114: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2115: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2116: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2117: where acgt.currency_code = p_currency_code
2118: and acgt.trx_class = 'PMT'
2119: and acgt.payment_schedule_id = arp.payment_schedule_id
2120: and acgt1.currency_code = p_currency_code

Line 2124: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1

2120: and acgt1.currency_code = p_currency_code
2121: and acgt1.payment_schedule_id = arp.applied_payment_schedule_id
2122: and (
2123: select sum(amount_applied)
2124: from ar_receivable_applications arp, ar_irec_apply_credit_gt acgt1
2125: where acgt1.currency_code = p_currency_code
2126: and arp.applied_payment_schedule_id = acgt1.payment_schedule_id
2127: and arp.payment_schedule_id = acgt.payment_schedule_id) > 0;
2128: