APPS.ARP_BF_BILL dependencies on RA_CUSTOMER_TRX_LINES

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

710:
711: /* Bug 5203710 remove detail_option as limiting criteria */
712: --C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
713:
714: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
715: TYPE tab_num IS TABLE OF NUMBER ;
716:
717: l_line_id tab_line_id ;
718: l_tax_sum tab_num ;

Line 727: FROM ra_customer_trx_lines CTL

723: CURSOR c_tax (l_trx_id NUMBER) IS
724: SELECT link_to_cust_trx_line_id,
725: sum(nvl(CTL.extended_amount,0)),
726: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
727: FROM ra_customer_trx_lines CTL
728: WHERE CTL.customer_trx_id = l_trx_id
729: AND CTL.line_type = 'TAX'
730: GROUP BY link_to_cust_trx_line_id;
731:

Line 1554: FROM ra_customer_trx_lines

1550: nvl (gross_unit_selling_price, unit_selling_price),
1551: nvl (gross_extended_amount, extended_amount),
1552: 0,
1553: org_id
1554: FROM ra_customer_trx_lines
1555: WHERE customer_trx_id = L_inv_trx.trx_id
1556: AND line_type NOT IN ('TAX', 'FREIGHT');
1557:
1558: /** now update lines with associated tax line **/

Line 1609: ra_customer_trx_lines

1605: sum (nvl (gross_extended_amount, extended_amount)),
1606: 0,
1607: org_id
1608: FROM
1609: ra_customer_trx_lines
1610: WHERE
1611: customer_trx_id = L_inv_trx.trx_id
1612: AND line_type = 'FREIGHT'
1613: GROUP BY line_type,org_id;