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 77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),

73: V.vendor_name,
74: V.segment1,
75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,

Line 78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),

74: V.segment1,
75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,

Line 79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),

75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code

Line 80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),

76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,

Line 84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,

80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,
85: ap_expense_report_headers_all aeh, hr_organization_units hou
86: WHERE aeh.request_id = l_req_id
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id

Line 118: ap_invoices_all ai,

114: hou.name,
115: aeh.default_currency_code
116: FROM
117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,
122: ap_lookup_codes alc,

Line 152: ap_invoices_all ai,

148: hou.name,
149: aeh.default_currency_code
150: FROM
151: ap_expense_report_headers_all aeh,
152: ap_invoices_all ai,
153: ap_suppliers aps,
154: per_cont_workers_x per,
155: ap_lookup_codes alc,
156: hr_organization_units hou

Line 181: l_invoice_num ap_invoices_all.invoice_num%TYPE;

177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;

Line 182: l_prepay_num ap_invoices_all.invoice_num%TYPE;

178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;

Line 183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;
187: l_per_prepay NUMBER;

Line 184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;

180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;
187: l_per_prepay NUMBER;
188: l_prepay_applied NUMBER;

Line 954: , x_entity_name => 'AP_INVOICES'

950: (x_rowid => l_rowid
951: , x_attached_document_id => AttachedDocTabRec.attached_document_id
952: , x_document_id => AttachedDocTabRec.document_id
953: , x_seq_num => l_seq_num
954: , x_entity_name => 'AP_INVOICES'
955: , x_pk1_value => To_Char(p_invoice_id)
956: , x_pk2_value => null
957: , x_pk3_value => null
958: , x_pk4_value => null

Line 1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

1383:
1384: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
1385: SELECT ai.invoice_id, aerh.report_header_id,
1386: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
1388: WHERE ai.APPLICATION_ID = 200
1389: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
1390: AND ai.REFERENCE_KEY1 = aerh.report_header_id
1391: AND aerh.invoice_num = ai.invoice_num

Line 1399: FROM ap_interface_rejections air, ap_invoices_interface aii

1395: CURSOR c_rejected_invoices(l_request_id IN NUMBER) IS
1396: SELECT to_number(aii.reference_key1) report_header_id,
1397: reject_lookup_code,
1398: aii.invoice_id
1399: FROM ap_interface_rejections air, ap_invoices_interface aii
1400: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'
1401: AND air.parent_id = aii.invoice_id
1402: AND aii.request_id = l_request_id
1403: UNION ALL

Line 1400: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'

1396: SELECT to_number(aii.reference_key1) report_header_id,
1397: reject_lookup_code,
1398: aii.invoice_id
1399: FROM ap_interface_rejections air, ap_invoices_interface aii
1400: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'
1401: AND air.parent_id = aii.invoice_id
1402: AND aii.request_id = l_request_id
1403: UNION ALL
1404: SELECT to_number(aii.reference_key1) report_header_id,

Line 1408: ap_invoices_interface aii,

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

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

1689: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
1690: INDEX BY BINARY_INTEGER;
1691: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
1692: INDEX BY BINARY_INTEGER;
1693: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE
1694: INDEX BY BINARY_INTEGER;
1695: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE
1696: INDEX BY BINARY_INTEGER;
1697:

Line 2185: SELECT AP_INVOICES_INTERFACE_S.nextval

2181: IF g_debug_switch = 'Y' THEN
2182: fnd_file.put_line(fnd_file.log, l_debug_info);
2183: END IF;
2184:
2185: SELECT AP_INVOICES_INTERFACE_S.nextval
2186: INTO l_invoice_rec.invoice_id
2187: FROM DUAL;
2188:
2189:

Line 2509: FROM ap_invoices I,

2505: SELECT nvl(sum(decode(payment_status_flag, 'Y',
2506: decode(sign(earliest_settlement_date - sysdate),1,0,1),
2507: 0)), 0)
2508: INTO l_available_prepays
2509: FROM ap_invoices I,
2510: ap_suppliers PV
2511: WHERE exists (SELECT 'x'
2512: FROM ap_invoice_distributions aid
2513: WHERE aid.invoice_id = i.invoice_id

Line 2538: FROM ap_invoices I,

2534: SELECT nvl(sum(decode(payment_status_flag, 'Y',
2535: decode(sign(earliest_settlement_date - sysdate),1,0,1),
2536: 0)), 0)
2537: INTO l_available_prepays
2538: FROM ap_invoices I,
2539: ap_suppliers PV
2540: WHERE exists (SELECT 'x'
2541: FROM ap_invoice_distributions aid
2542: WHERE aid.invoice_id = i.invoice_id

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

2611:
2612:
2613:
2614: ----------------------------------------------------------
2615: l_debug_info := 'Insert into AP Invoices Interface table';
2616: ----------------------------------------------------------
2617: IF g_debug_switch = 'Y' THEN
2618: fnd_file.put_line(fnd_file.log, l_debug_info);
2619: END IF;

Line 2934: WHERE parent_table = 'AP_INVOICES_INTERFACE'

2930: END IF;
2931:
2932: --Bug#8464009 - Deleting records from Interface tables that are left out by IMPORT_PURGE
2933: DELETE FROM ap_interface_rejections
2934: WHERE parent_table = 'AP_INVOICES_INTERFACE'
2935: AND parent_id IN (SELECT invoice_id
2936: FROM ap_invoices_interface
2937: WHERE request_id = l_request_id
2938: );

Line 2936: FROM ap_invoices_interface

2932: --Bug#8464009 - Deleting records from Interface tables that are left out by IMPORT_PURGE
2933: DELETE FROM ap_interface_rejections
2934: WHERE parent_table = 'AP_INVOICES_INTERFACE'
2935: AND parent_id IN (SELECT invoice_id
2936: FROM ap_invoices_interface
2937: WHERE request_id = l_request_id
2938: );
2939:
2940: DELETE FROM ap_interface_rejections

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 2950: FROM ap_invoices_interface

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: );
2953:
2954: DELETE FROM ap_invoices_interface

Line 2954: DELETE FROM ap_invoices_interface

2950: FROM ap_invoices_interface
2951: WHERE request_id = l_request_id
2952: );
2953:
2954: DELETE FROM ap_invoices_interface
2955: WHERE request_id = l_request_id;
2956:
2957: END IF; /* l_expenses_fetched <> 0 */
2958:

Line 3246: INSERT INTO AP_INVOICES_INTERFACE

3242: EXCEPTION
3243: WHEN OTHERS THEN
3244: l_payment_priority := NULL;
3245: END;
3246: INSERT INTO AP_INVOICES_INTERFACE
3247: (INVOICE_ID,
3248: APPLICATION_ID,
3249: PRODUCT_TABLE,
3250: REFERENCE_KEY1,