DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 3069: FROM ap_supplier_sites_all site

3065: cp_org_id IN NUMBER
3066: ) IS
3067: SELECT 1,
3068: vendor_site_id
3069: FROM ap_supplier_sites_all site
3070: WHERE vendor_id = cp_vendor_id
3071: AND vendor_site_code = cp_vendor_site_code;
3072: --Bug 14400745 Remove below condition since it will not allow user update any inactive sites
3073: --AND (site.inactive_date > SYSDATE OR site.inactive_date IS NULL);

Line 9038: FROM ap_supplier_sites_all site,

9034: SELECT vendor_site_id,
9035: party_site_id
9036: INTO l_vendor_site_id,
9037: l_party_site_id
9038: FROM ap_supplier_sites_all site,
9039: ap_suppliers vendor
9040: WHERE vendor.vendor_id = site.vendor_id
9041: AND (site.inactive_date > SYSDATE OR site.inactive_date IS NULL)
9042: AND vendor.party_id = l_party_id