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 899: ra_customer_trx header,

895: ass.gl_date, /* original_gl_date */
896: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
897: header.org_id
898: FROM
899: ra_customer_trx header,
900: fnd_currencies fc,
901: ra_customer_trx_lines lines,
902: ra_rules acc_rule,
903: ra_cust_trx_line_gl_dist rec,

Line 901: ra_customer_trx_lines lines,

897: header.org_id
898: FROM
899: ra_customer_trx header,
900: fnd_currencies fc,
901: ra_customer_trx_lines lines,
902: ra_rules acc_rule,
903: ra_cust_trx_line_gl_dist rec,
904: ra_cust_trx_line_gl_dist dist,
905: ra_cust_trx_line_salesreps cmsrep,

Line 1112: ra_customer_trx header

1108: ra_cust_trx_line_gl_dist_s.NEXTVAL,
1109: header.org_id
1110: FROM
1111: ra_cust_trx_line_gl_dist rec,
1112: ra_customer_trx header
1113: WHERE
1114: header.customer_trx_id = p_trx_id
1115: AND header.complete_flag = 'Y'
1116: AND rec.customer_trx_id = header.customer_trx_id

Line 1309: ra_customer_trx header,

1305: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1306: ra_cust_trx_line_gl_dist_s.nextval,
1307: header.org_id
1308: FROM
1309: ra_customer_trx header,
1310: ra_cust_trx_line_gl_dist rec, /* ROUND row */
1311: ra_cust_trx_line_gl_dist rrec /* REC row */
1312: WHERE
1313: header.customer_trx_id = p_trx_id

Line 1417: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;

1413: /* added for MRC */
1414: l_rows NUMBER;
1415: /* bug 3550426 */
1416: l_ctt_id ra_cust_trx_types.cust_trx_type_id%TYPE;
1417: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;
1418: l_ctt_type ra_cust_trx_types.type%TYPE;
1419: l_revrec_run_flag VARCHAR2(1);
1420: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;
1421:

Line 1420: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;

1416: l_ctt_id ra_cust_trx_types.cust_trx_type_id%TYPE;
1417: l_inv_rule_id ra_customer_trx.invoicing_rule_id%TYPE;
1418: l_ctt_type ra_cust_trx_types.type%TYPE;
1419: l_revrec_run_flag VARCHAR2(1);
1420: l_prev_cust_trx_id ra_customer_trx.customer_trx_id%TYPE;
1421:
1422: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1423:
1424: /*FP 5450534 for bug 5260489 take a dummy parameter to pass in call to rev. rec.*/

Line 1425: l_request_id ra_customer_trx.request_id%type;

1421:
1422: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1423:
1424: /*FP 5450534 for bug 5260489 take a dummy parameter to pass in call to rev. rec.*/
1425: l_request_id ra_customer_trx.request_id%type;
1426:
1427: l_result NUMBER;
1428: NO_ROF_EXCEPTION EXCEPTION;
1429:

Line 1445: FROM ra_customer_trx

1441: previous_customer_trx_id
1442: INTO l_ctt_id,
1443: l_inv_rule_id,
1444: l_prev_cust_trx_id
1445: FROM ra_customer_trx
1446: WHERE customer_trx_id = p_trx_id;
1447:
1448: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1449:

Line 1595: ra_customer_trx_lines psum_lines,

1591: 'UNBILL', 'Y',
1592: NULL) ,
1593: trx.org_id
1594: FROM
1595: ra_customer_trx_lines psum_lines,
1596: ra_customer_trx psum_trx,
1597: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1599: ra_customer_trx_lines lines,

Line 1596: ra_customer_trx psum_trx,

1592: NULL) ,
1593: trx.org_id
1594: FROM
1595: ra_customer_trx_lines psum_lines,
1596: ra_customer_trx psum_trx,
1597: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1599: ra_customer_trx_lines lines,
1600: ra_cust_trx_line_gl_dist rec, /* model receivable account */

Line 1599: ra_customer_trx_lines lines,

1595: ra_customer_trx_lines psum_lines,
1596: ra_customer_trx psum_trx,
1597: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1599: ra_customer_trx_lines lines,
1600: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1601: fnd_currencies fc,
1602: ra_customer_trx trx
1603: WHERE

Line 1602: ra_customer_trx trx

