DBA Data[Home] [Help]

APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_SUPPLIER_SITES

Line 421: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES */

417: p_source => 'CDROM',
418: p_effective_date => l_date
419: );
420:
421: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES */
422: Igi_cis2007_igipverp_pkg.pr_po_api(l_vendor_id,
423: NULL,
424: l_matched_flag,
425: l_date,

Line 486: ap_supplier_sites pvs,

482: atr.tax_rate tax_rate,
483: pvs.vendor_site_code site_code,
484: nvl(inv.inv_count,0) inv_count
485: From ap_suppliers pv,
486: ap_supplier_sites pvs,
487: ap_awt_tax_rates atr,
488: (Select count(distinct(aps.invoice_id)) inv_count,
489: api.vendor_id,
490: api.vendor_site_id