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 96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

92: ) IS
93:
94: l_request_id ar_cash_receipts.request_id%TYPE;
95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 731: ar_cash_receipt_history

727: update ar_cash_receipts
728: set selected_remittance_batch_id = null
729: where selected_remittance_batch_id = o_batch_id
730: and cash_receipt_id in (select cash_receipt_id from
731: ar_cash_receipt_history
732: where request_id = l_request_id
733: and status = 'REMITTED'
734: and current_record_flag = 'Y');
735:

Line 783: FROM ar_cash_receipt_history crh

779: nvl(sum(crh.amount),0),
780: count(*) into
781: l_control_amount,
782: l_control_count
783: FROM ar_cash_receipt_history crh
784: WHERE crh.batch_id = o_batch_id
785: AND crh.status = 'REMITTED'
786: AND crh.current_record_flag = 'Y';
787:

Line 985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

981: l_complete BOOLEAN := FALSE;
982: l_count NUMBER;
983: l_request_id ar_cash_receipts.request_id%TYPE;
984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 1337: ar_cash_receipt_history crh,

1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,
1340: ar_distributions d
1341: WHERE cr.selected_remittance_batch_id = :b_batch_id

Line 1438: FROM ar_cash_receipt_history crh

1434: nvl(sum(crh.amount),0),
1435: count(*) into
1436: l_control_amount,
1437: l_control_count
1438: FROM ar_cash_receipt_history crh
1439: WHERE crh.batch_id = o_batch_id
1440: AND crh.status = 'REMITTED'
1441: AND crh.current_record_flag = 'Y';
1442:

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

1499: *=========================================================================*/
1500:
1501: PROCEDURE insert_batch(
1502: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1503: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,
1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,

Line 1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;

Line 1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

Line 1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

Line 1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

Line 1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;

Line 1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;

Line 1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

Line 1887: from ar_cash_receipt_history hist,

1883:
1884: -- XLA uptake
1885: CURSOR c_rec is
1886: select hist.cash_receipt_id cr_id
1887: from ar_cash_receipt_history hist,
1888: AR_REMIT_GT rec
1889: where hist.STATUS = 'REMITTED'
1890: and hist.cash_receipt_id = rec.cash_receipt_id;
1891:

Line 1951: ar_cash_receipt_history_s.nextval,

1947: ''FACTORING'', rma.factor_ccid,
1948: rma.remittance_ccid),
1949: rma.bank_charges_ccid,
1950: d.code_combination_id,
1951: ar_cash_receipt_history_s.nextval,
1952: greatest((bat.gl_date), (crh.gl_date)),
1953: greatest((bat.batch_date), (crh.trx_date)),
1954: cr.payment_server_order_num,
1955: cr.approval_code,

Line 1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,

1958: NULL,SYS_GUID(),
1959: cr.unique_reference ),
1960: cr.customer_bank_account_id,
1961: cr.payment_trxn_extension_id
1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1963: ar_receipt_methods rm,
1964: ar_batches bat,
1965: ar_receipt_method_accounts rma,
1966: ar_payment_schedules ps,

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

2166:
2167: END IF;
2168:
2169:
2170: /* the first update into ar_cash_receipt_history */
2171:
2172: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2173: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2174: reversal_gl_date = :ucrh_gl_date_array,

Line 2172: upd_stmt1 := ' UPDATE ar_cash_receipt_history

2168:
2169:
2170: /* the first update into ar_cash_receipt_history */
2171:
2172: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2173: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2174: reversal_gl_date = :ucrh_gl_date_array,
2175: reversal_created_from = ''ARZARM'',
2176: current_record_flag = NULL,

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

