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

Line 88: update ar_cash_receipt_history SET

84: IF PG_DEBUG in ('Y','C') THEN
85: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
86: END IF;
87:
88: update ar_cash_receipt_history SET
89: batch_id = p_batch_id,
90: created_by = pg_created_by,
91: last_update_date = sysdate,
92: last_updated_by = pg_created_by,

Line 403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

399:
400: l_current_worker_number NUMBER;
401: l_total_workers NUMBER;
402: l_request_id ar_cash_receipts.request_id%TYPE;
403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;

986: l_worker_number NUMBER ;
987: l_complete BOOLEAN := FALSE;
988:
989: l_request_id ar_cash_receipts.request_id%TYPE;
990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

1368: *=========================================================================*/
1369:
1370:
1371: PROCEDURE insert_batch(
1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

Line 2339: ar_cash_receipt_history crh,

2335: (
2336: SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ r.customer_trx_id
2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,
2341: iby_trxn_summaries_all summ
2342: WHERE r.gt_id = p_gt_id
2343: AND cr.cash_receipt_id = r.cash_receipt_id

Line 2371: ar_cash_receipt_history crh,

2367: where cash_receipt_id in
2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,
2373: iby_trxn_summaries_all summ
2374: WHERE r.gt_id = p_gt_id
2375: AND cr.cash_receipt_id = r.cash_receipt_id

Line 2617: from ar_cash_receipt_history

2613: from ar_distributions
2614: where source_table = 'CRH'
2615: and source_id in
2616: ( select cash_receipt_history_id
2617: from ar_cash_receipt_history
2618: where cash_receipt_id in
2619: ( select distinct ex.cash_receipt_id
2620: from ar_autorec_exceptions ex,
2621: ar_receipts_gt r

Line 2664: from ar_cash_receipt_history

2660: arp_debug.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
2661: END IF;
2662:
2663: delete
2664: from ar_cash_receipt_history
2665: where cash_receipt_id in
2666: ( select distinct ex.cash_receipt_id
2667: from ar_autorec_exceptions ex,
2668: ar_receipts_gt r

Line 2772: FROM ar_cash_receipt_history crh,

2768: UPDATE ar_cash_receipts
2769: SET seq_type_last = 'Y'
2770: WHERE cash_receipt_id IN (
2771: SELECT crh.cash_receipt_id
2772: FROM ar_cash_receipt_history crh,
2773: ar_receivable_applications ra,
2774: ra_customer_trx ct,
2775: iby_fndcpt_tx_extensions ext
2776: WHERE crh.batch_id = p_batch_id

Line 3337: from ar_cash_receipt_history crh,

3333: ct.customer_trx_id,
3334: cr.cash_receipt_id,
3335: ps.amount_due_remaining,
3336: -1 gt_id
3337: from ar_cash_receipt_history crh,
3338: ar_cash_receipts cr,
3339: ar_payment_schedules ps,
3340: ra_customer_trx ct,
3341: iby_fndcpt_tx_xe_copies cp

Line 3398: from ar_cash_receipt_history crh,

3394: ct.customer_trx_id,
3395: cr.cash_receipt_id,
3396: ps.amount_due_remaining,
3397: -1 gt_id
3398: from ar_cash_receipt_history crh,
3399: ar_cash_receipts cr,
3400: ar_payment_schedules ps,
3401: ra_customer_trx ct
3402: where crh.batch_id = :p_batch_id

Line 3452: from ar_cash_receipt_history crh,

3448: ct.customer_trx_id,
3449: cr.cash_receipt_id,
3450: ps.amount_due_remaining,
3451: -1 gt_id
3452: from ar_cash_receipt_history crh,
3453: ar_cash_receipts cr,
3454: ar_payment_schedules ps,
3455: ra_customer_trx ct
3456: where crh.batch_id = :p_batch_id

Line 3519: from ar_cash_receipt_history crh,

3515: RANK( ) OVER (PARTITION BY cr.cash_receipt_id
3516: ORDER BY ps.customer_trx_id, cr.amount) rct_rank,
3517: RANK( ) OVER (PARTITION BY ps.customer_trx_id
3518: ORDER BY cr.cash_receipt_id, cr.amount) inv_rank
3519: from ar_cash_receipt_history crh,
3520: ar_cash_receipts cr,
3521: ( SELECT ps.payment_schedule_id,
3522: ps.selected_for_receipt_batch_id,
3523: ct.bill_to_customer_id,

Line 3601: from ar_cash_receipt_history crh,

3597: RANK( ) OVER (PARTITION BY cr.cash_receipt_id
3598: ORDER BY ps.customer_trx_id, cr.amount) rct_rank,
3599: RANK( ) OVER (PARTITION BY ps.customer_trx_id
3600: ORDER BY cr.cash_receipt_id, cr.amount) inv_rank
3601: from ar_cash_receipt_history crh,
3602: ar_cash_receipts cr,
3603: ( SELECT ps.payment_schedule_id,
3604: ps.selected_for_receipt_batch_id,
3605: ct.bill_to_customer_id,

Line 4042: ar_cash_receipt_history crh,

4038: ot.receivables_charges_remaining rec_charges_remaining,
4039: ot.location location,
4040: rgt.amount_due_remaining amount_apply
4041: FROM ar_cash_receipts cr,
4042: ar_cash_receipt_history crh,
4043: ar_payment_schedules ps,
4044: ra_cust_trx_types ctt,
4045: ar_payment_schedules inv_ps,
4046: ar_receipt_method_accounts rma,

Line 4461: UPDATE ar_cash_receipt_history

4457:
4458: /* need to stamp the batch_id immediately inorder to succesfully execute the reapproval
4459: process in case the program gets errored/terminated before the receipt is processed
4460: completely */
4461: UPDATE ar_cash_receipt_history
4462: SET batch_id = p_batch_id,
4463: created_by = pg_created_by,
4464: last_update_date = sysdate,
4465: last_updated_by = pg_created_by,

Line 4537: from ar_cash_receipt_history

4533: delete from ar_distributions
4534: where source_table = 'CRH'
4535: and source_id in
4536: ( select cash_receipt_history_id
4537: from ar_cash_receipt_history
4538: where cash_receipt_id = l_receipt_id_array(j));
4539:
4540: IF PG_DEBUG in ('Y','C') THEN
4541: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );

Line 4562: delete from ar_cash_receipt_history

4558: IF PG_DEBUG in ('Y','C') THEN
4559: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
4560: END IF;
4561:
4562: delete from ar_cash_receipt_history
4563: where cash_receipt_id = l_receipt_id_array(j);
4564:
4565: IF PG_DEBUG in ('Y','C') THEN
4566: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );

Line 5195: ar_cash_receipt_history crh,

5191: (
5192: SELECT /*+ push_pred(trxn_ext) */ r.customer_trx_id
5193: FROM ar_receipts_gt r,
5194: ar_cash_receipts cr,
5195: ar_cash_receipt_history crh,
5196: (SELECT op.trxn_extension_id, summ.status
5197: FROM iby_trxn_summaries_all summ,
5198: iby_fndcpt_tx_operations op
5199: WHERE(summ.transactionid = op.transactionid)

Line 5255: ar_cash_receipt_history crh,

5251: pg_program_id,
5252: sysdate
5253: FROM ar_receipts_gt r,
5254: ar_cash_receipts cr,
5255: ar_cash_receipt_history crh,
5256: (SELECT op.trxn_extension_id, summ.status
5257: FROM iby_trxn_summaries_all summ,
5258: iby_fndcpt_tx_operations op
5259: WHERE(summ.transactionid = op.transactionid)