APPS.MSC_SATP_FUNC dependencies on WSH_REGION_LOCATIONS

Line 2254: FROM WSH_REGION_LOCATIONS

2250: region_id,
2251: region_type,
2252: :l_NO,
2253: :partner_type
2254: FROM WSH_REGION_LOCATIONS
2255: WHERE location_id IN
2256: (SELECT LOC.LOCATION_ID
2257: FROM HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2258: HZ_PARTY_SITES PARTY_SITE,

Line 2278: FROM WSH_REGION_LOCATIONS

2274: -- also update Partner_type for supplier intransit LT project
2275: INSERT INTO msc_regions_temp
2276: (session_id, partner_site_id, region_id, region_type, zone_flag, partner_type)
2277: SELECT p_session_id, p_customer_site_id, region_id, region_type, l_NO, l_customer_type
2278: FROM WSH_REGION_LOCATIONS
2279: WHERE location_id IN
2280: (SELECT LOC.LOCATION_ID
2281: FROM HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2282: HZ_PARTY_SITES PARTY_SITE,

Line 2299: FROM WSH_REGION_LOCATIONS WRL,

2295:
2296: INSERT INTO msc_regions_temp
2297: (session_id, partner_site_id, region_id, region_type, zone_flag, partner_type)
2298: SELECT p_session_id, p_customer_site_id, wrl.region_id, wrl.region_type, l_NO, l_partner_type --2814895
2299: FROM WSH_REGION_LOCATIONS WRL,
2300: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2301: HZ_PARTY_SITES PARTY_SITE,
2302: HZ_LOCATIONS LOC,
2303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2323: FROM WSH_REGION_LOCATIONS WRL,

2319:
2320: INSERT INTO msc_regions_temp
2321: (session_id,partner_site_id,region_id,region_type,zone_flag, partner_type) --2814895
2322: SELECT p_session_id,p_party_site_id,wrl.region_id,wrl.region_type,l_NO,l_partner_type
2323: FROM WSH_REGION_LOCATIONS WRL,
2324: HZ_PARTY_SITES PARTY_SITE
2325: WHERE WRL.location_id = PARTY_SITE.LOCATION_ID
2326: AND PARTY_SITE.party_site_id = p_party_site_id
2327: AND WRL.location_source = l_HZ

Line 2353: FROM WSH_REGION_LOCATIONS

2349: region_id,
2350: region_type,
2351: :l_NO,
2352: :partner_type
2353: FROM WSH_REGION_LOCATIONS
2354: WHERE location_id = :p_location_id
2355: AND location_source = :p_location_source
2356: AND region_id is not null'; --2837468
2357:

Line 2371: FROM WSH_REGION_LOCATIONS

2367: -- also update Partner_type for supplier intransit LT project
2368: INSERT INTO msc_regions_temp
2369: (session_id, partner_site_id, region_id, region_type, zone_flag, partner_type)
2370: SELECT p_session_id, -1, region_id, region_type, l_NO, l_customer_type
2371: FROM WSH_REGION_LOCATIONS
2372: WHERE location_id = p_location_id
2373: AND location_source = p_location_source
2374: AND region_id is not null; --2837468
2375:

Line 2382: FROM WSH_REGION_LOCATIONS

2378: -- also update Partner_type for supplier intransit LT project
2379: INSERT INTO msc_regions_temp
2380: (session_id, partner_site_id, region_id, region_type, zone_flag, partner_type)
2381: SELECT p_session_id, -1, region_id, region_type, l_NO, l_customer_type --2814895
2382: FROM WSH_REGION_LOCATIONS
2383: WHERE location_id = p_location_id
2384: AND location_source = p_location_source
2385: AND region_id is not null; --2837468
2386:

Line 2884: from wsh_region_locations

2880: else
2881: -- bug 2974334. Change the SQL into static
2882: select 1
2883: into l_temp_var
2884: from wsh_region_locations
2885: where rownum = 1;
2886:
2887: end if;
2888: exception