1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1599: ra_customer_trx_lines lines,
1600: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1601: fnd_currencies fc,
1602: ra_customer_trx trx
1603: WHERE
1604: trx.customer_trx_id = p_trx_id
1605: AND trx.complete_flag = 'Y'
1606: AND fc.currency_code = trx.invoice_currency_code

Line 1798: ra_customer_trx_lines psum_lines,

1794: 'UNBILL', 'Y',
1795: NULL),
1796: trx.org_id
1797: FROM
1798: ra_customer_trx_lines psum_lines,
1799: ra_customer_trx psum_trx,
1800: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1802: ra_customer_trx_lines lines,

Line 1799: ra_customer_trx psum_trx,

1795: NULL),
1796: trx.org_id
1797: FROM
1798: ra_customer_trx_lines psum_lines,
1799: ra_customer_trx psum_trx,
1800: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1802: ra_customer_trx_lines lines,
1803: ra_cust_trx_line_gl_dist rec, /* model receivable account */

Line 1802: ra_customer_trx_lines lines,

1798: ra_customer_trx_lines psum_lines,
1799: ra_customer_trx psum_trx,
1800: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1802: ra_customer_trx_lines lines,
1803: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1804: fnd_currencies fc,
1805: ra_customer_trx trx
1806: WHERE

Line 1805: ra_customer_trx trx

1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1802: ra_customer_trx_lines lines,
1803: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1804: fnd_currencies fc,
1805: ra_customer_trx trx
1806: WHERE
1807: trx.customer_trx_id = p_trx_id
1808: AND trx.complete_flag = 'Y'
1809: AND fc.currency_code = trx.invoice_currency_code

Line 2053: ra_customer_trx model_trx,

2049: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2050: tax.collected_tax_ccid,
2051: trx.org_id
2052: FROM
2053: ra_customer_trx model_trx,
2054: ra_cust_trx_line_gl_dist tax,
2055: ra_customer_trx_lines tax_line,
2056: ra_customer_trx_lines line_line,
2057: ra_cust_trx_line_gl_dist rec,

Line 2055: ra_customer_trx_lines tax_line,

2051: trx.org_id
2052: FROM
2053: ra_customer_trx model_trx,
2054: ra_cust_trx_line_gl_dist tax,
2055: ra_customer_trx_lines tax_line,
2056: ra_customer_trx_lines line_line,
2057: ra_cust_trx_line_gl_dist rec,
2058: fnd_currencies fc,
2059: ra_customer_trx trx

Line 2056: ra_customer_trx_lines line_line,

2052: FROM
2053: ra_customer_trx model_trx,
2054: ra_cust_trx_line_gl_dist tax,
2055: ra_customer_trx_lines tax_line,
2056: ra_customer_trx_lines line_line,
2057: ra_cust_trx_line_gl_dist rec,
2058: fnd_currencies fc,
2059: ra_customer_trx trx
2060: WHERE

Line 2059: ra_customer_trx trx

2055: ra_customer_trx_lines tax_line,
2056: ra_customer_trx_lines line_line,
2057: ra_cust_trx_line_gl_dist rec,
2058: fnd_currencies fc,
2059: ra_customer_trx trx
2060: WHERE
2061: trx.customer_trx_id = p_trx_id
2062: AND trx.complete_flag = 'Y'
2063: AND fc.currency_code = trx.invoice_currency_code

Line 2251: ra_customer_trx model_trx,

2247: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2248: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2249: trx.org_id
2250: FROM
2251: ra_customer_trx model_trx,
2252: ra_cust_trx_line_gl_dist freight,
2253: ra_customer_trx_lines lines,
2254: ra_cust_trx_line_gl_dist rec,
2255: fnd_currencies fc,

Line 2253: ra_customer_trx_lines lines,

2249: trx.org_id
2250: FROM
2251: ra_customer_trx model_trx,
2252: ra_cust_trx_line_gl_dist freight,
2253: ra_customer_trx_lines lines,
2254: ra_cust_trx_line_gl_dist rec,
2255: fnd_currencies fc,
2256: ra_customer_trx trx
2257: WHERE

Line 2256: ra_customer_trx trx

2252: ra_cust_trx_line_gl_dist freight,
2253: ra_customer_trx_lines lines,
2254: ra_cust_trx_line_gl_dist rec,
2255: fnd_currencies fc,
2256: ra_customer_trx trx
2257: WHERE
2258: trx.customer_trx_id = p_trx_id
2259: AND trx.complete_flag = 'Y'
2260: AND fc.currency_code = trx.invoice_currency_code

