APPS.ARP_ROUNDING dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 5438: | ra_cust_trx_line_salesreps table. |

5434: | correct_scredit_rounding_errs() |
5435: | |
5436: | DESCRIPTION |
5437: | This function corrects all rounding errors in the |
5438: | ra_cust_trx_line_salesreps table. |
5439: | |
5440: | REQUIRES |
5441: | P_CUSTOMER_TRX_ID |
5442: | |

Line 5481: UPDATE ra_cust_trx_line_salesreps ctls

5477: | - Insure that the sum of revenue amounts equals the line amount if |
5478: | the sum of the revenue percents equals 100. |
5479: +-------------------------------------------------------------------------*/
5480:
5481: UPDATE ra_cust_trx_line_salesreps ctls
5482: SET (
5483: ctls.revenue_amount_split,
5484: ctls.revenue_percent_split
5485: ) =

Line 5502: ra_cust_trx_line_salesreps ctls1

5498: NVL(ctls1.revenue_percent_split, 0)
5499: )
5500: )
5501: FROM ra_customer_trx_lines ctl1,
5502: ra_cust_trx_line_salesreps ctls1
5503: WHERE ctl1.customer_trx_line_id = ctls1.customer_trx_line_id
5504: AND ctls.customer_trx_line_id = ctls1.customer_trx_line_id
5505: GROUP BY ctls1.customer_trx_line_id,
5506: ctl1.extended_amount,

Line 5513: FROM ra_cust_trx_line_salesreps ctls,

5509: )
5510: WHERE ctls.cust_trx_line_salesrep_id in
5511: (
5512: SELECT MIN(cust_trx_line_salesrep_id)
5513: FROM ra_cust_trx_line_salesreps ctls,
5514: ra_customer_trx_lines ctl
5515: WHERE ctl.customer_trx_line_id = ctls.customer_trx_line_id
5516: AND ctl.customer_trx_id = p_customer_trx_id
5517: GROUP BY ctls.customer_trx_line_id,