APPS.WSH_PARTY_MERGE dependencies on WSH_LOCATIONS

Line 550: wsh_locations wl

546: SELECT 1
547: INTO l_query_count
548: FROM wsh_delivery_details wdd,
549: hz_party_Sites hps,
550: wsh_locations wl
551: WHERE hps.party_site_id = p_from_fk_id
552: AND wdd.ship_from_location_id = wl.wsh_location_id
553: AND hps.location_id = wl.source_location_id
554: AND wdd.party_id = hps.party_id

Line 1912: -- Check whether the To_Location exists in WSH_LOCATIONS table

1908: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location', WSH_DEBUG_SV.C_PROC_LEVEL);
1909: END IF;
1910: --
1911:
1912: -- Check whether the To_Location exists in WSH_LOCATIONS table
1913: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location(
1914: p_source_type => 'HZ',
1915: p_source_location_id => l_to_location_id,
1916: p_transfer_location => TRUE,