eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_LINES_INTERFACE

Line 296: ap_invoice_lines_interface aili

292: reject_lookup_code,
293: aii.invoice_id
294: FROM ap_interface_rejections air,
295: ap_invoices_interface aii,
296: ap_invoice_lines_interface aili
297: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
298: AND air.parent_id = aili.invoice_line_id
299: AND aii.invoice_id = aili.invoice_id
300: AND aii.request_id = l_request_id;

Line 297: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'

293: aii.invoice_id
294: FROM ap_interface_rejections air,
295: ap_invoices_interface aii,
296: ap_invoice_lines_interface aili
297: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
298: AND air.parent_id = aili.invoice_line_id
299: AND aii.invoice_id = aili.invoice_id
300: AND aii.request_id = l_request_id;
301:

Line 1834: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'

1830: AND parent_id = l_invoice_id_list(i);
1831:
1832: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1833: DELETE FROM ap_interface_rejections
1834: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
1835: AND parent_id IN
1836: (SELECT invoice_line_id
1837: FROM ap_invoice_lines_interface
1838: WHERE invoice_id = l_invoice_id_list(i));

Line 1837: FROM ap_invoice_lines_interface

1833: DELETE FROM ap_interface_rejections
1834: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
1835: AND parent_id IN
1836: (SELECT invoice_line_id
1837: FROM ap_invoice_lines_interface
1838: WHERE invoice_id = l_invoice_id_list(i));
1839:
1840: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1841: DELETE FROM ap_invoices_interface

Line 1845: DELETE FROM ap_invoice_lines_interface

1841: DELETE FROM ap_invoices_interface
1842: WHERE invoice_id = l_invoice_id_list(i);
1843:
1844: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1845: DELETE FROM ap_invoice_lines_interface
1846: WHERE invoice_id = l_invoice_id_list(i);
1847:
1848: END IF;
1849:

Line 2376: INSERT INTO AP_INVOICE_LINES_INTERFACE

2372: IF g_debug_switch = 'Y' THEN
2373: l_debug_info := 'Insert into Invoice Lines Interface, p_invoice_id ' || p_invoice_id || ', p_report_header_id ' || p_report_header_id || ', p_transfer_flag ' || p_transfer_flag || ', p_enable_recoverable_flag ' || p_enable_recoverable_flag;
2374: fnd_file.put_line(fnd_file.log, l_debug_info);
2375: END IF;
2376: INSERT INTO AP_INVOICE_LINES_INTERFACE
2377: (INVOICE_ID,
2378: APPLICATION_ID,
2379: PRODUCT_TABLE,
2380: REFERENCE_KEY1,

Line 2477: AP_INVOICE_LINES_INTERFACE_S.nextval,

2473: 200,
2474: 'AP_EXPENSE_REPORT_LINES_ALL',
2475: xl.report_header_id,
2476: xl.report_line_id,
2477: AP_INVOICE_LINES_INTERFACE_S.nextval,
2478: xl.distribution_line_number,
2479: nvl(lc.lookup_code, '') line_type_lookup_code,
2480: '',
2481: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,