APPS.ARP_PROCESS_CREDIT dependencies on AR_NET_REVENUE_AMOUNT

Line 935: FROM ar_net_revenue_amount nra,

931: nvl(ml.line_type, 'LINE')))
932: INTO l_uncr_line_amount,
933: l_line_count,
934: l_memo_line_type
935: FROM ar_net_revenue_amount nra,
936: ra_customer_trx_lines ctl,
937: ar_memo_lines ml
938: WHERE nra.customer_trx_id = p_prev_ct_id
939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 950: FROM ar_net_revenue_amount nra,

946: SELECT sum(nra.net_amount),
947: count(nra.customer_trx_line_id)
948: INTO l_uncr_tax_amount,
949: l_tax_count
950: FROM ar_net_revenue_amount nra,
951: ra_customer_trx_lines ctl
952: WHERE nra.customer_trx_id = p_prev_ct_id
953: AND nra.line_type = 'TAX'
954: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 969: FROM ar_net_revenue_amount nra,

965: INTO l_freight_type,
966: l_uncr_freight_amount,
967: l_freight_ctl_id,
968: l_freight_count
969: FROM ar_net_revenue_amount nra,
970: ra_customer_trx_lines ctl
971: WHERE nra.customer_trx_id = p_prev_ct_id
972: AND nra.line_type = 'FREIGHT'
973: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 1065: FROM ar_net_revenue_amount nra,

1061: sum(decode(nra.line_type, 'FREIGHT', nra.net_amount, 0))
1062: INTO l_total_uncr_line_amount,
1063: l_total_uncr_tax_amount,
1064: l_total_uncr_freight_amount
1065: FROM ar_net_revenue_amount nra,
1066: ra_customer_trx_lines ctl
1067: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1068: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1069: AND ctl.line_type = nra.line_type