Line 2268: FROM ra_customer_trx_lines line_line

2264: AND rec.customer_trx_line_id IS NULL
2265: AND EXISTS
2266: (
2267: SELECT 1
2268: FROM ra_customer_trx_lines line_line
2269: WHERE line_line.customer_trx_id = trx.customer_trx_id
2270: AND line_line.autorule_complete_flag||'' = 'N'
2271: )
2272: AND lines.customer_trx_id = rec.customer_trx_id

Line 2413: update ra_customer_trx_lines ul

2409: IF arp_standard.profile.request_id IS NOT NULL
2410: THEN
2411: /* Existing logic - request_id is set */
2412:
2413: update ra_customer_trx_lines ul
2414: set autorule_complete_flag = null,
2415: autorule_duration_processed =
2416: accounting_rule_duration,
2417: last_update_date = sysdate,

Line 2430: from ra_customer_trx_lines tl,

2426: where gl.customer_trx_line_id = ul.customer_trx_line_id
2427: and gl.account_set_flag = 'N'
2428: and gl.request_id = arp_standard.profile.request_id)
2429: or exists (select 'a distribution for a linked line'
2430: from ra_customer_trx_lines tl,
2431: ra_cust_trx_line_gl_dist tgl
2432: where tl.customer_trx_id = ul.customer_trx_id
2433: and tl.link_to_cust_trx_line_id = ul.customer_trx_line_id
2434: and tgl.customer_trx_line_id = tl.customer_trx_line_id

Line 2440: update ra_customer_trx_lines ul

2436: and tgl.request_id = arp_standard.profile.request_id));
2437:
2438: ELSE
2439: /* Request_id is not set */
2440: update ra_customer_trx_lines ul
2441: set autorule_complete_flag = null,
2442: autorule_duration_processed =
2443: accounting_rule_duration,
2444: last_update_date = sysdate,

Line 2456: from ra_customer_trx_lines tl,

2452: from ra_cust_trx_line_gl_dist gl
2453: where gl.customer_trx_line_id = ul.customer_trx_line_id
2454: and gl.account_set_flag = 'N')
2455: or exists (select 'a distribution for a linked line'
2456: from ra_customer_trx_lines tl,
2457: ra_cust_trx_line_gl_dist tgl
2458: where tl.customer_trx_id = ul.customer_trx_id
2459: and tl.link_to_cust_trx_line_id = ul.customer_trx_line_id
2460: and tgl.customer_trx_line_id = tl.customer_trx_line_id

Line 2597: ra_customer_trx ct

2593: SELECT
2594: ct.customer_trx_id,
2595: ct.trx_number
2596: FROM
2597: ra_customer_trx ct
2598: WHERE
2599: ct.complete_flag = 'Y'
2600: AND ct.customer_trx_id = p_trx_id
2601: AND EXISTS (

Line 2603: FROM ra_customer_trx_lines ctl

2599: ct.complete_flag = 'Y'
2600: AND ct.customer_trx_id = p_trx_id
2601: AND EXISTS (
2602: SELECT 'line needing dists'
2603: FROM ra_customer_trx_lines ctl
2604: WHERE ctl.customer_trx_id = ct.customer_trx_id
2605: AND ctl.autorule_complete_flag||'' = 'N'
2606: AND (ctl.autorule_duration_processed <
2607: ctl.accounting_rule_duration OR

Line 2616: ra_customer_trx ct,

2612: SELECT
2613: DISTINCT ctl.customer_trx_id,
2614: ct.trx_number
2615: FROM
2616: ra_customer_trx ct,
2617: ra_customer_trx_lines ctl
2618: WHERE
2619: ctl.autorule_complete_flag = 'N'
2620: AND nvl(ctl.autorule_duration_processed,-2) <

Line 2617: ra_customer_trx_lines ctl

2613: DISTINCT ctl.customer_trx_id,
2614: ct.trx_number
2615: FROM
2616: ra_customer_trx ct,
2617: ra_customer_trx_lines ctl
2618: WHERE
2619: ctl.autorule_complete_flag = 'N'
2620: AND nvl(ctl.autorule_duration_processed,-2) <
2621: nvl(ctl.accounting_rule_duration,-1)