APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_LINES_ALL

Line 1732: FROM ap_invoice_lines_all

1728: IF l_oie_applied_prepay_list(i) IS NOT NULL THEN
1729: BEGIN
1730: SELECT abs(nvl(amount,0))
1731: INTO l_actual_adv_applied
1732: FROM ap_invoice_lines_all
1733: WHERE invoice_id = l_invoice_id_list(i)
1734: AND line_type_lookup_code = 'PREPAY'
1735: AND prepay_invoice_id = l_oie_applied_prepay_list(i);
1736: EXCEPTION

Line 1758: FROM ap_invoice_lines_all ap1

1754:
1755: BEGIN
1756: SELECT sum(amount)
1757: INTO l_inv_total_amount
1758: FROM ap_invoice_lines_all ap1
1759: WHERE invoice_id = l_invoice_id_list(i);
1760: EXCEPTION
1761: WHEN NO_DATA_FOUND THEN
1762: l_inv_total_amount :=-1;