APPS.PA_PURGE_VALIDATE_COSTING dependencies on AP_INVOICE_DISTRIBUTIONS

Line 250: ap_invoice_distributions_all aid

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 */
254: AND ai.invoice_id = aid.invoice_id

Line 292: ap_invoice_distributions aid,

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
296: and ai.invoice_id = aid.invoice_id

Line 375: from ap_invoice_distributions d

371: and l.report_header_id = h.report_header_id
372: and h.source <> 'Oracle Project Accounting'
373: and not exists (
374: select null
375: from ap_invoice_distributions d
376: where d.invoice_id = h.vouchno
377: and d.pa_addition_flag IN ('Z','T','E','Y')));
378:
379:

Line 386: ap_invoice_distributions_all aid

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'
390: AND (p_active_flag <> 'A' or