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_PURGE dependencies on AR_PAYMENT_SCHEDULES

Line 2287: ar_payment_schedules ps,

2283: to_number(null), /* expiration_days */
2284: '' /* override_auto_accounting_flag */
2285: FROM
2286: ra_cust_trx_types ctt,
2287: ar_payment_schedules ps,
2288: ar_cash_receipts cr,
2289: ar_receivable_applications ra,
2290: ra_customer_trx ct
2291: WHERE ctt.cust_trx_type_id = ct.cust_trx_type_id

Line 2958: from ar_payment_schedules ps

2954: FOR UPDATE OF ra.customer_trx_id NOWAIT;
2955:
2956: cursor pay_sched_cur is
2957: SELECT 'Found' record_found
2958: from ar_payment_schedules ps
2959: WHERE ps.customer_trx_id = p_entity_id
2960: FOR UPDATE OF ps.customer_trx_id NOWAIT;
2961:
2962: BEGIN

Line 2970: ar_payment_schedules ps,

2966: FOR lock_rec IN (
2967: SELECT 'Found' record_found
2968: FROM ra_cust_trx_line_salesreps sales,
2969: ar_receivable_applications ra,
2970: ar_payment_schedules ps,
2971: ar_adjustments adj,
2972: ra_cust_trx_line_gl_dist dist,
2973: ra_customer_trx_lines lines,
2974: ra_customer_trx trx

Line 3237: FROM ar_payment_schedules

3233: l_invoice_open_amount NUMBER;
3234: BEGIN
3235: SELECT NVL(SUM(ABS(amount_due_remaining)),0)
3236: INTO l_invoice_open_amount
3237: FROM ar_payment_schedules
3238: WHERE customer_trx_id = p_entity_id;
3239: --
3240: IF l_invoice_open_amount > 0 THEN
3241: print( p_recursive_level, ' ...payment schedule is not closed' );

Line 3589: FROM ar_payment_schedules ps,

3585: SET corr.purged_children_flag = 'Y'
3586: WHERE corr.correspondence_id IN
3587: (
3588: SELECT sched.correspondence_id
3589: FROM ar_payment_schedules ps,
3590: ar_correspondence_pay_sched sched
3591: WHERE ps.customer_trx_id = p_entity_id
3592: AND ps.payment_schedule_id =
3593: sched.payment_schedule_id

Line 3602: FROM ar_payment_schedules

3598: DELETE FROM ar_correspondence_pay_sched sched
3599: WHERE payment_schedule_id IN
3600: (
3601: SELECT payment_schedule_id
3602: FROM ar_payment_schedules
3603: WHERE customer_trx_id = p_entity_id
3604: )
3605: RETURNING correspondence_id BULK COLLECT INTO del_cid ;
3606: --

Line 3613: ar_payment_schedules ps

3609: WHERE corr.correspondence_id NOT IN
3610: (
3611: SELECT sched.correspondence_id
3612: FROM ar_correspondence_pay_sched sched,
3613: ar_payment_schedules ps
3614: WHERE ps.customer_trx_id = p_entity_id
3615: AND ps.payment_schedule_id =
3616: sched.payment_schedule_id
3617: ) ;

Line 3633: DELETE FROM ar_payment_schedules

3629: WHERE corr.correspondence_id = sched.correspondence_id )
3630: AND corr.correspondence_id = del_cid(l_corr_row) ;
3631: END IF;
3632: --
3633: DELETE FROM ar_payment_schedules
3634: WHERE customer_trx_id = p_entity_id
3635: RETURNING payment_schedule_id
3636: BULK COLLECT INTO l_ar_ps_key_value_list;
3637:

Line 3645: p_table_name => 'AR_PAYMENT_SCHEDULES',

3641: +---------------------------------*/
3642:
3643: /* ar_mrc_engine.maintain_mrc_data(
3644: p_event_mode => 'DELETE',
3645: p_table_name => 'AR_PAYMENT_SCHEDULES',
3646: p_mode => 'BATCH',
3647: p_key_value_list => l_ar_ps_key_value_list);*/
3648:
3649: --

Line 3873: FROM ar_payment_schedules ps

3869: dist.source_id NOWAIT;
3870:
3871: cursor ps_cur is
3872: select 'Found' record_found
3873: FROM ar_payment_schedules ps
3874: where ps.cash_receipt_id = p_entity_id
3875: FOR UPDATE OF ps.cash_receipt_id NOWAIT;
3876:
3877: cursor ra_cur is

Line 3896: ar_payment_schedules ps,

3892: some stmts. This cursor for loop is not used .
3893: FOR lock_rec IN (
3894: SELECT 'Found' record_found
3895: FROM ar_distributions dist,
3896: ar_payment_schedules ps,
3897: ar_receivable_applications ra,
3898: ar_cash_receipt_history crh,
3899: ar_cash_receipts cr
3900: WHERE cr.cash_receipt_id = p_entity_id

Line 3988: FROM ar_payment_schedules

3984: l_ps_status VARCHAR2(2);
3985: BEGIN
3986: SELECT status
3987: INTO l_ps_status
3988: FROM ar_payment_schedules
3989: WHERE cash_receipt_id = p_entity_id
3990: FOR UPDATE OF payment_schedule_id NOWAIT ;
3991:
3992: IF l_ps_status = 'OP' THEN

Line 4230: DELETE FROM ar_payment_schedules

4226: END IF;
4227: END IF;
4228:
4229: --
4230: DELETE FROM ar_payment_schedules
4231: WHERE cash_receipt_id = p_entity_id
4232: RETURNING payment_schedule_id
4233: BULK COLLECT INTO l_ar_ps_key_value_list;
4234:

Line 4242: p_table_name => 'AR_PAYMENT_SCHEDULES',

4238: +---------------------------------*/
4239:
4240: /* ar_mrc_engine.maintain_mrc_data(
4241: p_event_mode => 'DELETE',
4242: p_table_name => 'AR_PAYMENT_SCHEDULES',
4243: p_mode => 'BATCH',
4244: p_key_value_list => l_ar_ps_key_value_list);*/
4245:
4246: --

Line 4492: -- so that it drives from AR_PAYMENT_SCHEDULES.

4488: p_short_flag IN VARCHAR2) IS
4489: --
4490: -- Earlier, it was driven from RA_CUST_TRX_LINE_GL_DIST
4491: -- To improve the performance, the code is changed
4492: -- so that it drives from AR_PAYMENT_SCHEDULES.
4493: -- This will not handle the cases where the
4494: -- open_receivable flag for the transaction_type is set
4495: -- to 'N'. This is the intended behaviour to improve
4496: -- the performance.

Line 4505: ar_payment_schedules ps

4501: cp_max_trx_id NUMBER) IS
4502: SELECT ct.customer_trx_id customer_trx_id
4503: FROM ra_cust_trx_types ctt,
4504: ra_customer_trx ct,
4505: ar_payment_schedules ps
4506: WHERE ct.initial_customer_trx_id IS NULL
4507: AND ps.customer_trx_id = ct.customer_trx_id
4508: -- bug1199027
4509: AND ps.gl_date_closed BETWEEN cp_start_gl_date