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 1216: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1212: ignore integer;
1213: l_request_id NUMBER(15);
1214: l_worker_number NUMBER(10);
1215: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1216: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1217: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 1217: v_trx_date ar_cash_receipt_history.trx_date%TYPE;

1213: l_request_id NUMBER(15);
1214: l_worker_number NUMBER(10);
1215: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1216: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1217: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

Line 1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;

1214: l_worker_number NUMBER(10);
1215: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1216: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1217: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1222: v_currency ce_bank_accounts.currency_code%TYPE;

Line 1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

1215: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1216: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1217: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1222: v_currency ce_bank_accounts.currency_code%TYPE;
1223: v_amount ar_cash_receipt_history.amount%TYPE;

Line 1223: v_amount ar_cash_receipt_history.amount%TYPE;

1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1222: v_currency ce_bank_accounts.currency_code%TYPE;
1223: v_amount ar_cash_receipt_history.amount%TYPE;
1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1225: v_mod_name varchar2(30);
1226: v_mod_vers varchar2(5);
1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;

1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1222: v_currency ce_bank_accounts.currency_code%TYPE;
1223: v_amount ar_cash_receipt_history.amount%TYPE;
1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1225: v_mod_name varchar2(30);
1226: v_mod_vers varchar2(5);
1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1228: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

Line 1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1223: v_amount ar_cash_receipt_history.amount%TYPE;
1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1225: v_mod_name varchar2(30);
1226: v_mod_vers varchar2(5);
1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1228: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1229: p_cr_rec ar_cash_receipts%ROWTYPE;
1230: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1231: locked BOOLEAN;

Line 1230: p_crh_rec ar_cash_receipt_history%ROWTYPE;

1226: v_mod_vers varchar2(5);
1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1228: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1229: p_cr_rec ar_cash_receipts%ROWTYPE;
1230: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1231: locked BOOLEAN;
1232:
1233: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1234: v_crh_amount ar_cash_receipt_history.amount%TYPE;

Line 1234: v_crh_amount ar_cash_receipt_history.amount%TYPE;

1230: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1231: locked BOOLEAN;
1232:
1233: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1234: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1235: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1236: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1237: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1238:

Line 1235: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;

1231: locked BOOLEAN;
1232:
1233: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1234: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1235: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1236: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1237: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1238:
1239: --

Line 1546: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1542: statement varchar2(3000) := NULL;
1543: c integer;
1544: ignore integer;
1545: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1546: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1547: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

Line 1547: v_trx_date ar_cash_receipt_history.trx_date%TYPE;

1543: c integer;
1544: ignore integer;
1545: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1546: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1547: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;

Line 1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;

1544: ignore integer;
1545: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1546: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1547: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1552: v_currency ce_bank_accounts.currency_code%TYPE;

Line 1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;

1545: v_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
1546: v_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1547: v_trx_date ar_cash_receipt_history.trx_date%TYPE;
1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1552: v_currency ce_bank_accounts.currency_code%TYPE;
1553: v_amount ar_cash_receipt_history.amount%TYPE;

Line 1553: v_amount ar_cash_receipt_history.amount%TYPE;

1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1552: v_currency ce_bank_accounts.currency_code%TYPE;
1553: v_amount ar_cash_receipt_history.amount%TYPE;
1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1555: v_mod_name varchar2(30);
1556: v_mod_vers varchar2(5);
1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;

1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1552: v_currency ce_bank_accounts.currency_code%TYPE;
1553: v_amount ar_cash_receipt_history.amount%TYPE;
1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1555: v_mod_name varchar2(30);
1556: v_mod_vers varchar2(5);
1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1558: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

Line 1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1553: v_amount ar_cash_receipt_history.amount%TYPE;
1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1555: v_mod_name varchar2(30);
1556: v_mod_vers varchar2(5);
1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1558: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1559: p_cr_rec ar_cash_receipts%ROWTYPE;
1560: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1561: locked BOOLEAN;

Line 1560: p_crh_rec ar_cash_receipt_history%ROWTYPE;

1556: v_mod_vers varchar2(5);
1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1558: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1559: p_cr_rec ar_cash_receipts%ROWTYPE;
1560: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1561: locked BOOLEAN;
1562:
1563: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1564: v_crh_amount ar_cash_receipt_history.amount%TYPE;

Line 1564: v_crh_amount ar_cash_receipt_history.amount%TYPE;

1560: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1561: locked BOOLEAN;
1562:
1563: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1564: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1565: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1566: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1567: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1568:

Line 1565: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;

1561: locked BOOLEAN;
1562:
1563: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1564: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1565: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1566: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1567: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1568:
1569: --