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

Line 805: FROM ra_customer_trx_lines tl,

801: INTO l_standard_rules,
802: l_pprr_rules,
803: l_need_rev_rec,
804: l_max_rule_end_date
805: FROM ra_customer_trx_lines tl,
806: ra_rules rl,
807: ra_cust_trx_line_gl_dist gld
808: WHERE tl.customer_trx_id = p_trx_id
809: AND tl.accounting_rule_id = rl.rule_id

Line 955: ra_customer_trx header,

951: ass.gl_date, /* original_gl_date */
952: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
953: header.org_id
954: FROM
955: ra_customer_trx header,
956: fnd_currencies fc,
957: ra_customer_trx_lines lines,
958: ra_rules acc_rule,
959: ra_cust_trx_line_gl_dist rec,

Line 957: ra_customer_trx_lines lines,

953: header.org_id
954: FROM
955: ra_customer_trx header,
956: fnd_currencies fc,
957: ra_customer_trx_lines lines,
958: ra_rules acc_rule,
959: ra_cust_trx_line_gl_dist rec,
960: ra_cust_trx_line_gl_dist dist,
961: ra_cust_trx_line_salesreps cmsrep,

Line 1189: ra_customer_trx header,

1185: ass.gl_date, /* original_gl_date */
1186: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
1187: header.org_id
1188: FROM
1189: ra_customer_trx header,
1190: fnd_currencies fc,
1191: ra_customer_trx_lines lines,
1192: ra_rules acc_rule,
1193: ra_cust_trx_line_gl_dist rec,

Line 1191: ra_customer_trx_lines lines,

1187: header.org_id
1188: FROM
1189: ra_customer_trx header,
1190: fnd_currencies fc,
1191: ra_customer_trx_lines lines,
1192: ra_rules acc_rule,
1193: ra_cust_trx_line_gl_dist rec,
1194: ra_cust_trx_line_gl_dist dist,
1195: ra_cust_trx_line_salesreps cmsrep,

Line 1419: ra_customer_trx header

1415: ra_cust_trx_line_gl_dist_s.NEXTVAL,
1416: header.org_id
1417: FROM
1418: ra_cust_trx_line_gl_dist rec,
1419: ra_customer_trx header
1420: WHERE
1421: header.customer_trx_id = p_trx_id
1422: AND header.complete_flag = 'Y'
1423: AND rec.customer_trx_id = header.customer_trx_id

Line 1616: ra_customer_trx header,

1612: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1613: ra_cust_trx_line_gl_dist_s.nextval,
1614: header.org_id
1615: FROM
1616: ra_customer_trx header,
1617: ra_cust_trx_line_gl_dist rec, /* ROUND row */
1618: ra_cust_trx_line_gl_dist rrec /* REC row */
1619: WHERE
1620: header.customer_trx_id = p_trx_id

Line 1724: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;

1720: /* added for MRC */
1721: l_rows NUMBER;
1722: /* bug 3550426 */
1723: l_ctt_id ra_cust_trx_types.cust_trx_type_id%TYPE;
1724: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;
1725: l_ctt_type ra_cust_trx_types.type%TYPE;
1726: l_revrec_run_flag VARCHAR2(1);
1727: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;
1728:

Line 1727: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;

1723: l_ctt_id ra_cust_trx_types.cust_trx_type_id%TYPE;
1724: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;
1725: l_ctt_type ra_cust_trx_types.type%TYPE;
1726: l_revrec_run_flag VARCHAR2(1);
1727: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;
1728:
1729: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1730:
1731: /*FP 5450534 for bug 5260489 take a dummy parameter to pass in call to rev. rec.*/

Line 1732: l_request_id ra_customer_trx.request_id%type;

1728:
1729: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1730:
1731: /*FP 5450534 for bug 5260489 take a dummy parameter to pass in call to rev. rec.*/
1732: l_request_id ra_customer_trx.request_id%type;
1733:
1734: l_result NUMBER;
1735: NO_ROF_EXCEPTION EXCEPTION;
1736:

