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_MAINTAIN_PS dependencies on RA_CUSTOMER_TRX

Line 221: ra_customer_trx ct_init,

217: p_control_rec.initial_customer_trx_id,
218: p_control_rec.initial_trx_type
219: FROM
220: ra_cust_trx_types ctt_init,
221: ra_customer_trx ct_init,
222: ra_cust_trx_types ctt,
223: ra_customer_trx ct
224: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
225: and ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 223: ra_customer_trx ct

219: FROM
220: ra_cust_trx_types ctt_init,
221: ra_customer_trx ct_init,
222: ra_cust_trx_types ctt,
223: ra_customer_trx ct
224: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
225: and ct.cust_trx_type_id = ctt.cust_trx_type_id
226: and ct.initial_customer_trx_id = ct_init.customer_trx_id(+)
227: and ct_init.cust_trx_type_id = ctt_init.cust_trx_type_id(+);

Line 272: ra_customer_trx ct,

268: INTO
269: p_control_rec.initial_customer_trx_id,
270: p_control_rec.initial_trx_type
271: FROM
272: ra_customer_trx ct,
273: ra_customer_trx ct_prev,
274: ra_customer_trx ct_init,
275: ra_cust_trx_types ctt_init
276: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id

Line 273: ra_customer_trx ct_prev,

269: p_control_rec.initial_customer_trx_id,
270: p_control_rec.initial_trx_type
271: FROM
272: ra_customer_trx ct,
273: ra_customer_trx ct_prev,
274: ra_customer_trx ct_init,
275: ra_cust_trx_types ctt_init
276: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
277: and ct.previous_customer_trx_id = ct_prev.customer_trx_id

Line 274: ra_customer_trx ct_init,

270: p_control_rec.initial_trx_type
271: FROM
272: ra_customer_trx ct,
273: ra_customer_trx ct_prev,
274: ra_customer_trx ct_init,
275: ra_cust_trx_types ctt_init
276: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
277: and ct.previous_customer_trx_id = ct_prev.customer_trx_id
278: and ct_prev.initial_customer_trx_id = ct_init.customer_trx_id(+)

Line 427: ra_customer_trx ct,

423: ct.set_of_books_id,
424: ct.trx_date,
425: rt.name
426: FROM
427: ra_customer_trx ct,
428: ar_receivables_trx rt
429: WHERE rt.receivables_trx_id = -1
430: and ct.customer_trx_id = :customer_trx_id';
431:

Line 1024: WHERE ra.customer_trx_id = p_customer_trx_id

1020:
1021: --Now delete parent application record
1022: DELETE
1023: FROM ar_receivable_applications ra
1024: WHERE ra.customer_trx_id = p_customer_trx_id
1025: RETURNING receivable_application_id
1026: BULK COLLECT INTO l_rec_app_key_value_list;
1027:
1028: debug( SQL%ROWCOUNT||' row(s) deleted', MSG_LEVEL_DEBUG );

Line 1430: WHERE ra.customer_trx_id = p_customer_trx_id

1426: ar_receivable_applications ra,
1427: ar_payment_schedules ps2,
1428: ar_adjustments adj2,
1429: ar_receivable_applications ra2
1430: WHERE ra.customer_trx_id = p_customer_trx_id
1431: and ra.status||'' = 'APP'
1432: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
1433: and ps2.payment_schedule_id =ps.payment_schedule_id
1434: and ps2.payment_schedule_id = adj2.payment_schedule_id(+)

Line 1762: WHERE ra.customer_trx_id = p_control.customer_trx_id

1758: ar_receivable_applications ra,
1759: ar_payment_schedules ps2,
1760: ar_receivable_applications ra2,
1761: ar_adjustments adj2
1762: WHERE ra.customer_trx_id = p_control.customer_trx_id
1763: and ra.status||'' = 'APP'
1764: and ra.reversal_gl_date IS NULL
1765: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
1766: and ps.payment_schedule_id = ps2.payment_schedule_id

Line 1899: and ra.customer_trx_id = p_control.customer_trx_id

