APPS.OZF_SD_BATCH_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 475: FROM ap_supplier_sites_all sites,

471:
472: --org id Code added for bug#6867618
473: CURSOR get_sites(c_vendor_id NUMBER,c_org_id NUMBER) IS
474: SELECT sites.vendor_site_id
475: FROM ap_supplier_sites_all sites,
476: ozf_supp_trd_prfls_all trprf
477: WHERE sites.vendor_id = c_vendor_id AND
478: sites.org_id = c_org_id AND
479: nvl(sites.inactive_date, sysdate) >= trunc(sysdate) AND

Line 526: From ap_supplier_sites_all

522:
523: --Code added for output log supplier name
524: Select vendor_site_code
525: into l_sup_site_name
526: From ap_supplier_sites_all
527: Where vendor_site_id = l_supplier_site_id;
528:
529: --Code added for bug#6971836
530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Supplier Name =' || l_supplier_name||'('||l_supplier_id||