DBA Data[Home] [Help]

APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_SUPPLIER_SITES

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

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

Line 484: ap_supplier_sites pvs,

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