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

Line 200: 'ar_cash_receipts cr, ' ||

196: || p_total_workers ||') + 1, '||
197: p_request_id ||' , ''RISK'' ';
198: END IF;
199: statement := statement || 'from ' ||
200: 'ar_cash_receipts cr, ' ||
201: 'ar_cash_receipt_history crh, ' ||
202: 'ar_cash_receipt_history crh2, ' ||
203: 'ar_payment_schedules ps, ' ||
204: 'hz_customer_profiles cps, ' ||

Line 295: 'ar_cash_receipts cr, ' ||

291: || p_total_workers ||') + 1, '||
292: p_request_id ||' , ''FACTOR'' ';
293: END IF;
294: statement := statement || 'from ' ||
295: 'ar_cash_receipts cr, ' ||
296: 'ar_cash_receipt_history crh, ' ||
297: 'ar_receipt_method_accounts rma, ' ||
298: 'ce_bank_accounts cba, ' ||
299: 'ce_bank_acct_uses ba, ' ||

Line 381: statement := statement || 'from ar_cash_receipts cr, ' ||

377: ', MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), '
378: || p_total_workers ||') + 1, '||
379: p_request_id ||' , ''REMIT'' ';
380: END IF;
381: statement := statement || 'from ar_cash_receipts cr, ' ||
382: 'ar_cash_receipt_history crh, ' ||
383: 'ar_payment_schedules ps, ' ||
384: 'hz_customer_profiles cpc, ' ||
385: 'hz_customer_profiles cps, ' ||

Line 518: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

514: --
515: statement varchar2(3000) := NULL;
516: c integer;
517: ignore integer;
518: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
519: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
520: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
521: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
522: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

Line 523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

519: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
520: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
521: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
522: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
524: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
525: v_currency ce_bank_accounts.currency_code%TYPE;
526: v_amount ar_cash_receipt_history.amount%TYPE;
527: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;

Line 524: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

520: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
521: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
522: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
524: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
525: v_currency ce_bank_accounts.currency_code%TYPE;
526: v_amount ar_cash_receipt_history.amount%TYPE;
527: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
528: v_mod_name varchar2(30);

Line 532: p_cr_rec ar_cash_receipts%ROWTYPE;

528: v_mod_name varchar2(30);
529: v_mod_vers varchar2(5);
530: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
531: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
532: p_cr_rec ar_cash_receipts%ROWTYPE;
533: p_crh_rec ar_cash_receipt_history%ROWTYPE;
534: locked BOOLEAN;
535:
536: -- 785113: Added to compute new acctd amts based on a different exchange rate.

Line 539: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;

535:
536: -- 785113: Added to compute new acctd amts based on a different exchange rate.
537: v_crh_amount ar_cash_receipt_history.amount%TYPE;
538: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
539: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
540: v_cr_currency ce_bank_accounts.currency_code%TYPE;
541:
542: --
543: BEGIN

Line 1243: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

1239: c integer;
1240: ignore integer;
1241: l_request_id NUMBER(15);
1242: l_worker_number NUMBER(10);
1243: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1244: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1245: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1246: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1247: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

Line 1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

1244: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1245: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1246: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1247: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1249: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1250: v_currency ce_bank_accounts.currency_code%TYPE;
1251: v_amount ar_cash_receipt_history.amount%TYPE;
1252: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;

Line 1249: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

1245: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1246: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1247: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1249: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1250: v_currency ce_bank_accounts.currency_code%TYPE;
1251: v_amount ar_cash_receipt_history.amount%TYPE;
1252: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1253: v_mod_name varchar2(30);

Line 1257: p_cr_rec ar_cash_receipts%ROWTYPE;

1253: v_mod_name varchar2(30);
1254: v_mod_vers varchar2(5);
1255: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1256: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1257: p_cr_rec ar_cash_receipts%ROWTYPE;
1258: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1259: locked BOOLEAN;
1260:
1261: -- 785113: Added to compute new acctd amts based on a different exchange rate.

Line 1264: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;

1260:
1261: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1262: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1263: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1264: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1265: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1266:
1267: --
1268: BEGIN

Line 1573: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

1569: --
1570: statement varchar2(3000) := NULL;
1571: c integer;
1572: ignore integer;
1573: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1574: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1575: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1576: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1577: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

Line 1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

1574: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1575: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1576: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1577: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1579: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1580: v_currency ce_bank_accounts.currency_code%TYPE;
1581: v_amount ar_cash_receipt_history.amount%TYPE;
1582: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;

Line 1579: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

1575: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1576: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1577: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1579: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1580: v_currency ce_bank_accounts.currency_code%TYPE;
1581: v_amount ar_cash_receipt_history.amount%TYPE;
1582: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1583: v_mod_name varchar2(30);

Line 1587: p_cr_rec ar_cash_receipts%ROWTYPE;

1583: v_mod_name varchar2(30);
1584: v_mod_vers varchar2(5);
1585: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1586: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1587: p_cr_rec ar_cash_receipts%ROWTYPE;
1588: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1589: locked BOOLEAN;
1590:
1591: -- 785113: Added to compute new acctd amts based on a different exchange rate.

Line 1594: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;

1590:
1591: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1592: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1593: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1594: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1595: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1596:
1597: --
1598: BEGIN