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 DUAL

Line 2970: SELECT SIN(l_from_latitude_in_radians) INTO l_t1 FROM DUAL;

2966:
2967: l_from_latitude_in_radians := l_degrees_to_radians * l_from_latitude_in_degrees;
2968: l_to_latitude_in_radians := l_degrees_to_radians * l_to_latitude_in_degrees;
2969:
2970: SELECT SIN(l_from_latitude_in_radians) INTO l_t1 FROM DUAL;
2971: SELECT SIN(l_to_latitude_in_radians) INTO l_t2 FROM DUAL;
2972: SELECT COS(l_from_latitude_in_radians) INTO l_t3 FROM DUAL;
2973: SELECT COS(l_to_latitude_in_radians) INTO l_t4 FROM DUAL;
2974:

Line 2971: SELECT SIN(l_to_latitude_in_radians) INTO l_t2 FROM DUAL;

2967: l_from_latitude_in_radians := l_degrees_to_radians * l_from_latitude_in_degrees;
2968: l_to_latitude_in_radians := l_degrees_to_radians * l_to_latitude_in_degrees;
2969:
2970: SELECT SIN(l_from_latitude_in_radians) INTO l_t1 FROM DUAL;
2971: SELECT SIN(l_to_latitude_in_radians) INTO l_t2 FROM DUAL;
2972: SELECT COS(l_from_latitude_in_radians) INTO l_t3 FROM DUAL;
2973: SELECT COS(l_to_latitude_in_radians) INTO l_t4 FROM DUAL;
2974:
2975: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t1='||l_t1);

Line 2972: SELECT COS(l_from_latitude_in_radians) INTO l_t3 FROM DUAL;

2968: l_to_latitude_in_radians := l_degrees_to_radians * l_to_latitude_in_degrees;
2969:
2970: SELECT SIN(l_from_latitude_in_radians) INTO l_t1 FROM DUAL;
2971: SELECT SIN(l_to_latitude_in_radians) INTO l_t2 FROM DUAL;
2972: SELECT COS(l_from_latitude_in_radians) INTO l_t3 FROM DUAL;
2973: SELECT COS(l_to_latitude_in_radians) INTO l_t4 FROM DUAL;
2974:
2975: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t1='||l_t1);
2976: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t2='||l_t2);

Line 2973: SELECT COS(l_to_latitude_in_radians) INTO l_t4 FROM DUAL;

2969:
2970: SELECT SIN(l_from_latitude_in_radians) INTO l_t1 FROM DUAL;
2971: SELECT SIN(l_to_latitude_in_radians) INTO l_t2 FROM DUAL;
2972: SELECT COS(l_from_latitude_in_radians) INTO l_t3 FROM DUAL;
2973: SELECT COS(l_to_latitude_in_radians) INTO l_t4 FROM DUAL;
2974:
2975: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t1='||l_t1);
2976: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t2='||l_t2);
2977: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t3='||l_t3);

Line 2981: INTO l_t5 FROM DUAL;

2977: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t3='||l_t3);
2978: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t4='||l_t4);
2979:
2980: SELECT COS(l_degrees_to_radians * (l_from_longitude_in_degrees - l_to_longitude_in_degrees))
2981: INTO l_t5 FROM DUAL;
2982:
2983: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t5='||l_t5);
2984:
2985: SELECT ACOS(l_t1 * l_t2 + l_t3 * l_t4 * l_t5)

Line 2986: INTO l_t6 FROM DUAL;

2982:
2983: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t5='||l_t5);
2984:
2985: SELECT ACOS(l_t1 * l_t2 + l_t3 * l_t4 * l_t5)
2986: INTO l_t6 FROM DUAL;
2987:
2988: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_t6='||l_t6);
2989:
2990: l_euclidean_distance := l_earth_radius_multiplier * l_radians_to_degrees * l_t6;