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_CARRIERS

Line 1420: FROM wsh_carriers

1416: and mdd.organization_id = msitl.organization_id
1417: and msitl.language = userenv('LANG');
1418: --carrier name
1419: SELECT freight_code into l_temp1
1420: FROM wsh_carriers
1421: WHERE carrier_id = l_id2;
1422: fnd_message.set_token('TRIP_NUMBER', l_id1);
1423: fnd_message.set_token('DELIVERY_DETAIL_ID', l_id3);
1424: fnd_message.set_token('CARRIER_NAME', l_temp1);

Line 1487: FROM wsh_carriers

1483: fnd_message.set_token('END_DATE', l_temp2);
1484: fnd_message.set_token('SHORTFALL', l_temp3);
1485: --Carrier name
1486: SELECT freight_code INTO l_temp
1487: FROM wsh_carriers
1488: WHERE carrier_id = l_id2;
1489: fnd_message.set_token('CARRIER', l_temp);
1490: --get Lane_Number
1491: select LANE

Line 1531: FROM wsh_carriers

1527: WHERE plan_id = P_PLAN_ID
1528: AND trip_id = P_TRIP_ID;
1529: --carrier name
1530: SELECT freight_code INTO l_temp
1531: FROM wsh_carriers
1532: WHERE carrier_id = l_id2;
1533: fnd_message.set_token('CARRIER_NAME', l_temp);
1534: fnd_message.set_token('TRIP_NUMBER', l_id1);
1535: l_message := fnd_message.get;

Line 1667: FROM wsh_carriers

1663: AND trip_id = P_TRIP_ID;
1664: fnd_message.set_token('TRIP_NUMBER', l_id4);
1665:
1666: SELECT freight_code INTO l_temp
1667: FROM wsh_carriers
1668: WHERE carrier_id = l_id1;
1669: fnd_message.set_token('FREIGHT_CODE', l_temp);
1670:
1671: SELECT city INTO l_temp

Line 1716: FROM wsh_carriers

1712: AND trip_id = P_TRIP_ID;
1713: fnd_message.set_token('TRIP_NUMBER', l_id4);
1714:
1715: SELECT freight_code INTO l_temp
1716: FROM wsh_carriers
1717: WHERE carrier_id = l_id1;
1718: fnd_message.set_token('FREIGHT_CODE', l_temp);
1719:
1720: SELECT city INTO l_temp

Line 1807: FROM wsh_carriers

1803: AND trip_id = P_TRIP_ID;
1804: fnd_message.set_token('TRIP_NUMBER', l_id4);
1805:
1806: SELECT freight_code INTO l_temp
1807: FROM wsh_carriers
1808: WHERE carrier_id = l_id1;
1809: fnd_message.set_token('FREIGHT_CODE', l_temp);
1810:
1811: SELECT city INTO l_temp

Line 1844: FROM wsh_carriers

1840: AND trip_id = P_TRIP_ID;
1841: fnd_message.set_token('TRIP_NUMBER', l_id4);
1842:
1843: SELECT freight_code INTO l_temp
1844: FROM wsh_carriers
1845: WHERE carrier_id = l_id1;
1846: fnd_message.set_token('FREIGHT_CODE', l_temp);
1847:
1848: SELECT city INTO l_temp

Line 1877: FROM wsh_carriers

1873: fnd_message.set_token('ACTUAL_DEADHEAD_DISTANCE', l_id3);
1874: fnd_message.set_token('MAX_DEADHEAD_DISTANCE', l_id4);
1875:
1876: SELECT freight_code INTO l_temp
1877: FROM wsh_carriers
1878: WHERE carrier_id = l_id1;
1879: fnd_message.set_token('FREIGHT_CODE', l_temp);
1880:
1881: SELECT cm_trip_number, start_location_id, end_location_id

Line 2085: FROM wsh_carriers

2081: fnd_message.set_token('TRIP_NUMBER', l_id1);
2082:
2083: SELECT freight_code
2084: INTO l_temp
2085: FROM wsh_carriers
2086: WHERE carrier_id = l_id4;
2087: fnd_message.set_token('FREIGHT_CODE', l_temp);
2088:
2089: SELECT city

Line 2103: FROM wsh_carriers wc,

2099: fnd_message.set_token('DESTINATION_CITY', l_temp);
2100:
2101: SELECT wc.freight_code, round(nvl(med.number1, 0))
2102: INTO l_temp, l_id1
2103: FROM wsh_carriers wc,
2104: mst_exception_details med
2105: WHERE med.plan_id = P_PLAN_ID
2106: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID
2107: AND med.carrier_id = wc.carrier_id;

Line 2243: wsh_carriers wc

2239:
2240: SELECT wc.freight_code
2241: INTO l_temp
2242: FROM mst_exception_details med,
2243: wsh_carriers wc
2244: WHERE med.plan_id = P_PLAN_ID
2245: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID
2246: AND med.carrier_id = wc.carrier_id;
2247: fnd_message.set_token('FREIGHT_CODE', l_temp);

Line 2273: FROM wsh_carriers wc

2269: fnd_message.set_token('TRIP_NUMBER', l_id1);
2270:
2271: SELECT wc.freight_code
2272: INTO l_temp
2273: FROM wsh_carriers wc
2274: WHERE wc.carrier_id = l_id2;
2275: fnd_message.set_token('FREIGHT_CODE', l_temp);
2276:
2277: SELECT flp.description

Line 4437: FROM wsh_carriers

4433: WHERE wsh_location_id = p_location_id;
4434:
4435: CURSOR l_carrier_cur (p_carrier_id IN NUMBER) IS
4436: SELECT freight_code
4437: FROM wsh_carriers
4438: WHERE carrier_id = p_carrier_id;
4439:
4440: CURSOR l_uom_cur IS
4441: SELECT distance_uom, weight_uom, volume_uom

Line 4926: FROM wsh_carriers

4922: fnd_message.set_token('ITEM_DESCRIPTION', l_str2);
4923:
4924: --carrier name
4925: SELECT freight_code into l_str3
4926: FROM wsh_carriers
4927: WHERE carrier_id = l_id3;
4928: fnd_message.set_token('CARRIER_NAME', l_str3);
4929:
4930: l_message := fnd_message.get;

Line 5013: FROM wsh_carriers

5009: fnd_message.set_token('SHORTFALL', round(l_id5));
5010:
5011: --Carrier name
5012: SELECT freight_code INTO l_str1
5013: FROM wsh_carriers
5014: WHERE carrier_id = l_id1;
5015: fnd_message.set_token('CARRIER', l_str1);
5016:
5017: --get Lane_Number

Line 5147: FROM wsh_carriers

5143: fnd_message.set_token('FACILITY_DESCRIPTION', l_str1);
5144:
5145: --carrier name
5146: SELECT freight_code INTO l_str2
5147: FROM wsh_carriers
5148: WHERE carrier_id = l_id4;
5149: fnd_message.set_token('CARRIER_NAME', l_str2);
5150:
5151: l_message := fnd_message.get;