[Home] [Help]
701: | ra_cust_trx_line_gl_dist processing |
702: | 31-JAN-03 M Raymond Modified MRC cursor to include UNEARN
703: | rows where rec_offset_flag is null.
704: | 02-MAY-03 M Raymond Modified REV insert to include an
705: | outer join to ra_cust_trx_line_salesreps
706: | so we can assign proper salesrep id
707: | on CM distributions.
708: +-------------------------------------------------------------------------*/
709:
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,
962: ar_rev_assign_for_std_v ass -- 9560174 only regular rules
963: WHERE
964: header.customer_trx_id = p_trx_id
965: AND ass.customer_trx_id = p_trx_id /* 5752668 */
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,
1196: ar_rev_assign_for_pprr_v ass -- 9560174 PPRR rules only.
1197: WHERE
1198: header.customer_trx_id = p_trx_id
1199: AND ass.customer_trx_id = p_trx_id /* 5752668 */
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 */
1908: fnd_currencies fc,
1909: ra_customer_trx trx
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 */
2111: fnd_currencies fc,
2112: ra_customer_trx trx