DBA Data[Home] [Help]

APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_INVOICES

Line 490: ap_invoices api

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