DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_BATCHES_ALL

Line 2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b

2134: doc_sequence_value,org_id)
2135: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2136: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2137: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2139: WHERE i.vendor_site_id = v.vendor_site_id
2140: AND i.batch_id = b.batch_id (+)
2141: AND i.invoice_id IN (SELECT PL.invoice_id
2142: FROM ap_purge_invoice_list PL