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_RECEIPT_HISTORY

Line 201: 'ar_cash_receipt_history crh, ' ||

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, ' ||
205: 'hz_customer_profiles cpc, ' ||

Line 202: 'ar_cash_receipt_history crh2, ' ||

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, ' ||
205: 'hz_customer_profiles cpc, ' ||
206: 'ar_receipt_method_accounts rma, ' ||

Line 266: 'select /+ INDEX (CRH AR_CASH_RECEIPT_HISTORY_N6) USE_NL(crh,cr,rm,rc,rma,c,party,ba) / ' ||

262:
263: /* Bug 3820774 Replaced the get_rate with get_rate_sql. */
264: /*Bug5444413 Added hint */
265: statement := statement ||
266: 'select /*+ INDEX (CRH AR_CASH_RECEIPT_HISTORY_N6) USE_NL(crh,cr,rm,rc,rma,c,party,ba) */ ' ||
267: 'cr.cash_receipt_id, '||
268: ':b_clear_date, ' ||
269: 'greatest ( crh.gl_date, :b_gl_date ), ' ||
270: 'nvl(:b_clear_date,crh.exchange_date), ' ||

Line 296: 'ar_cash_receipt_history crh, ' ||

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, ' ||
300: 'ar_receipt_methods rm, ' ||

Line 382: 'ar_cash_receipt_history crh, ' ||

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, ' ||
386: 'ar_receipt_method_accounts rma, ' ||

Line 519: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

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;
523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 520: v_trx_date ar_cash_receipt_history.trx_date%TYPE;

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;
523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
524: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

Line 521: v_gl_date ar_cash_receipt_history.gl_date%TYPE;

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;
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;

Line 522: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

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;
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;

Line 526: v_amount ar_cash_receipt_history.amount%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);
529: v_mod_vers varchar2(5);
530: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 527: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%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);
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;

Line 530: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%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);
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;

Line 533: p_crh_rec ar_cash_receipt_history%ROWTYPE;

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.
537: v_crh_amount ar_cash_receipt_history.amount%TYPE;

Line 537: v_crh_amount ar_cash_receipt_history.amount%TYPE;

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.
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:

Line 538: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;

534: locked BOOLEAN;
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: --

Line 1244: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

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;
1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 1245: v_trx_date ar_cash_receipt_history.trx_date%TYPE;

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;
1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1249: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

Line 1246: v_gl_date ar_cash_receipt_history.gl_date%TYPE;

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;
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;

Line 1247: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

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;
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;

Line 1251: v_amount ar_cash_receipt_history.amount%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);
1254: v_mod_vers varchar2(5);
1255: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1252: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%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);
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;

Line 1255: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%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);
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;

Line 1258: p_crh_rec ar_cash_receipt_history%ROWTYPE;

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.
1262: v_crh_amount ar_cash_receipt_history.amount%TYPE;

Line 1262: v_crh_amount ar_cash_receipt_history.amount%TYPE;

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.
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:

Line 1263: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;

1259: locked BOOLEAN;
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: --

Line 1574: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

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;
1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 1575: v_trx_date ar_cash_receipt_history.trx_date%TYPE;

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;
1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1579: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

Line 1576: v_gl_date ar_cash_receipt_history.gl_date%TYPE;

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;
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;

Line 1577: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

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;
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;

Line 1581: v_amount ar_cash_receipt_history.amount%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);
1584: v_mod_vers varchar2(5);
1585: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1582: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%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);
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;

Line 1585: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%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);
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;

Line 1588: p_crh_rec ar_cash_receipt_history%ROWTYPE;

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.
1592: v_crh_amount ar_cash_receipt_history.amount%TYPE;

Line 1592: v_crh_amount ar_cash_receipt_history.amount%TYPE;

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.
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:

Line 1593: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;

1589: locked BOOLEAN;
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: --