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_CAPITAL dependencies on AP_INVOICES_ALL

Line 36: ap_invoices_all ai

32: SELECT 'VENDOR INVOICE PENDING'
33: FROM dual
34: WHERE EXISTS ( SELECT aid.invoice_id
35: FROM ap_invoice_distributions_all aid,
36: ap_invoices_all ai
37: WHERE aid.project_id = p_project_id
38: AND aid.invoice_id = ai.invoice_id
39: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT'
40: AND (p_active_flag = 'C' or

Line 185: ap_invoices_all ai

181: UNION /* Added for bug 2553822 */
182: /* Bug 2598071 SELECT aid.invoice_id */
183: SELECT aid.invoice_id
184: FROM ap_invoice_distributions_all aid,
185: ap_invoices_all ai
186: WHERE aid.project_id = p_project_id
187: AND aid.invoice_id = ai.invoice_id
188: AND ai.source <> 'Oracle Project Accounting'
189: AND ai.invoice_type_lookup_code = 'EXPENSE REPORT'