Line 1752: FROM ra_customer_trx

1748: previous_customer_trx_id
1749: INTO l_ctt_id,
1750: l_inv_rule_id,
1751: l_prev_cust_trx_id
1752: FROM ra_customer_trx
1753: WHERE customer_trx_id = p_trx_id;
1754:
1755: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1756:

Line 1902: ra_customer_trx_lines psum_lines,

1898: 'UNBILL', 'Y',
1899: NULL) ,
1900: trx.org_id
1901: FROM
1902: ra_customer_trx_lines psum_lines,
1903: ra_customer_trx psum_trx,
1904: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1905: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1906: ra_customer_trx_lines lines,

Line 1903: ra_customer_trx psum_trx,

1899: NULL) ,
1900: trx.org_id
1901: FROM
1902: ra_customer_trx_lines psum_lines,
1903: ra_customer_trx psum_trx,
1904: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1905: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1906: ra_customer_trx_lines lines,
1907: ra_cust_trx_line_gl_dist rec, /* model receivable account */

Line 1906: ra_customer_trx_lines lines,

1902: ra_customer_trx_lines psum_lines,
1903: ra_customer_trx psum_trx,
1904: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1905: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1906: ra_customer_trx_lines lines,
1907: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1908: fnd_currencies fc,
1909: ra_customer_trx trx
1910: WHERE

Line 1909: ra_customer_trx trx

1905: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1906: ra_customer_trx_lines lines,
1907: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1908: fnd_currencies fc,
1909: ra_customer_trx trx
1910: WHERE
1911: trx.customer_trx_id = p_trx_id
1912: AND trx.complete_flag = 'Y'
1913: AND fc.currency_code = trx.invoice_currency_code

Line 2105: ra_customer_trx_lines psum_lines,

2101: 'UNBILL', 'Y',
2102: NULL),
2103: trx.org_id
2104: FROM
2105: ra_customer_trx_lines psum_lines,
2106: ra_customer_trx psum_trx,
2107: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
2108: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
2109: ra_customer_trx_lines lines,

Line 2106: ra_customer_trx psum_trx,

2102: NULL),
2103: trx.org_id
2104: FROM
2105: ra_customer_trx_lines psum_lines,
2106: ra_customer_trx psum_trx,
2107: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
2108: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
2109: ra_customer_trx_lines lines,
2110: ra_cust_trx_line_gl_dist rec, /* model receivable account */

Line 2109: ra_customer_trx_lines lines,

2105: ra_customer_trx_lines psum_lines,
2106: ra_customer_trx psum_trx,
2107: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
2108: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
2109: ra_customer_trx_lines lines,
2110: ra_cust_trx_line_gl_dist rec, /* model receivable account */
2111: fnd_currencies fc,
2112: ra_customer_trx trx
2113: WHERE

Line 2112: ra_customer_trx trx

2108: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
2109: ra_customer_trx_lines lines,
2110: ra_cust_trx_line_gl_dist rec, /* model receivable account */
2111: fnd_currencies fc,
2112: ra_customer_trx trx
2113: WHERE
2114: trx.customer_trx_id = p_trx_id
2115: AND trx.complete_flag = 'Y'
2116: AND fc.currency_code = trx.invoice_currency_code

Line 2360: ra_customer_trx model_trx,

2356: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2357: tax.collected_tax_ccid,
2358: trx.org_id
2359: FROM
2360: ra_customer_trx model_trx,
2361: ra_cust_trx_line_gl_dist tax,
2362: ra_customer_trx_lines tax_line,
2363: ra_customer_trx_lines line_line,
2364: ra_cust_trx_line_gl_dist rec,

Line 2362: ra_customer_trx_lines tax_line,

