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_AUTOREM_API dependencies on AR_CASH_RECEIPT_HISTORY

Line 92: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

88: ) IS
89:
90: l_request_id ar_cash_receipts.request_id%TYPE;
91: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
92: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
93: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
95: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
96: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 705: ar_cash_receipt_history

701: update ar_cash_receipts
702: set selected_remittance_batch_id = null
703: where selected_remittance_batch_id = o_batch_id
704: and cash_receipt_id in (select cash_receipt_id from
705: ar_cash_receipt_history
706: where request_id = l_request_id
707: and status = 'REMITTED'
708: and current_record_flag = 'Y');
709:

Line 757: FROM ar_cash_receipt_history crh

753: nvl(sum(crh.amount),0),
754: count(*) into
755: l_control_amount,
756: l_control_count
757: FROM ar_cash_receipt_history crh
758: WHERE crh.batch_id = o_batch_id
759: AND crh.status = 'REMITTED'
760: AND crh.current_record_flag = 'Y';
761:

Line 936: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

932: l_complete BOOLEAN := FALSE;
933: l_count NUMBER;
934: l_request_id ar_cash_receipts.request_id%TYPE;
935: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
936: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
937: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
938: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
939: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
940: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 1273: ar_cash_receipt_history crh,

1269: ar_receipt_classes rc,
1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1277: ar_distributions d

Line 1375: FROM ar_cash_receipt_history crh

1371: nvl(sum(crh.amount),0),
1372: count(*) into
1373: l_control_amount,
1374: l_control_count
1375: FROM ar_cash_receipt_history crh
1376: WHERE crh.batch_id = o_batch_id
1377: AND crh.status = 'REMITTED'
1378: AND crh.current_record_flag = 'Y';
1379:

Line 1440: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

1436: *=========================================================================*/
1437:
1438: PROCEDURE insert_batch(
1439: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1440: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1441: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1442: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1443: p_currency_code IN ar_batches.currency_code%TYPE,
1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,

Line 1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1751: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1752: p_currency_code ar_cash_receipts.currency_code%TYPE;
1753: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;

Line 1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

1752: p_currency_code ar_cash_receipts.currency_code%TYPE;
1753: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

Line 1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

1753: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

Line 1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

1754: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1755: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

Line 1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

1756: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1757: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;

Line 1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1768: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1769: p_approval_code ar_cash_receipts.approval_code%TYPE;

Line 1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1768: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1769: p_approval_code ar_cash_receipts.approval_code%TYPE;
1770: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1768: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1769: p_approval_code ar_cash_receipts.approval_code%TYPE;
1770: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1771: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

Line 1823: from ar_cash_receipt_history hist,

1819:
1820: -- XLA uptake
1821: CURSOR c_rec is
1822: select hist.cash_receipt_id cr_id
1823: from ar_cash_receipt_history hist,
1824: AR_REMIT_GT rec
1825: where hist.STATUS = 'REMITTED'
1826: and hist.cash_receipt_id = rec.cash_receipt_id;
1827:

Line 1887: ar_cash_receipt_history_s.nextval,

1883: ''FACTORING'', rma.factor_ccid,
1884: rma.remittance_ccid),
1885: rma.bank_charges_ccid,
1886: d.code_combination_id,
1887: ar_cash_receipt_history_s.nextval,
1888: greatest((bat.gl_date), (crh.trx_date)),
1889: greatest((bat.batch_date), (crh.trx_date)),
1890: cr.payment_server_order_num,
1891: cr.approval_code,

Line 1898: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,

1894: NULL,SYS_GUID(),
1895: cr.unique_reference ),
1896: cr.customer_bank_account_id,
1897: cr.payment_trxn_extension_id
1898: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1899: ar_receipt_methods rm,
1900: ar_batches bat,
1901: ar_receipt_method_accounts rma,
1902: ar_payment_schedules ps,

Line 2106: /* the first update into ar_cash_receipt_history */

2102:
2103: END IF;
2104:
2105:
2106: /* the first update into ar_cash_receipt_history */
2107:
2108: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2109: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2110: reversal_gl_date = :ucrh_gl_date_array,

Line 2108: upd_stmt1 := ' UPDATE ar_cash_receipt_history

2104:
2105:
2106: /* the first update into ar_cash_receipt_history */
2107:
2108: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2109: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2110: reversal_gl_date = :ucrh_gl_date_array,
2111: reversal_created_from = ''ARZARM'',
2112: current_record_flag = NULL,

Line 2174: /* the first update into ar_cash_receipt_history */

