APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_INVOICES

Line 492: ap_invoices api

488: (Select count(distinct(aps.invoice_id)) inv_count,
489: api.vendor_id,
490: api.vendor_site_id
491: From ap_payment_schedules aps,
492: ap_invoices api
493: Where aps.amount_remaining > 0
494: And api.invoice_id = aps.invoice_id
495: Group by api.vendor_id, api.vendor_site_id) inv
496: Where (pv.partnership_utr = P_Utr