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_APXT7UTT_XMLP_PKG dependencies on AP_INVOICE_PAYMENTS

Line 316: FROM AP_Invoices i, AP_Invoice_Payments ip

312: UPDATE ap_invoice_distributions id
313: SET type_1099 = type_1099
314: WHERE nvl(type_1099,1) <> nvl(type_1099,1)
315: AND invoice_id in (SELECT i.invoice_id
316: FROM AP_Invoices i, AP_Invoice_Payments ip
317: WHERE i.vendor_id = vendor_id
318: AND i.invoice_id = ip.invoice_id
319: AND nvl(ip.accounting_date,sysdate) between
320: P_start_date and

Line 353: FROM AP_Invoices i, AP_Invoice_Payments ip

349: AND NVL(id.income_tax_region, 'DuMmY') <> P_region_code)
350: OR (P_region_code = 'VENDOR SITE'
351: AND NVL(id.income_tax_region, 'DuMmY') <> l_region))
352: AND id.invoice_id in (SELECT i.invoice_id
353: FROM AP_Invoices i, AP_Invoice_Payments ip
354: WHERE i.vendor_id = vendor_id_R
355: AND i.vendor_site_id = site_id_R
356: AND i.invoice_id = ip.invoice_id
357: AND nvl(ip.accounting_date,sysdate) between

Line 367: FROM AP_Invoices i, AP_Invoice_Payments ip

363: from po_vendor_sites pvs
364: where pvs.tax_reporting_site_flag= 'Y'
365: and pvs.vendor_id=vendor_id_R)
366: WHERE id.invoice_id in (SELECT i.invoice_id
367: FROM AP_Invoices i, AP_Invoice_Payments ip
368: WHERE i.vendor_id = vendor_id_R
369: AND i.vendor_site_id = site_id_R
370: AND i.invoice_id = ip.invoice_id
371: AND nvl(ip.accounting_date,sysdate) between