2170:
2171: END IF;
2172:
2173:
2174: /* the first update into ar_cash_receipt_history */
2175:
2176: ins_crh1 := 'INSERT into ar_cash_receipt_history
2177: (cash_receipt_history_id,
2178: cash_receipt_id,

Line 2176: ins_crh1 := 'INSERT into ar_cash_receipt_history

2172:
2173:
2174: /* the first update into ar_cash_receipt_history */
2175:
2176: ins_crh1 := 'INSERT into ar_cash_receipt_history
2177: (cash_receipt_history_id,
2178: cash_receipt_id,
2179: status,
2180: trx_date,

Line 2364: /* the first update into ar_cash_receipt_history */

2360:
2361: END IF;
2362:
2363:
2364: /* the first update into ar_cash_receipt_history */
2365:
2366: ins_dist1 := 'INSERT into ar_distributions
2367: (line_id,
2368: source_id,

Line 2442: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,

2438: sysdate,
2439: :i_last_updated_by,
2440: :i_org_id,
2441: :i_last_update_login
2442: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
2443: ar_lookups l
2444: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2445: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2446: AND l.lookup_code IN (''1'',''2'')';

Line 2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2532: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2533: p_currency_code ar_cash_receipts.currency_code%TYPE;
2534: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;

Line 2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

2533: p_currency_code ar_cash_receipts.currency_code%TYPE;
2534: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

Line 2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

2534: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

Line 2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

2535: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2536: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

Line 2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

2537: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2538: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;

Line 2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2549: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2550: p_approval_code ar_cash_receipts.approval_code%TYPE;

Line 2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2549: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2550: p_approval_code ar_cash_receipts.approval_code%TYPE;
2551: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2549: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2550: p_approval_code ar_cash_receipts.approval_code%TYPE;
2551: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2552: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

Line 2604: from ar_cash_receipt_history hist,

2600:
2601: -- XLA uptake
2602: CURSOR c_rec is
2603: select hist.cash_receipt_id cr_id
2604: from ar_cash_receipt_history hist,
2605: AR_REMIT_GT rec
2606: where hist.STATUS = 'REMITTED'
2607: and hist.cash_receipt_id = rec.cash_receipt_id;
2608:

Line 2665: ar_cash_receipt_history_s.nextval,

2661: nvl(factor_discount_amount,0),
2662: remittance_ccid,
2663: bank_charges_ccid,
2664: code_combination_id,
2665: ar_cash_receipt_history_s.nextval,
2666: crh_gl_date,
2667: crh_trx_date,
2668: payment_server_order_num,
2669: approval_code,

Line 2865: /* the first update into ar_cash_receipt_history */

2861:
2862: END IF;
2863:
2864:
2865: /* the first update into ar_cash_receipt_history */
2866:
2867: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2868: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2869: reversal_gl_date = :ucrh_gl_date_array,

Line 2867: upd_stmt1 := ' UPDATE ar_cash_receipt_history

2863:
2864:
2865: /* the first update into ar_cash_receipt_history */
2866:
2867: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2868: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2869: reversal_gl_date = :ucrh_gl_date_array,
2870: reversal_created_from = ''ARZARM'',
2871: current_record_flag = NULL,

Line 2933: /* the first update into ar_cash_receipt_history */

2929:
2930: END IF;
2931:
2932:
2933: /* the first update into ar_cash_receipt_history */
2934:
2935: ins_crh1 := 'INSERT into ar_cash_receipt_history
2936: (cash_receipt_history_id,
2937: cash_receipt_id,

Line 2935: ins_crh1 := 'INSERT into ar_cash_receipt_history

2931:
2932:
2933: /* the first update into ar_cash_receipt_history */
2934:
2935: ins_crh1 := 'INSERT into ar_cash_receipt_history
2936: (cash_receipt_history_id,
2937: cash_receipt_id,
2938: status,
2939: trx_date,

Line 3123: /* the first update into ar_cash_receipt_history */

3119:
3120: END IF;
3121:
3122:
3123: /* the first update into ar_cash_receipt_history */
3124:
3125: ins_dist1 := 'INSERT into ar_distributions
3126: (line_id,
3127: source_id,

Line 3201: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,

3197: sysdate,
3198: :i_last_updated_by,
3199: :i_org_id,
3200: :i_last_update_login
3201: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
3202: ar_lookups l
3203: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3204: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3205: AND l.lookup_code IN (''1'',''2'')';

Line 3362: ins_stmt := ins_stmt ||' select /+ index(crh AR_CASH_RECEIPT_HISTORY_N6) /

3358: ins_stmt := 'insert /*+ append parallel(gtt) */ into ar_rem_cr_id_gtt gtt ';
3359: ELSE
3360: ins_stmt := 'insert /*+ append */ into ar_rem_cr_id_gtt gtt ';
3361: END IF;
3362: ins_stmt := ins_stmt ||' select /*+ index(crh AR_CASH_RECEIPT_HISTORY_N6) */
3363: CASH_RECEIPT_HISTORY_ID,
3364: cash_receipt_id
3365: from ar_cash_receipt_history crh
3366: where crh.status = ''CONFIRMED'' AND

Line 3365: from ar_cash_receipt_history crh

3361: END IF;
3362: ins_stmt := ins_stmt ||' select /*+ index(crh AR_CASH_RECEIPT_HISTORY_N6) */
3363: CASH_RECEIPT_HISTORY_ID,
3364: cash_receipt_id
3365: from ar_cash_receipt_history crh
3366: where crh.status = ''CONFIRMED'' AND
3367: crh.current_record_flag = ''Y'' ';
3368: commit;
3369: execute immediate 'alter session enable parallel dml';

Line 3383: ar_cash_receipt_history crh1,

3379: l_sel_stmt := ' SELECT /*+ unnest LEADING(crh,crh1,cr) swap_join_inputs(rm) swap_join_inputs(rclass) use_hash(rm,rclass) use_nl(crh1,cr,ps,rma1,rma2) cardinality(crh,10000) */';
3380: END IF;
3381: l_sel_stmt := l_sel_stmt || ' cr.cash_receipt_id
3382: FROM ar_rem_cr_id_gtt crh,
3383: ar_cash_receipt_history crh1,
3384: ar_cash_receipts cr,
3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,

Line 5462: ar_cash_receipt_history crh,

5458: program_update_date = sysdate
5459: WHERE cash_receipt_id in (
5460: SELECT cr.cash_receipt_id
5461: FROM ar_cash_receipts cr,
5462: ar_cash_receipt_history crh,
5463: iby_trxn_extensions_v trxn_ext
5464: WHERE crh.request_id = l_request_id
5465: AND crh.status = 'REMITTED'
5466: AND crh.current_record_flag = 'Y'

Line 5514: ar_cash_receipt_history crh,

5510: l_program_application_id,
5511: l_program_id,
5512: sysdate
5513: FROM ar_cash_receipts cr,
5514: ar_cash_receipt_history crh,
5515: iby_trxn_extensions_v trxn_ext
5516: WHERE crh.request_id = l_request_id
5517: AND crh.status = 'REMITTED'
5518: AND crh.current_record_flag = 'Y'

Line 5543: ar_cash_receipt_history crh,

5539: program_update_date = sysdate
5540: WHERE cash_receipt_id in (
5541: SELECT cr.cash_receipt_id
5542: FROM ar_cash_receipts cr,
5543: ar_cash_receipt_history crh,
5544: iby_trxn_extensions_v trxn_ext
5545: WHERE crh.request_id = l_request_id
5546: AND crh.status = 'REMITTED'
5547: AND crh.current_record_flag = 'Y'

Line 5595: ar_cash_receipt_history crh,

5591: l_program_application_id,
5592: l_program_id,
5593: sysdate
5594: FROM ar_cash_receipts cr,
5595: ar_cash_receipt_history crh,
5596: iby_trxn_extensions_v trxn_ext
5597: WHERE crh.request_id = l_request_id
5598: AND crh.status = 'REMITTED'
5599: AND crh.current_record_flag = 'Y'

Line 5642: ar_cash_receipt_history crh,

5638: SET cc_error_flag = null
5639: WHERE cash_receipt_id in (
5640: SELECT cr.cash_receipt_id
5641: FROM ar_cash_receipts cr,
5642: ar_cash_receipt_history crh,
5643: iby_trxn_extensions_v trxn_ext
5644: WHERE cr.request_id = p_request_id
5645: AND cr.cc_error_flag = 'Y'
5646: AND cr.type = 'CASH'

Line 5669: ar_cash_receipt_history crh,

5665: SET cc_error_flag = null
5666: WHERE cash_receipt_id in (
5667: SELECT cr.cash_receipt_id
5668: FROM ar_cash_receipts cr,
5669: ar_cash_receipt_history crh,
5670: iby_trxn_extensions_v trxn_ext
5671: WHERE cr.request_id = p_request_id
5672: AND cr.cc_error_flag = 'Y'
5673: AND cr.type = 'MISC'

Line 5702: UPDATE ar_cash_receipt_history

5698: fnd_file.put_line(FND_FILE.LOG,' rows updated CR = ' || SQL%ROWCOUNT );
5699: END IF;
5700:
5701:
5702: UPDATE ar_cash_receipt_history
5703: SET reversal_cash_receipt_hist_id = null,
5704: reversal_gl_date = null,
5705: reversal_created_from = null,
5706: current_record_flag = 'Y'

Line 5721: from ar_cash_receipt_history crh,

5717:
5718: delete from ar_distributions
5719: where source_table = 'CRH'
5720: and source_id in ( select crh.cash_receipt_history_id
5721: from ar_cash_receipt_history crh,
5722: ar_cash_receipts cr
5723: where crh.STATUS = 'REMITTED'
5724: and crh.request_id = p_request_id
5725: and cr.cash_receipt_id = crh.cash_receipt_id

Line 5733: delete from ar_cash_receipt_history

5729: IF PG_DEBUG in ('Y','C') THEN
5730: fnd_file.put_line(FND_FILE.LOG,' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
5731: END IF;
5732:
5733: delete from ar_cash_receipt_history
5734: where STATUS = 'REMITTED'
5735: and request_id = p_request_id
5736: and cash_receipt_id in ( select cash_receipt_id
5737: from ar_cash_receipts