APPS.MSC_SATP_FUNC dependencies on WSH_REGIONS

Line 1763: FROM WSH_REGIONS_V';

1759: FOR i in REVERSE 0..3 LOOP
1760:
1761: BEGIN
1762: l_stmt := 'SELECT region_id
1763: FROM WSH_REGIONS_V';
1764:
1765: -- Bug 3010834: Backport bug 2882331 to 11.5.9 to be included in I.1
1766: IF l_cnt <= 3 THEN
1767: IF l_country_length <= 3 THEN

Line 1884: FROM WSH_REGIONS

1880: region_id,
1881: region_type,
1882: ''N'',
1883: :partner_type
1884: FROM WSH_REGIONS
1885: START WITH region_id = :l_region_id
1886: CONNECT BY PRIOR parent_region_id = region_id)';
1887:
1888: IF PG_DEBUG in ('Y', 'C') THEN

Line 1909: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b

1905: a.region_id,
1906: a.zone_level,
1907: ''Y'',
1908: :partner_type
1909: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b
1910: WHERE a.region_id = b.parent_region_id
1911: AND a.region_type = 10
1912: AND a.zone_level IS NOT NULL
1913: AND b.region_id IN (

Line 2409: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b,

2405: a.region_id,
2406: a.zone_level,
2407: :l_YES,
2408: :partner_type
2409: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b,
2410: MSC_REGIONS_TEMP' || l_dynstring || ' c
2411: WHERE a.region_id = b.parent_region_id
2412: AND a.region_type = 10
2413: AND a.zone_level IS NOT NULL

Line 2440: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b, MSC_REGIONS_TEMP c

2436: a.region_id,
2437: a.zone_level,
2438: l_YES,
2439: l_customer_type
2440: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b, MSC_REGIONS_TEMP c
2441: WHERE a.region_id = b.parent_region_id
2442: AND a.region_type = 10
2443: AND a.zone_level IS NOT NULL
2444: AND b.region_id = c.region_id

Line 2463: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b, MSC_REGIONS_TEMP c

2459: a.region_id,
2460: a.zone_level,
2461: l_YES,
2462: l_customer_type
2463: FROM WSH_REGIONS a, WSH_ZONE_REGIONS b, MSC_REGIONS_TEMP c
2464: WHERE a.region_id = b.parent_region_id
2465: AND a.region_type = 10
2466: AND a.zone_level IS NOT NULL
2467: AND b.region_id = c.region_id