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 1382: WHERE ra.customer_trx_id = p_customer_trx_id

1378: ar_receivable_applications ra,
1379: ar_payment_schedules ps2,
1380: ar_adjustments adj2,
1381: ar_receivable_applications ra2
1382: WHERE ra.customer_trx_id = p_customer_trx_id
1383: and ra.status||'' = 'APP'
1384: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
1385: and ps2.payment_schedule_id =ps.payment_schedule_id
1386: and ps2.payment_schedule_id = adj2.payment_schedule_id(+)

Line 1714: WHERE ra.customer_trx_id = p_control.customer_trx_id

1710: ar_receivable_applications ra,
1711: ar_payment_schedules ps2,
1712: ar_receivable_applications ra2,
1713: ar_adjustments adj2
1714: WHERE ra.customer_trx_id = p_control.customer_trx_id
1715: and ra.status||'' = 'APP'
1716: and ra.reversal_gl_date IS NULL
1717: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
1718: and ps.payment_schedule_id = ps2.payment_schedule_id

Line 1851: and ra.customer_trx_id = p_control.customer_trx_id

1847: last_updated_by = p_profile_info.user_id,
1848: last_update_date = trunc(sysdate),
1849: last_update_login = p_profile_info.conc_login_id
1850: WHERE ra.applied_payment_schedule_id = p_control.payment_schedule_id
1851: and ra.customer_trx_id = p_control.customer_trx_id
1852: and ra.reversal_gl_date IS NULL
1853: and ra.receivable_application_id = old_rec_app.receivable_application_id;
1854:
1855: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );

Line 2417: ra_customer_trx ct

2413: ,arp_standard.sysparm.org_id /* SSA changes anuj */
2414: FROM
2415: ar_adjustments adj2,
2416: ar_receivable_applications ra,
2417: ra_customer_trx ct
2418: WHERE adj2.receivables_trx_id= -1
2419: and adj2.customer_trx_id = p_control.previous_customer_trx_id
2420: and adj2.subsequent_trx_id = p_control.customer_trx_id
2421: and ra.customer_trx_id = adj2.subsequent_trx_id

Line 2421: and ra.customer_trx_id = adj2.subsequent_trx_id

2417: ra_customer_trx ct
2418: WHERE adj2.receivables_trx_id= -1
2419: and adj2.customer_trx_id = p_control.previous_customer_trx_id
2420: and adj2.subsequent_trx_id = p_control.customer_trx_id
2421: and ra.customer_trx_id = adj2.subsequent_trx_id
2422: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2423: and ct.customer_trx_id = ra.applied_customer_trx_id
2424: and adj2.payment_schedule_id =
2425: (

Line 2547: ra_customer_trx ct

2543: trunc(sysdate),
2544: p_profile_info.conc_login_id
2545: FROM
2546: ar_receivable_applications ra,
2547: ra_customer_trx ct
2548: WHERE ra.customer_trx_id = p_control.customer_trx_id
2549: and ra.status||'' = 'APP'
2550: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2551: and ct.customer_trx_id = ra.applied_customer_trx_id

Line 2548: WHERE ra.customer_trx_id = p_control.customer_trx_id

2544: p_profile_info.conc_login_id
2545: FROM
2546: ar_receivable_applications ra,
2547: ra_customer_trx ct
2548: WHERE ra.customer_trx_id = p_control.customer_trx_id
2549: and ra.status||'' = 'APP'
2550: and ra.applied_payment_schedule_id = p_control.payment_schedule_id
2551: and ct.customer_trx_id = ra.applied_customer_trx_id
2552: )

Line 2695: WHERE ra.customer_trx_id = p_control.customer_trx_id

2691: ar_receivable_applications ra,
2692: ar_payment_schedules ps2,
2693: ar_receivable_applications ra2,
2694: ar_adjustments adj2
2695: WHERE ra.customer_trx_id = p_control.customer_trx_id
2696: and ra.status||'' = 'APP'
2697: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
2698: and ps.payment_schedule_id = ps2.payment_schedule_id
2699: and ps2.payment_schedule_id = adj2.payment_schedule_id(+)

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

2811: last_update_date = trunc(sysdate),
2812: last_update_login = p_profile_info.conc_login_id
2813: WHERE ra.applied_payment_schedule_id = p_control.payment_schedule_id
2814: and ra.status||'' = 'APP'
2815: and ra.customer_trx_id = p_control.customer_trx_id;
2816:
2817: debug( SQL%ROWCOUNT||' row(s) updated', MSG_LEVEL_DEBUG );
2818:
2819: FOR l_app_id in get_app_id