2358: trx.org_id
2359: FROM
2360: ra_customer_trx model_trx,
2361: ra_cust_trx_line_gl_dist tax,
2362: ra_customer_trx_lines tax_line,
2363: ra_customer_trx_lines line_line,
2364: ra_cust_trx_line_gl_dist rec,
2365: fnd_currencies fc,
2366: ra_customer_trx trx

Line 2363: ra_customer_trx_lines line_line,

2359: FROM
2360: ra_customer_trx model_trx,
2361: ra_cust_trx_line_gl_dist tax,
2362: ra_customer_trx_lines tax_line,
2363: ra_customer_trx_lines line_line,
2364: ra_cust_trx_line_gl_dist rec,
2365: fnd_currencies fc,
2366: ra_customer_trx trx
2367: WHERE

Line 2366: ra_customer_trx trx

2362: ra_customer_trx_lines tax_line,
2363: ra_customer_trx_lines line_line,
2364: ra_cust_trx_line_gl_dist rec,
2365: fnd_currencies fc,
2366: ra_customer_trx trx
2367: WHERE
2368: trx.customer_trx_id = p_trx_id
2369: AND trx.complete_flag = 'Y'
2370: AND fc.currency_code = trx.invoice_currency_code

Line 2558: ra_customer_trx model_trx,

2554: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2555: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2556: trx.org_id
2557: FROM
2558: ra_customer_trx model_trx,
2559: ra_cust_trx_line_gl_dist freight,
2560: ra_customer_trx_lines lines,
2561: ra_cust_trx_line_gl_dist rec,
2562: fnd_currencies fc,

Line 2560: ra_customer_trx_lines lines,

2556: trx.org_id
2557: FROM
2558: ra_customer_trx model_trx,
2559: ra_cust_trx_line_gl_dist freight,
2560: ra_customer_trx_lines lines,
2561: ra_cust_trx_line_gl_dist rec,
2562: fnd_currencies fc,
2563: ra_customer_trx trx
2564: WHERE

Line 2563: ra_customer_trx trx

2559: ra_cust_trx_line_gl_dist freight,
2560: ra_customer_trx_lines lines,
2561: ra_cust_trx_line_gl_dist rec,
2562: fnd_currencies fc,
2563: ra_customer_trx trx
2564: WHERE
2565: trx.customer_trx_id = p_trx_id
2566: AND trx.complete_flag = 'Y'
2567: AND fc.currency_code = trx.invoice_currency_code

Line 2575: FROM ra_customer_trx_lines line_line

2571: AND rec.customer_trx_line_id IS NULL
2572: AND EXISTS
2573: (
2574: SELECT 1
2575: FROM ra_customer_trx_lines line_line
2576: WHERE line_line.customer_trx_id = trx.customer_trx_id
2577: AND line_line.autorule_complete_flag||'' = 'N'
2578: )
2579: AND lines.customer_trx_id = rec.customer_trx_id

Line 2720: update ra_customer_trx_lines ul

2716: IF arp_standard.profile.request_id IS NOT NULL
2717: THEN
2718: /* Existing logic - request_id is set */
2719:
2720: update ra_customer_trx_lines ul
2721: set autorule_complete_flag = null,
2722: autorule_duration_processed =
2723: accounting_rule_duration,
2724: last_update_date = sysdate,

Line 2737: from ra_customer_trx_lines tl,

2733: where gl.customer_trx_line_id = ul.customer_trx_line_id
2734: and gl.account_set_flag = 'N'
2735: and gl.request_id = arp_standard.profile.request_id)
2736: or exists (select 'a distribution for a linked line'
2737: from ra_customer_trx_lines tl,
2738: ra_cust_trx_line_gl_dist tgl
2739: where tl.customer_trx_id = ul.customer_trx_id
2740: and tl.link_to_cust_trx_line_id = ul.customer_trx_line_id
2741: and tgl.customer_trx_line_id = tl.customer_trx_line_id

Line 2747: update ra_customer_trx_lines ul

2743: and tgl.request_id = arp_standard.profile.request_id));
2744:
2745: ELSE
2746: /* Request_id is not set */
2747: update ra_customer_trx_lines ul
2748: set autorule_complete_flag = null,
2749: autorule_duration_processed =
2750: accounting_rule_duration,
2751: last_update_date = sysdate,