2234:
2235: END IF;
2236:
2237:
2238: /* the first update into ar_cash_receipt_history */
2239:
2240: ins_crh1 := 'INSERT into ar_cash_receipt_history
2241: (cash_receipt_history_id,
2242: cash_receipt_id,

Line 2240: ins_crh1 := 'INSERT into ar_cash_receipt_history

2236:
2237:
2238: /* the first update into ar_cash_receipt_history */
2239:
2240: ins_crh1 := 'INSERT into ar_cash_receipt_history
2241: (cash_receipt_history_id,
2242: cash_receipt_id,
2243: status,
2244: trx_date,

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

2424:
2425: END IF;
2426:
2427:
2428: /* the first update into ar_cash_receipt_history */
2429:
2430: ins_dist1 := 'INSERT into ar_distributions
2431: (line_id,
2432: source_id,

Line 2506: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,

2502: sysdate,
2503: :i_last_updated_by,
2504: :i_org_id,
2505: :i_last_update_login
2506: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
2507: ar_lookups l
2508: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2509: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2510: AND l.lookup_code IN (''1'',''2'')';

Line 2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;

Line 2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

Line 2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

Line 2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

Line 2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;

Line 2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;

Line 2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

Line 2668: from ar_cash_receipt_history hist,

2664:
2665: -- XLA uptake
2666: CURSOR c_rec is
2667: select hist.cash_receipt_id cr_id
2668: from ar_cash_receipt_history hist,
2669: AR_REMIT_GT rec
2670: where hist.STATUS = 'REMITTED'
2671: and hist.cash_receipt_id = rec.cash_receipt_id;
2672:

Line 2729: ar_cash_receipt_history_s.nextval,

2725: nvl(factor_discount_amount,0),
2726: remittance_ccid,
2727: bank_charges_ccid,
2728: code_combination_id,
2729: ar_cash_receipt_history_s.nextval,
2730: crh_gl_date,
2731: crh_trx_date,
2732: payment_server_order_num,
2733: approval_code,

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

2938:
2939: END IF;
2940:
2941:
2942: /* the first update into ar_cash_receipt_history */
2943:
2944: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2945: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2946: reversal_gl_date = :ucrh_gl_date_array,

Line 2944: upd_stmt1 := ' UPDATE ar_cash_receipt_history

2940:
2941:
2942: /* the first update into ar_cash_receipt_history */
2943:
2944: upd_stmt1 := ' UPDATE ar_cash_receipt_history
2945: SET reversal_cash_receipt_hist_id = :ucrh_id_array,
2946: reversal_gl_date = :ucrh_gl_date_array,
2947: reversal_created_from = ''ARZARM'',
2948: current_record_flag = NULL,

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

3006:
3007: END IF;
3008:
3009:
3010: /* the first update into ar_cash_receipt_history */
3011:
3012: ins_crh1 := 'INSERT into ar_cash_receipt_history
3013: (cash_receipt_history_id,
3014: cash_receipt_id,

Line 3012: ins_crh1 := 'INSERT into ar_cash_receipt_history

3008:
3009:
3010: /* the first update into ar_cash_receipt_history */
3011:
3012: ins_crh1 := 'INSERT into ar_cash_receipt_history
3013: (cash_receipt_history_id,
3014: cash_receipt_id,
3015: status,
3016: trx_date,

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

3196:
3197: END IF;
3198:
3199:
3200: /* the first update into ar_cash_receipt_history */
3201:
3202: ins_dist1 := 'INSERT into ar_distributions
3203: (line_id,
3204: source_id,

Line 3278: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,

3274: sysdate,
3275: :i_last_updated_by,
3276: :i_org_id,
3277: :i_last_update_login
3278: FROM ar_cash_receipt_history crh,AR_REMIT_GT r,
3279: ar_lookups l
3280: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3281: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3282: AND l.lookup_code IN (''1'',''2'')';

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

3444: ELSE
3445: ins_stmt := 'insert /*+ append */ into ar_rem_cr_id_gtt gtt ';
3446: END IF;
3447:
3448: ins_stmt := ins_stmt ||' select /*+ index(crh AR_CASH_RECEIPT_HISTORY_N6) */
3449: CASH_RECEIPT_HISTORY_ID,
3450: cash_receipt_id
3451: from ar_cash_receipt_history crh
3452: where crh.status = ''CONFIRMED'' AND

Line 3451: from ar_cash_receipt_history crh

3447:
3448: ins_stmt := ins_stmt ||' select /*+ index(crh AR_CASH_RECEIPT_HISTORY_N6) */
3449: CASH_RECEIPT_HISTORY_ID,
3450: cash_receipt_id
3451: from ar_cash_receipt_history crh
3452: where crh.status = ''CONFIRMED'' AND
3453: crh.current_record_flag = ''Y'' ';
3454:
3455: commit;

Line 3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,

3486: if(pg_execution_from = 'PARALLEL') then
3487: l_sel_stmt := l_sel_stmt || ' ar_rem_cr_id_gtt crh, ';
3488: end if;
3489:
3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,
3491: ar_cash_receipts cr,
3492: ar_payment_schedules ps,
3493: ar_receipt_classes rclass,
3494: ar_receipt_methods rm,

Line 5769: ar_cash_receipt_history crh,

5765: program_update_date = sysdate
5766: WHERE cash_receipt_id in (
5767: SELECT cr.cash_receipt_id
5768: FROM ar_cash_receipts cr,
5769: ar_cash_receipt_history crh,
5770: iby_trxn_extensions_v trxn_ext
5771: WHERE crh.request_id = l_request_id
5772: AND crh.status = 'REMITTED'
5773: AND crh.current_record_flag = 'Y'

Line 5821: ar_cash_receipt_history crh,

5817: l_program_application_id,
5818: l_program_id,
5819: sysdate
5820: FROM ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: iby_trxn_extensions_v trxn_ext
5823: WHERE crh.request_id = l_request_id
5824: AND crh.status = 'REMITTED'
5825: AND crh.current_record_flag = 'Y'

Line 5850: ar_cash_receipt_history crh,

5846: program_update_date = sysdate
5847: WHERE cash_receipt_id in (
5848: SELECT cr.cash_receipt_id
5849: FROM ar_cash_receipts cr,
5850: ar_cash_receipt_history crh,
5851: iby_trxn_extensions_v trxn_ext
5852: WHERE crh.request_id = l_request_id
5853: AND crh.status = 'REMITTED'
5854: AND crh.current_record_flag = 'Y'

Line 5902: ar_cash_receipt_history crh,

5898: l_program_application_id,
5899: l_program_id,
5900: sysdate
5901: FROM ar_cash_receipts cr,
5902: ar_cash_receipt_history crh,
5903: iby_trxn_extensions_v trxn_ext
5904: WHERE crh.request_id = l_request_id
5905: AND crh.status = 'REMITTED'
5906: AND crh.current_record_flag = 'Y'

Line 5949: ar_cash_receipt_history crh,

5945: SET cc_error_flag = null
5946: WHERE cash_receipt_id in (
5947: SELECT cr.cash_receipt_id
5948: FROM ar_cash_receipts cr,
5949: ar_cash_receipt_history crh,
5950: iby_trxn_extensions_v trxn_ext
5951: WHERE cr.request_id = p_request_id
5952: AND cr.cc_error_flag = 'Y'
5953: AND cr.type = 'CASH'

Line 5976: ar_cash_receipt_history crh,

5972: SET cc_error_flag = null
5973: WHERE cash_receipt_id in (
5974: SELECT cr.cash_receipt_id
5975: FROM ar_cash_receipts cr,
5976: ar_cash_receipt_history crh,
5977: iby_trxn_extensions_v trxn_ext
5978: WHERE cr.request_id = p_request_id
5979: AND cr.cc_error_flag = 'Y'
5980: AND cr.type = 'MISC'

Line 6009: UPDATE ar_cash_receipt_history

6005: fnd_file.put_line(FND_FILE.LOG,' rows updated CR = ' || SQL%ROWCOUNT );
6006: END IF;
6007:
6008:
6009: UPDATE ar_cash_receipt_history
6010: SET reversal_cash_receipt_hist_id = null,
6011: reversal_gl_date = null,
6012: reversal_created_from = null,
6013: current_record_flag = 'Y'

Line 6028: from ar_cash_receipt_history crh,

6024:
6025: delete from ar_distributions
6026: where source_table = 'CRH'
6027: and source_id in ( select crh.cash_receipt_history_id
6028: from ar_cash_receipt_history crh,
6029: ar_cash_receipts cr
6030: where crh.STATUS = 'REMITTED'
6031: and crh.request_id = p_request_id
6032: and cr.cash_receipt_id = crh.cash_receipt_id

Line 6040: delete from ar_cash_receipt_history

6036: IF PG_DEBUG in ('Y','C') THEN
6037: fnd_file.put_line(FND_FILE.LOG,' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
6038: END IF;
6039:
6040: delete from ar_cash_receipt_history
6041: where STATUS = 'REMITTED'
6042: and request_id = p_request_id
6043: and cash_receipt_id in ( select cash_receipt_id
6044: from ar_cash_receipts

Line 6136: FROM ar_cash_receipt_history crh,

6132: AND ra.posting_control_id = -3
6133: AND ra.event_id = xe.event_id
6134: UNION
6135: SELECT 'x'
6136: FROM ar_cash_receipt_history crh,
6137: ar_distributions dis
6138: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6139: AND dis.source_id = crh.cash_receipt_history_id
6140: AND dis.source_table = 'CRH'