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.MST_WB_UTIL dependencies on WSH_LOCATIONS

Line 1672: FROM wsh_locations

1668: WHERE carrier_id = l_id1;
1669: fnd_message.set_token('FREIGHT_CODE', l_temp);
1670:
1671: SELECT city INTO l_temp
1672: FROM wsh_locations
1673: WHERE wsh_location_id = l_id2;
1674: fnd_message.set_token('ORIGIN_CITY', l_temp);
1675:
1676: SELECT city INTO l_temp

Line 1677: FROM wsh_locations

1673: WHERE wsh_location_id = l_id2;
1674: fnd_message.set_token('ORIGIN_CITY', l_temp);
1675:
1676: SELECT city INTO l_temp
1677: FROM wsh_locations
1678: WHERE wsh_location_id = l_id3;
1679: fnd_message.set_token('DESTINATION_CITY', l_temp);
1680:
1681: SELECT distance_uom

Line 1721: FROM wsh_locations

1717: WHERE carrier_id = l_id1;
1718: fnd_message.set_token('FREIGHT_CODE', l_temp);
1719:
1720: SELECT city INTO l_temp
1721: FROM wsh_locations
1722: WHERE wsh_location_id = l_id2;
1723: fnd_message.set_token('ORIGIN_CITY', l_temp);
1724:
1725: SELECT city INTO l_temp

Line 1726: FROM wsh_locations

1722: WHERE wsh_location_id = l_id2;
1723: fnd_message.set_token('ORIGIN_CITY', l_temp);
1724:
1725: SELECT city INTO l_temp
1726: FROM wsh_locations
1727: WHERE wsh_location_id = l_id3;
1728: fnd_message.set_token('DESTINATION_CITY', l_temp);
1729:
1730: SELECT nvl(round(wcs.max_driving_time_in_24hr),0)

Line 1812: FROM wsh_locations

1808: WHERE carrier_id = l_id1;
1809: fnd_message.set_token('FREIGHT_CODE', l_temp);
1810:
1811: SELECT city INTO l_temp
1812: FROM wsh_locations
1813: WHERE wsh_location_id = l_id2;
1814: fnd_message.set_token('ORIGIN_CITY', l_temp);
1815:
1816: SELECT city INTO l_temp

Line 1817: FROM wsh_locations

1813: WHERE wsh_location_id = l_id2;
1814: fnd_message.set_token('ORIGIN_CITY', l_temp);
1815:
1816: SELECT city INTO l_temp
1817: FROM wsh_locations
1818: WHERE wsh_location_id = l_id3;
1819: fnd_message.set_token('DESTINATION_CITY', l_temp);
1820: l_message := fnd_message.get;
1821: ELSIF P_LINE_NUM = 2 THEN

Line 1849: FROM wsh_locations

1845: WHERE carrier_id = l_id1;
1846: fnd_message.set_token('FREIGHT_CODE', l_temp);
1847:
1848: SELECT city INTO l_temp
1849: FROM wsh_locations
1850: WHERE wsh_location_id = l_id2;
1851: fnd_message.set_token('ORIGIN_CITY', l_temp);
1852:
1853: SELECT city INTO l_temp

Line 1854: FROM wsh_locations

1850: WHERE wsh_location_id = l_id2;
1851: fnd_message.set_token('ORIGIN_CITY', l_temp);
1852:
1853: SELECT city INTO l_temp
1854: FROM wsh_locations
1855: WHERE wsh_location_id = l_id3;
1856: fnd_message.set_token('DESTINATION_CITY', l_temp);
1857: l_message := fnd_message.get;
1858: END IF;

Line 1889: FROM wsh_locations

1885: AND continuous_move_id = l_id2;
1886: fnd_message.set_token('CM_TRIP_NUMBER', l_id1);
1887:
1888: SELECT city INTO l_temp
1889: FROM wsh_locations
1890: WHERE wsh_location_id = l_id3;
1891: fnd_message.set_token('ORIGIN_CITY', l_temp);
1892:
1893: SELECT city INTO l_temp

Line 1894: FROM wsh_locations

1890: WHERE wsh_location_id = l_id3;
1891: fnd_message.set_token('ORIGIN_CITY', l_temp);
1892:
1893: SELECT city INTO l_temp
1894: FROM wsh_locations
1895: WHERE wsh_location_id = l_id4;
1896: fnd_message.set_token('DESTINATION_CITY', l_temp);
1897: l_message := fnd_message.get;
1898: END IF;

Line 1910: FROM wsh_locations

1906: AND trip_id = P_TRIP_ID;
1907: fnd_message.set_token('TRIP_NUMBER', l_id4);
1908:
1909: SELECT city INTO l_temp
1910: FROM wsh_locations
1911: WHERE wsh_location_id = l_id2;
1912: fnd_message.set_token('ORIGIN_CITY', l_temp);
1913:
1914: SELECT city INTO l_temp

Line 1915: FROM wsh_locations

1911: WHERE wsh_location_id = l_id2;
1912: fnd_message.set_token('ORIGIN_CITY', l_temp);
1913:
1914: SELECT city INTO l_temp
1915: FROM wsh_locations
1916: WHERE wsh_location_id = l_id3;
1917: fnd_message.set_token('DESTINATION_CITY', l_temp);
1918: l_message := fnd_message.get;
1919: END IF;

Line 1942: FROM wsh_locations

1938: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1939: fnd_message.set_token('STOP_SEQUENCE_NUMBER', l_id2);
1940:
1941: SELECT city INTO l_temp
1942: FROM wsh_locations
1943: WHERE wsh_location_id = l_id3;
1944: fnd_message.set_token('CITY', l_temp);
1945:
1946: l_message := fnd_message.get;

Line 1968: FROM wsh_locations

1964: AND med.plan_id = P_PLAN_ID
1965: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1966:
1967: SELECT city INTO l_temp
1968: FROM wsh_locations
1969: WHERE wsh_location_id = l_id1;
1970: fnd_message.set_token('ORIGIN_CITY', l_temp);
1971: fnd_message.set_token('REQUIRED_TRANSIT_TIME', l_id3);
1972:

Line 1983: FROM wsh_locations

1979: AND med.plan_id = P_PLAN_ID
1980: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;
1981:
1982: SELECT city INTO l_temp
1983: FROM wsh_locations
1984: WHERE wsh_location_id = l_id3;
1985: fnd_message.set_token('DESTINATION_CITY', l_temp);
1986:
1987: l_id1 := round(((l_date2 - l_date1) * 24));

Line 2091: FROM wsh_locations

2087: fnd_message.set_token('FREIGHT_CODE', l_temp);
2088:
2089: SELECT city
2090: INTO l_temp
2091: FROM wsh_locations
2092: WHERE wsh_location_id = l_id2;
2093: fnd_message.set_token('ORIGIN_CITY', l_temp);
2094:
2095: SELECT city

Line 2097: FROM wsh_locations

2093: fnd_message.set_token('ORIGIN_CITY', l_temp);
2094:
2095: SELECT city
2096: INTO l_temp
2097: FROM wsh_locations
2098: WHERE wsh_location_id = l_id3;
2099: fnd_message.set_token('DESTINATION_CITY', l_temp);
2100:
2101: SELECT wc.freight_code, round(nvl(med.number1, 0))

Line 4096: FROM wsh_locations wl

4092: , l_address
4093: , l_city
4094: , l_state
4095: , l_zip
4096: FROM wsh_locations wl
4097: WHERE wl.wsh_location_id = loc_id;
4098:
4099: IF ret_type = 'O' THEN
4100: l_ret_val := l_code;

Line 4432: FROM wsh_locations

4428: l_date2 date;
4429:
4430: CURSOR l_city_cur (p_location_id IN NUMBER) IS
4431: SELECT city
4432: FROM wsh_locations
4433: WHERE wsh_location_id = p_location_id;
4434:
4435: CURSOR l_carrier_cur (p_carrier_id IN NUMBER) IS
4436: SELECT freight_code

Line 5878: wsh_locations wsh,

5874:
5875: function get_city_code(p_location_id NUMBER) return VARCHAR2 IS
5876: Cursor city_code is
5877: select nvl(wr.city_code, wr.city) from
5878: wsh_locations wsh,
5879: wsh_region_locations wlr,
5880: wsh_regions_v wr
5881: where wsh.wsh_location_id = p_location_id
5882: and wsh.wsh_location_id = wlr.location_id

Line 5888: FROM wsh_locations wl

5884: and wlr.region_id = wr.region_id;
5885:
5886: CURSOR wsh_city_name IS
5887: SELECT substr(wl.city , 1, 10)
5888: FROM wsh_locations wl
5889: WHERE wsh_location_id = p_location_id;
5890:
5891: l_city_code VARCHAR2(60);
5892: BEGIN