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.PA_PURGE_VALIDATE_COSTING dependencies on AP_INVOICES

Line 249: FROM ap_invoices_all ai,

245: CURSOR IsVIPaymentPendg IS
246: SELECT 'VENDOR INVOICE NOT FULLY PAID'
247: FROM dual
248: WHERE EXISTS ( SELECT aid.invoice_id
249: FROM ap_invoices_all ai,
250: ap_invoice_distributions_all aid
251: -- bug 2404115 WHERE ai.project_id = p_project_id
252: WHERE aid.project_id = p_project_id
253: AND nvl(ai.invoice_amount,0) <> 0 /* Bug 5063560 */

Line 291: select null from ap_invoices ai,

287: cursor ISDistLinesIntfed IS
288: select 'Discount Not Interfaced'
289: from dual
290: where exists (
291: select null from ap_invoices ai,
292: ap_invoice_distributions aid,
293: -- ap_invoice_payments pay --R12 change
294: ap_payment_hist_dists paydist
295: where aid.project_id = p_project_id

Line 385: FROM ap_invoices_all ai,

381: cursor IsERPaymentPendg IS
382: SELECT 'EXPENSE REPORTS NOT FULLY PAID'
383: FROM dual
384: WHERE EXISTS ( SELECT aid.invoice_id
385: FROM ap_invoices_all ai,
386: ap_invoice_distributions_all aid
387: WHERE aid.project_id = p_project_id
388: AND ai.invoice_id = aid.invoice_id
389: AND ai.invoice_type_lookup_code = 'EXPENSE REPORT'