APPS.OZF_SD_BATCH_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 609: FROM ap_supplier_sites_all sites,

605:
606: --org id Code added for bug#6867618
607: CURSOR get_sites(c_vendor_id NUMBER,c_org_id NUMBER) IS
608: SELECT sites.vendor_site_id
609: FROM ap_supplier_sites_all sites,
610: ozf_supp_trd_prfls_all trprf
611: WHERE sites.vendor_id = c_vendor_id AND
612: sites.org_id = c_org_id AND
613: nvl(sites.inactive_date, sysdate) >= trunc(sysdate) AND

Line 660: From ap_supplier_sites_all

656:
657: --Code added for output log supplier name
658: Select vendor_site_code
659: into l_sup_site_name
660: From ap_supplier_sites_all
661: Where vendor_site_id = l_supplier_site_id;
662:
663: --Code added for bug#6971836
664: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Supplier Name =' || l_supplier_name||'('||l_supplier_id||

Line 3694: FROM ap_supplier_sites_all sites,

3690:
3691:
3692: CURSOR get_supplier_sites(c_org_id NUMBER,c_vendor_id NUMBER,c_vendor_site_id NUMBER) IS
3693: SELECT sites.vendor_id, sites.vendor_site_id
3694: FROM ap_supplier_sites_all sites,
3695: ozf_supp_trd_prfls_all trprf
3696: WHERE sites.org_id = NVL(c_org_id,sites.org_id) AND
3697: sites.vendor_id = NVL(c_vendor_id,sites.vendor_id) AND
3698: sites.vendor_site_id = NVL(c_vendor_site_id,sites.vendor_site_id) AND