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.FTE_TL_CACHE dependencies on WSH_GLOBAL_PARAMETERS

Line 452: FROM wsh_global_parameters wgp;

448:
449: CURSOR get_pallet_item_type IS
450:
451: SELECT wgp.pallet_item_type
452: FROM wsh_global_parameters wgp;
453:
454:
455: CURSOR get_item_type(c_dtl_id IN NUMBER) IS
456: SELECT m.container_type_code

Line 2854: FROM wsh_global_parameters;

2850: WHERE wsh_location_id = c_location_id;
2851:
2852: CURSOR c_get_dis_emp_constant IS
2853: SELECT tl_hway_dis_emp_constant
2854: FROM wsh_global_parameters;
2855:
2856: CURSOR c_get_speed IS
2857: SELECT avg_hway_speed
2858: FROM wsh_global_parameters;

Line 2858: FROM wsh_global_parameters;

2854: FROM wsh_global_parameters;
2855:
2856: CURSOR c_get_speed IS
2857: SELECT avg_hway_speed
2858: FROM wsh_global_parameters;
2859:
2860: CURSOR c_get_distance_uom IS
2861: SELECT distance_uom
2862: FROM wsh_global_parameters;

Line 2862: FROM wsh_global_parameters;

2858: FROM wsh_global_parameters;
2859:
2860: CURSOR c_get_distance_uom IS
2861: SELECT distance_uom
2862: FROM wsh_global_parameters;
2863:
2864: CURSOR c_get_time_uom IS
2865: SELECT time_uom
2866: FROM wsh_global_parameters;

Line 2866: FROM wsh_global_parameters;

2862: FROM wsh_global_parameters;
2863:
2864: CURSOR c_get_time_uom IS
2865: SELECT time_uom
2866: FROM wsh_global_parameters;
2867:
2868: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
2869: l_api_name CONSTANT VARCHAR2(30) := 'get_approximate_distance_time';
2870: l_return_status VARCHAR2(1);

Line 12231: FROM wsh_global_parameters;

12227: x_return_status OUT NOCOPY Varchar2) IS
12228:
12229: CURSOR c_get_speed IS
12230: SELECT avg_hway_speed
12231: FROM wsh_global_parameters;
12232:
12233: CURSOR c_get_distance_uom IS
12234: SELECT distance_uom
12235: FROM wsh_global_parameters;

Line 12235: FROM wsh_global_parameters;

12231: FROM wsh_global_parameters;
12232:
12233: CURSOR c_get_distance_uom IS
12234: SELECT distance_uom
12235: FROM wsh_global_parameters;
12236:
12237: CURSOR c_get_time_uom IS
12238: SELECT time_uom
12239: FROM wsh_global_parameters;

Line 12239: FROM wsh_global_parameters;

12235: FROM wsh_global_parameters;
12236:
12237: CURSOR c_get_time_uom IS
12238: SELECT time_uom
12239: FROM wsh_global_parameters;
12240:
12241: l_average_speed_value NUMBER;
12242: l_speed_distance_uom VARCHAR2(30);
12243: l_speed_time_uom VARCHAR2(30);