APPS.ARP_BF_BILL dependencies on RA_CUSTOMER_TRX_LINES

Line 695: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;

691:
692: /* Bug 5203710 remove detail_option as limiting criteria */
693: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
694:
695: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
696: TYPE tab_num IS TABLE OF NUMBER ;
697:
698: l_line_id tab_line_id ;
699: l_tax_sum tab_num ;

Line 708: FROM ra_customer_trx_lines CTL

704: CURSOR c_tax (l_trx_id NUMBER) IS
705: SELECT link_to_cust_trx_line_id,
706: sum(nvl(CTL.extended_amount,0)),
707: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
708: FROM ra_customer_trx_lines CTL
709: WHERE CTL.customer_trx_id = l_trx_id
710: AND CTL.line_type = 'TAX'
711: GROUP BY link_to_cust_trx_line_id;
712:

Line 1592: FROM ra_customer_trx_lines

1588: nvl (gross_unit_selling_price, unit_selling_price),
1589: nvl (gross_extended_amount, extended_amount),
1590: 0,
1591: org_id
1592: FROM ra_customer_trx_lines
1593: WHERE customer_trx_id = L_inv_trx.trx_id
1594: AND line_type NOT IN ('TAX', 'FREIGHT');
1595:
1596: /** now update lines with associated tax line **/

Line 1647: ra_customer_trx_lines

1643: sum (nvl (gross_extended_amount, extended_amount)),
1644: 0,
1645: org_id
1646: FROM
1647: ra_customer_trx_lines
1648: WHERE
1649: customer_trx_id = L_inv_trx.trx_id
1650: AND line_type = 'FREIGHT'
1651: GROUP BY line_type,org_id;