APPS.ARP_PROCESS_CREDIT dependencies on AR_NET_REVENUE_AMOUNT

Line 965: FROM ar_net_revenue_amount nra,

961: nvl(ml.line_type, 'LINE')))
962: INTO l_uncr_line_amount,
963: l_line_count,
964: l_memo_line_type
965: FROM ar_net_revenue_amount nra,
966: ra_customer_trx_lines ctl,
967: ar_memo_lines ml
968: WHERE nra.customer_trx_id = p_prev_ct_id
969: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 980: FROM ar_net_revenue_amount nra,

976: SELECT sum(nra.net_amount),
977: count(nra.customer_trx_line_id)
978: INTO l_uncr_tax_amount,
979: l_tax_count
980: FROM ar_net_revenue_amount nra,
981: ra_customer_trx_lines ctl
982: WHERE nra.customer_trx_id = p_prev_ct_id
983: AND nra.line_type = 'TAX'
984: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 999: FROM ar_net_revenue_amount nra,

995: INTO l_freight_type,
996: l_uncr_freight_amount,
997: l_freight_ctl_id,
998: l_freight_count
999: FROM ar_net_revenue_amount nra,
1000: ra_customer_trx_lines ctl
1001: WHERE nra.customer_trx_id = p_prev_ct_id
1002: AND nra.line_type = 'FREIGHT'
1003: AND ctl.customer_trx_line_id = nra.customer_trx_line_id

Line 1095: FROM ar_net_revenue_amount nra,

1091: sum(decode(nra.line_type, 'FREIGHT', nra.net_amount, 0))
1092: INTO l_total_uncr_line_amount,
1093: l_total_uncr_tax_amount,
1094: l_total_uncr_freight_amount
1095: FROM ar_net_revenue_amount nra,
1096: ra_customer_trx_lines ctl
1097: WHERE nra.customer_trx_id = p_prev_customer_trx_id
1098: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
1099: AND ctl.line_type = nra.line_type