APPS.ARP_ROUNDING dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 5368: | ra_cust_trx_line_salesreps table. |

5364: | correct_scredit_rounding_errs() |
5365: | |
5366: | DESCRIPTION |
5367: | This function corrects all rounding errors in the |
5368: | ra_cust_trx_line_salesreps table. |
5369: | |
5370: | REQUIRES |
5371: | P_CUSTOMER_TRX_ID |
5372: | |

Line 5411: UPDATE ra_cust_trx_line_salesreps ctls

5407: | - Insure that the sum of revenue amounts equals the line amount if |
5408: | the sum of the revenue percents equals 100. |
5409: +-------------------------------------------------------------------------*/
5410:
5411: UPDATE ra_cust_trx_line_salesreps ctls
5412: SET (
5413: ctls.revenue_amount_split,
5414: ctls.revenue_percent_split
5415: ) =

Line 5432: ra_cust_trx_line_salesreps ctls1

5428: NVL(ctls1.revenue_percent_split, 0)
5429: )
5430: )
5431: FROM ra_customer_trx_lines ctl1,
5432: ra_cust_trx_line_salesreps ctls1
5433: WHERE ctl1.customer_trx_line_id = ctls1.customer_trx_line_id
5434: AND ctls.customer_trx_line_id = ctls1.customer_trx_line_id
5435: GROUP BY ctls1.customer_trx_line_id,
5436: ctl1.extended_amount,

Line 5443: FROM ra_cust_trx_line_salesreps ctls,

5439: )
5440: WHERE ctls.cust_trx_line_salesrep_id in
5441: (
5442: SELECT MIN(cust_trx_line_salesrep_id)
5443: FROM ra_cust_trx_line_salesreps ctls,
5444: ra_customer_trx_lines ctl
5445: WHERE ctl.customer_trx_line_id = ctls.customer_trx_line_id
5446: AND ctl.customer_trx_id = p_customer_trx_id
5447: GROUP BY ctls.customer_trx_line_id,