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_REVENUE_MANAGEMENT_PVT dependencies on AR_LINE_CONTS_ALL

Line 71: INSERT INTO ar_line_conts_all

67: /* This is either invoice API or autoinvoice */
68: IF (g_source = 'AR_INVOICE_API')
69: THEN
70:
71: INSERT INTO ar_line_conts_all
72: (
73: customer_trx_line_id,
74: contingency_id,
75: contingency_code,

Line 134: FROM ar_line_conts_all alc

130: AND teg.trx_line_id = tlg.trx_line_id
131: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
132: AND NOT EXISTS
133: (SELECT 'prevent duplicate contingency'
134: FROM ar_line_conts_all alc
135: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
136: AND alc.contingency_id = 5)
137: GROUP BY ctl.customer_trx_line_id, tl.term_id
138: HAVING max(due_days) > arp_standard.sysparm.payment_threshold;

Line 141: INSERT INTO ar_line_conts_all

137: GROUP BY ctl.customer_trx_line_id, tl.term_id
138: HAVING max(due_days) > arp_standard.sysparm.payment_threshold;
139:
140: ELSE /* Autoinvoice */
141: INSERT INTO ar_line_conts_all
142: (
143: customer_trx_line_id,
144: contingency_id,
145: contingency_code,

Line 201: FROM ar_line_conts_all alc

197: FROM ra_interface_errors_all ie
198: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
199: AND NOT EXISTS
200: (SELECT 'prevent duplicate contingency'
201: FROM ar_line_conts_all alc
202: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
203: AND alc.contingency_id = 5)
204: GROUP BY ctl.customer_trx_line_id, tl.term_id
205: HAVING max(due_days) > arp_standard.sysparm.payment_threshold;

Line 208: INSERT INTO ar_line_conts_all

204: GROUP BY ctl.customer_trx_line_id, tl.term_id
205: HAVING max(due_days) > arp_standard.sysparm.payment_threshold;
206: END IF;
207: ELSE /* Manual transaction */
208: INSERT INTO ar_line_conts_all
209: (
210: customer_trx_line_id,
211: contingency_id,
212: contingency_code,

Line 264: FROM ar_line_conts_all alc

260: AND ct.term_id = tl.term_id
261: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
262: AND NOT EXISTS
263: (SELECT 'prevent duplicate contingency'
264: FROM ar_line_conts_all alc
265: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
266: AND alc.contingency_id = 5)
267: GROUP BY ctl.customer_trx_line_id, ctl.org_id,tl.term_id
268: HAVING max(tl.due_days) > arp_standard.sysparm.payment_threshold;

Line 307: INSERT INTO ar_line_conts_all

303: /* This is either invoice API or autoinvoice */
304: IF (g_source = 'AR_INVOICE_API')
305: THEN
306:
307: INSERT INTO ar_line_conts_all
308: (
309: customer_trx_line_id,
310: contingency_id,
311: contingency_code,

Line 370: FROM ar_line_conts_all alc

366: AND teg.trx_line_id = tlg.trx_line_id
367: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
368: AND NOT EXISTS
369: (SELECT 'prevent duplicate contingency'
370: FROM ar_line_conts_all alc
371: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
372: AND alc.contingency_id = 3);
373:
374: ELSE /* Autoinvoice */

Line 375: INSERT INTO ar_line_conts_all

371: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
372: AND alc.contingency_id = 3);
373:
374: ELSE /* Autoinvoice */
375: INSERT INTO ar_line_conts_all
376: (
377: customer_trx_line_id,
378: contingency_id,
379: contingency_code,

Line 435: FROM ar_line_conts_all alc

431: FROM ra_interface_errors_all ie
432: WHERE ie.interface_line_id = ctl.customer_trx_line_id)
433: AND NOT EXISTS
434: (SELECT 'prevent duplicate contingency'
435: FROM ar_line_conts_all alc
436: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
437: AND alc.contingency_id = 3);
438: END IF;
439: ELSE /* Manual transaction */

Line 440: INSERT INTO ar_line_conts_all

436: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
437: AND alc.contingency_id = 3);
438: END IF;
439: ELSE /* Manual transaction */
440: INSERT INTO ar_line_conts_all
441: (
442: customer_trx_line_id,
443: contingency_id,
444: contingency_code,

Line 496: FROM ar_line_conts_all alc

492: AND ar_revenue_management_pvt.creditworthy
493: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
494: AND NOT EXISTS
495: (SELECT 'prevent duplicate contingency'
496: FROM ar_line_conts_all alc
497: WHERE alc.customer_trx_line_id = ctl.customer_trx_line_id
498: AND alc.contingency_id = 3);
499: END IF;
500:

Line 2462: FROM ar_line_conts_all lc

2458: SET line_collectible_flag = 'Y'
2459: WHERE dl.request_id = p_request_id
2460: AND NOT EXISTS
2461: (SELECT 'incomplete contingency'
2462: FROM ar_line_conts_all lc
2463: WHERE request_id = p_request_id
2464: AND lc.customer_trx_line_id = dl.customer_trx_line_id
2465: AND lc.completed_flag = 'N');
2466:

Line 2474: ar_line_conts_all lrc,

2470: WHERE dl.request_id = p_request_id
2471: and dl.customer_trx_id in
2472: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2473: FROM ra_customer_trx_lines_all ctl,
2474: ar_line_conts_all lrc,
2475: ar_deferral_reasons dr
2476: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2477: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
2478: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0

Line 2489: FROM ar_line_conts_all lc

2485: SET line_collectible_flag = 'Y'
2486: WHERE dl.customer_trx_line_id = p_customer_trx_line_id
2487: AND NOT EXISTS
2488: (SELECT 'incomplete contingency'
2489: FROM ar_line_conts_all lc
2490: WHERE customer_trx_line_id = p_customer_trx_line_id
2491: AND lc.customer_trx_line_id = dl.customer_trx_line_id
2492: AND lc.completed_flag = 'N');
2493:

Line 2501: ar_line_conts_all lrc,

2497: WHERE dl.customer_trx_line_id = p_customer_trx_line_id
2498: and dl.customer_trx_id in
2499: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2500: FROM ra_customer_trx_lines_all ctl,
2501: ar_line_conts_all lrc,
2502: ar_deferral_reasons dr
2503: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2504: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
2505: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0

Line 4748: ar_line_conts_all lrc,

4744: /* Bug 12813416 */
4745: CURSOR c1 IS
4746: SELECT 'its a pre-billing contingency'
4747: FROM ra_customer_trx_lines_all ctl,
4748: ar_line_conts_all lrc,
4749: ar_deferral_reasons dr
4750: WHERE ctl.customer_trx_id = p_customer_trx_id
4751: and ctl.customer_trx_line_id=lrc.customer_trx_line_id
4752: and trunc(nvl(lrc.expiration_date,sysdate)) - trunc(sysdate) <= 0