DBA Data[Home] [Help]

APPS.ARP_AUTO_RULE dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 701: | outer join to ra_cust_trx_line_salesreps

697: | ra_cust_trx_line_gl_dist processing |
698: | 31-JAN-03 M Raymond Modified MRC cursor to include UNEARN
699: | rows where rec_offset_flag is null.
700: | 02-MAY-03 M Raymond Modified REV insert to include an
701: | outer join to ra_cust_trx_line_salesreps
702: | so we can assign proper salesrep id
703: | on CM distributions.
704: +-------------------------------------------------------------------------*/
705:

Line 905: ra_cust_trx_line_salesreps cmsrep,

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,
906: ar_revenue_assignments ass
907: WHERE
908: header.customer_trx_id = p_trx_id
909: AND ass.customer_trx_id = p_trx_id /* 5752668 */

Line 1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */

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 */
1601: fnd_currencies fc,
1602: ra_customer_trx trx

Line 1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */

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 */
1804: fnd_currencies fc,
1805: ra_customer_trx trx