Line 2763: from ra_customer_trx_lines tl,

2759: from ra_cust_trx_line_gl_dist gl
2760: where gl.customer_trx_line_id = ul.customer_trx_line_id
2761: and gl.account_set_flag = 'N')
2762: or exists (select 'a distribution for a linked line'
2763: from ra_customer_trx_lines tl,
2764: ra_cust_trx_line_gl_dist tgl
2765: where tl.customer_trx_id = ul.customer_trx_id
2766: and tl.link_to_cust_trx_line_id = ul.customer_trx_line_id
2767: and tgl.customer_trx_line_id = tl.customer_trx_line_id

Line 2905: ra_customer_trx ct

2901: ct.customer_trx_id,
2902: ct.trx_number,
2903: ct.upgrade_method -- Bug 8478031
2904: FROM
2905: ra_customer_trx ct
2906: WHERE
2907: ct.complete_flag = 'Y'
2908: AND ct.customer_trx_id = p_trx_id
2909: AND EXISTS (

Line 2911: FROM ra_customer_trx_lines ctl

2907: ct.complete_flag = 'Y'
2908: AND ct.customer_trx_id = p_trx_id
2909: AND EXISTS (
2910: SELECT 'line needing dists'
2911: FROM ra_customer_trx_lines ctl
2912: WHERE ctl.customer_trx_id = ct.customer_trx_id
2913: AND ctl.autorule_complete_flag||'' = 'N'
2914: AND (ctl.autorule_duration_processed <
2915: ctl.accounting_rule_duration OR

Line 2926: ra_customer_trx ct,

2922: DISTINCT ctl.customer_trx_id,
2923: ct.trx_number,
2924: ct.upgrade_method -- Bug 8478031
2925: FROM
2926: ra_customer_trx ct,
2927: ra_customer_trx_lines ctl
2928: WHERE
2929: ctl.autorule_complete_flag = 'N'
2930: AND nvl(ctl.autorule_duration_processed,-2) <

Line 2927: ra_customer_trx_lines ctl

2923: ct.trx_number,
2924: ct.upgrade_method -- Bug 8478031
2925: FROM
2926: ra_customer_trx ct,
2927: ra_customer_trx_lines ctl
2928: WHERE
2929: ctl.autorule_complete_flag = 'N'
2930: AND nvl(ctl.autorule_duration_processed,-2) <
2931: nvl(ctl.accounting_rule_duration,-1)

Line 2955: l_customer_trx ra_customer_trx%ROWTYPE;

2951: l_invoice_class ar_payment_schedules.class%TYPE;
2952: l_lock VARCHAR2(30);
2953:
2954: -- Bug 8478031
2955: l_customer_trx ra_customer_trx%ROWTYPE;
2956: upgrade_method ra_customer_trx.upgrade_method%TYPE;
2957: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2958: l_msg_data VARCHAR2(2000);
2959: l_msg_count NUMBER;

Line 2956: upgrade_method ra_customer_trx.upgrade_method%TYPE;

2952: l_lock VARCHAR2(30);
2953:
2954: -- Bug 8478031
2955: l_customer_trx ra_customer_trx%ROWTYPE;
2956: upgrade_method ra_customer_trx.upgrade_method%TYPE;
2957: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2958: l_msg_data VARCHAR2(2000);
2959: l_msg_count NUMBER;
2960:

Line 3132: FROM ra_customer_trx

3128:
3129: --lock header record to avoid data corruption ref bug 8269482
3130: SELECT 'LOCK'
3131: INTO l_lock
3132: FROM ra_customer_trx
3133: WHERE customer_trx_id = trx_id
3134: FOR UPDATE OF customer_trx_id;
3135: END IF;
3136: