eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_ZONE_REGIONS

Line 2232: wsh_zone_regions z

2228: null,
2229: 'N'
2230: FROM wsh_regions r,
2231: wsh_regions_tl rt,
2232: wsh_zone_regions z
2233: WHERE r.region_id = z.parent_region_id AND
2234: z.region_id = l_region_id AND
2235: r.region_type = 10 AND
2236: rt.region_id = r.region_id AND

Line 2846: FROM wsh_zone_regions wzr,wsh_regions wr

2842: x_return_status OUT NOCOPY VARCHAR2) IS
2843:
2844: CURSOR c_get_zone_for_region(c_region_id IN NUMBER) IS
2845: SELECT wr.region_id
2846: FROM wsh_zone_regions wzr,wsh_regions wr
2847: WHERE wzr.region_id = c_region_id
2848: AND zone_flag = 'Y'
2849: AND wzr.parent_region_id = wr.region_id
2850: AND wr.region_type=10;

Line 3004: FROM wsh_zone_regions wzr,wsh_regions wr

3000: SELECT wr.region_id,
3001: --null,
3002: wr.region_type,
3003: wr.deconsol_location_id
3004: FROM wsh_zone_regions wzr,wsh_regions wr
3005: WHERE wzr.region_id = c_region_id
3006: AND zone_flag = 'Y'
3007: AND wzr.parent_region_id = wr.region_id
3008: AND wr.region_type=10