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_PMT_VALIDATIONS_PKG dependencies on AP_SELECTED_INVOICES_ALL

Line 108: from ap_selected_invoices_all asi

104: /* Number of selected invoices that should result in interest invoices: */
105:
106: select count(*)
107: into l_int_inv_expected_count
108: from ap_selected_invoices_all asi
109: , iby_fd_docs_payable_v ibydocs
110: where asi.original_invoice_id is not null
111: and ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(asi.checkrun_id)
112: and ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(asi.invoice_id)

Line 123: ap_selected_invoices_all apsi,

119: INTO l_int_inv_actual_count
120: FROM iby_fd_payments_v ibypmts,
121: iby_fd_docs_payable_v ibydocs,
122: ap_supplier_sites_all aps,
123: ap_selected_invoices_all apsi,
124: ap_invoices_all orig
125: WHERE ibypmts.payment_id = ibydocs.payment_id
126: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
127: --AND ibypmts.org_id = :l_current_org_id

Line 152: ap_selected_invoices_all apsi,

148: INTO l_int_line_actual_count
149: FROM iby_fd_payments_v ibypmts,
150: iby_fd_docs_payable_v ibydocs,
151: po_vendors pv,
152: ap_selected_invoices_all apsi,
153: ap_invoices_all orig
154: WHERE ibypmts.payment_id = ibydocs.payment_id
155: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
156: --AND ibypmts.org_id = :l_current_org_id

Line 262: ap_selected_invoices_all SI,

258: SELECT COUNT(*) ap_pmt_sch_count
259: INTO l_ap_pmtsch_count
260: FROM iby_fd_payments_v ibypmts,
261: iby_fd_docs_payable_v ibydocs,
262: ap_selected_invoices_all SI,
263: fnd_currencies FORE,
264: ap_payment_schedules_all PS,
265: ap_invoices_all AI
266: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(si.checkrun_id)

Line 340: , ap_selected_invoices_all apsi

336:
337: select count(*)
338: into l_err_count
339: from ap_invoices_all ai
340: , ap_selected_invoices_all apsi
341: , iby_fd_docs_payable_v ibydocs
342: where ai.source in ( 'Both Pay')
343: and (nvl(ai.paid_on_behalf_employee_id, -1) <> -1
344: or ai.invoice_type_lookup_code = 'EXPENSE REPORT')

Line 405: ap_selected_invoices_all SI,

401: SELECT COUNT(*)
402: INTO l_err_count
403: FROM iby_fd_payments_v ibypmts,
404: iby_fd_docs_payable_v ibydocs,
405: ap_selected_invoices_all SI,
406: ap_awt_temp_distributions_all atd
407: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(si.checkrun_id)
408: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(si.invoice_id)
409: AND ibydocs.calling_app_doc_unique_ref3 = TO_CHAR(si.payment_num)