DBA Data[Home] [Help]

APPS.ARP_CTL_PKG dependencies on AR_NET_REVENUE_AMOUNT

Line 5685: ar_net_revenue_amount nra,

5681: --}
5682: FROM ra_customer_trx_lines inv_ctl,
5683: ra_customer_trx_lines cm_ctl,
5684: ra_customer_trx cm_ct,
5685: ar_net_revenue_amount nra,
5686: ar_memo_lines_b inv_ctl_memo
5687: WHERE cm_ct.customer_trx_id = p_customer_trx_id
5688: AND inv_ctl.customer_trx_id = cm_ct.previous_customer_trx_id
5689: AND nra.customer_trx_id = p_prev_customer_trx_id

Line 6099: FROM ar_net_revenue_amount nra,

6095: 0, 1,
6096: p_uncredited_amount
6097: ) * nvl(p_credit_amount, 0)
6098: ) /* extended_amount */
6099: FROM ar_net_revenue_amount nra,
6100: ra_customer_trx cm_ct
6101: WHERE nra.customer_trx_id = p_prev_customer_trx_id
6102: AND nra.customer_trx_line_id =
6103: ctl.previous_customer_trx_line_id