1895: last_updated_by = p_profile_info.user_id,
1896: last_update_date = trunc(sysdate),
1897: last_update_login = p_profile_info.conc_login_id
1898: WHERE ra.applied_payment_schedule_id = p_control.payment_schedule_id
1899: and ra.customer_trx_id = p_control.customer_trx_id
1900: and ra.reversal_gl_date IS NULL
1901: and ra.receivable_application_id = old_rec_app.receivable_application_id;
1902:
1903: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );

Line 2465: ra_customer_trx ct

2461: ,arp_standard.sysparm.org_id /* SSA changes anuj */
2462: FROM
2463: ar_adjustments adj2,
2464: ar_receivable_applications ra,
2465: ra_customer_trx ct
2466: WHERE adj2.receivables_trx_id= -1
2467: and adj2.customer_trx_id = p_control.previous_customer_trx_id
2468: and adj2.subsequent_trx_id = p_control.customer_trx_id
2469: and ra.customer_trx_id = adj2.subsequent_trx_id

Line 2469: and ra.customer_trx_id = adj2.subsequent_trx_id

2465: ra_customer_trx ct
2466: WHERE adj2.receivables_trx_id= -1
2467: and adj2.customer_trx_id = p_control.previous_customer_trx_id
2468: and adj2.subsequent_trx_id = p_control.customer_trx_id
2469: and ra.customer_trx_id = adj2.subsequent_trx_id
2470: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2471: and ct.customer_trx_id = ra.applied_customer_trx_id
2472: and adj2.payment_schedule_id =
2473: (

Line 2595: ra_customer_trx ct

2591: trunc(sysdate),
2592: p_profile_info.conc_login_id
2593: FROM
2594: ar_receivable_applications ra,
2595: ra_customer_trx ct
2596: WHERE ra.customer_trx_id = p_control.customer_trx_id
2597: and ra.status||'' = 'APP'
2598: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2599: and ct.customer_trx_id = ra.applied_customer_trx_id

Line 2596: WHERE ra.customer_trx_id = p_control.customer_trx_id

2592: p_profile_info.conc_login_id
2593: FROM
2594: ar_receivable_applications ra,
2595: ra_customer_trx ct
2596: WHERE ra.customer_trx_id = p_control.customer_trx_id
2597: and ra.status||'' = 'APP'
2598: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2599: and ct.customer_trx_id = ra.applied_customer_trx_id
2600: )

Line 2743: WHERE ra.customer_trx_id = p_control.customer_trx_id

2739: ar_receivable_applications ra,
2740: ar_payment_schedules ps2,
2741: ar_receivable_applications ra2,
2742: ar_adjustments adj2
2743: WHERE ra.customer_trx_id = p_control.customer_trx_id
2744: and ra.status||'' = 'APP'
2745: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
2746: and ps.payment_schedule_id = ps2.payment_schedule_id
2747: and ps2.payment_schedule_id = adj2.payment_schedule_id(+)

Line 2863: and ra.customer_trx_id = p_control.customer_trx_id;

2859: last_update_date = trunc(sysdate),
2860: last_update_login = p_profile_info.conc_login_id
2861: WHERE ra.applied_payment_schedule_id = p_control.payment_schedule_id
2862: and ra.status||'' = 'APP'
2863: and ra.customer_trx_id = p_control.customer_trx_id;
2864:
2865: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );
2866:
2867: FOR l_app_id in get_app_id

Line 3121: l_customer_trx ra_customer_trx%ROWTYPE;

3117: /* VAT changes */
3118: l_ae_doc_rec ae_doc_rec_type;
3119: l_adjustment_id ar_adjustments.adjustment_id%type;
3120: l_llca_count NUMBER;
3121: l_customer_trx ra_customer_trx%ROWTYPE;
3122: BEGIN
3123:
3124: print_fcn_label( 'arp_maintain_ps.maintain_payment_schedules()+' );
3125:

Line 3399: from ra_customer_trx_lines

3395: /* 11825040 - Clean up line level balances if required */
3396: arp_standard.debug(' clean up line level balances');
3397: select count(*)
3398: into l_llca_count
3399: from ra_customer_trx_lines
3400: where customer_trx_id = l_control_rec.previous_customer_trx_id
3401: and line_type = 'LINE'
3402: and amount_due_remaining is not null;
3403: