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_LINES

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 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 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 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 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 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 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 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 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 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)