APPS.ARP_AUTO_RULE dependencies on RA_CUSTOMER_TRX_LINES

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