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 1409: ap_invoice_lines_interface aili

1405: reject_lookup_code,
1406: aii.invoice_id
1407: FROM ap_interface_rejections air,
1408: ap_invoices_interface aii,
1409: ap_invoice_lines_interface aili
1410: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
1411: AND air.parent_id = aili.invoice_line_id
1412: AND aii.invoice_id = aili.invoice_id
1413: AND aii.request_id = l_request_id;

Line 1410: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'

1406: aii.invoice_id
1407: FROM ap_interface_rejections air,
1408: ap_invoices_interface aii,
1409: ap_invoice_lines_interface aili
1410: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
1411: AND air.parent_id = aili.invoice_line_id
1412: AND aii.invoice_id = aili.invoice_id
1413: AND aii.request_id = l_request_id;
1414:

Line 2941: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'

2937: WHERE request_id = l_request_id
2938: );
2939:
2940: DELETE FROM ap_interface_rejections
2941: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
2942: and parent_id IN (SELECT aili.invoice_line_id
2943: FROM ap_invoices_interface aii, ap_invoice_lines_interface aili
2944: WHERE aii.invoice_id = aili.invoice_id
2945: AND aii.request_id = l_request_id

Line 2943: FROM ap_invoices_interface aii, ap_invoice_lines_interface aili

2939:
2940: DELETE FROM ap_interface_rejections
2941: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
2942: and parent_id IN (SELECT aili.invoice_line_id
2943: FROM ap_invoices_interface aii, ap_invoice_lines_interface aili
2944: WHERE aii.invoice_id = aili.invoice_id
2945: AND aii.request_id = l_request_id
2946: );
2947:

Line 2948: DELETE FROM ap_invoice_lines_interface

2944: WHERE aii.invoice_id = aili.invoice_id
2945: AND aii.request_id = l_request_id
2946: );
2947:
2948: DELETE FROM ap_invoice_lines_interface
2949: WHERE invoice_id IN (SELECT invoice_id
2950: FROM ap_invoices_interface
2951: WHERE request_id = l_request_id
2952: );

Line 3476: INSERT INTO AP_INVOICE_LINES_INTERFACE

3472: IF g_debug_switch = 'Y' THEN
3473: 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;
3474: fnd_file.put_line(fnd_file.log, l_debug_info);
3475: END IF;
3476: INSERT INTO AP_INVOICE_LINES_INTERFACE
3477: (INVOICE_ID,
3478: APPLICATION_ID,
3479: PRODUCT_TABLE,
3480: REFERENCE_KEY1,

Line 3582: AP_INVOICE_LINES_INTERFACE_S.nextval,

3578: 200,
3579: 'AP_EXPENSE_REPORT_LINES_ALL',
3580: xl.report_header_id,
3581: xl.report_line_id,
3582: AP_INVOICE_LINES_INTERFACE_S.nextval,
3583: xl.distribution_line_number,
3584: nvl(lc.lookup_code, '') line_type_lookup_code,
3585: '',
3586: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,