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_INVOICES

Line 274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

270:
271: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
272: SELECT ai.invoice_id, aerh.report_header_id,
273: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
274: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
275: WHERE ai.APPLICATION_ID = 200
276: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
277: AND ai.REFERENCE_KEY1 = aerh.report_header_id
278: AND aerh.invoice_num = ai.invoice_num

Line 286: FROM ap_interface_rejections air, ap_invoices_interface aii

282: CURSOR c_rejected_invoices(l_request_id IN NUMBER) IS
283: SELECT to_number(aii.reference_key1) report_header_id,
284: reject_lookup_code,
285: aii.invoice_id
286: FROM ap_interface_rejections air, ap_invoices_interface aii
287: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'
288: AND air.parent_id = aii.invoice_id
289: AND aii.request_id = l_request_id
290: UNION ALL

Line 287: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'

283: SELECT to_number(aii.reference_key1) report_header_id,
284: reject_lookup_code,
285: aii.invoice_id
286: FROM ap_interface_rejections air, ap_invoices_interface aii
287: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'
288: AND air.parent_id = aii.invoice_id
289: AND aii.request_id = l_request_id
290: UNION ALL
291: SELECT to_number(aii.reference_key1) report_header_id,

Line 295: ap_invoices_interface aii,

291: SELECT to_number(aii.reference_key1) report_header_id,
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

Line 579: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE

575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
576: INDEX BY BINARY_INTEGER;
577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
578: INDEX BY BINARY_INTEGER;
579: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE
580: INDEX BY BINARY_INTEGER;
581: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE
582: INDEX BY BINARY_INTEGER;
583:

Line 926: AND (table_name = 'AP_INVOICES' OR

922: SELECT 'user defined document category exists'
923: INTO l_dummy
924: FROM fnd_doc_sequence_categories
925: WHERE code = l_invoice_rec.doc_category_code
926: AND (table_name = 'AP_INVOICES' OR
927: table_name = 'AP_INVOICES_ALL');
928: EXCEPTION
929: WHEN OTHERS THEN
930: l_reject_code := 'Invalid Doc Category';

Line 927: table_name = 'AP_INVOICES_ALL');

923: INTO l_dummy
924: FROM fnd_doc_sequence_categories
925: WHERE code = l_invoice_rec.doc_category_code
926: AND (table_name = 'AP_INVOICES' OR
927: table_name = 'AP_INVOICES_ALL');
928: EXCEPTION
929: WHEN OTHERS THEN
930: l_reject_code := 'Invalid Doc Category';
931: raise validation_failed;

Line 1125: SELECT AP_INVOICES_INTERFACE_S.nextval

1121: IF g_debug_switch = 'Y' THEN
1122: fnd_file.put_line(fnd_file.log, l_debug_info);
1123: END IF;
1124:
1125: SELECT AP_INVOICES_INTERFACE_S.nextval
1126: INTO l_invoice_rec.invoice_id
1127: FROM DUAL;
1128:
1129:

Line 1453: FROM ap_invoices I,

1449: SELECT nvl(sum(decode(payment_status_flag, 'Y',
1450: decode(sign(earliest_settlement_date - sysdate),1,0,1),
1451: 0)), 0)
1452: INTO l_available_prepays
1453: FROM ap_invoices I,
1454: ap_suppliers PV
1455: WHERE exists (SELECT 'x'
1456: FROM ap_invoice_distributions aid
1457: WHERE aid.invoice_id = i.invoice_id

Line 1482: FROM ap_invoices I,

1478: SELECT nvl(sum(decode(payment_status_flag, 'Y',
1479: decode(sign(earliest_settlement_date - sysdate),1,0,1),
1480: 0)), 0)
1481: INTO l_available_prepays
1482: FROM ap_invoices I,
1483: ap_suppliers PV
1484: WHERE exists (SELECT 'x'
1485: FROM ap_invoice_distributions aid
1486: WHERE aid.invoice_id = i.invoice_id

Line 1559: l_debug_info := 'Insert into AP Invoices Interface table';

1555:
1556:
1557:
1558: ----------------------------------------------------------
1559: l_debug_info := 'Insert into AP Invoices Interface table';
1560: ----------------------------------------------------------
1561: IF g_debug_switch = 'Y' THEN
1562: fnd_file.put_line(fnd_file.log, l_debug_info);
1563: END IF;

Line 1829: WHERE parent_table = 'AP_INVOICES_INTERFACE'

1825: and nvl(vouchno,0) = 0;
1826:
1827: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1828: DELETE FROM ap_interface_rejections
1829: WHERE parent_table = 'AP_INVOICES_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

Line 1841: DELETE FROM ap_invoices_interface

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
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

Line 2148: INSERT INTO AP_INVOICES_INTERFACE

2144: PROCEDURE InsertInvoiceInterface(p_invoice_rec InvoiceInfoRecType,
2145: p_vendor_rec VendorInfoRecType) IS
2146: ------------------------------------------------------------------------
2147: BEGIN
2148: INSERT INTO AP_INVOICES_INTERFACE
2149: (INVOICE_ID,
2150: APPLICATION_ID,
2151: PRODUCT_TABLE,
2152: REFERENCE_KEY1,