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_FREIGHT_RATING_DLVY_GRP dependencies on WSH_GLOBAL_PARAMETERS

Line 107: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

103: -- count the number of deliveries which should not be rated due to freight term
104: CURSOR c_check_del_freight_term(c_delivery_id NUMBER)
105: IS
106: SELECT count(wd.delivery_id)
107: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
108: WHERE (
109: ((wd.shipment_direction in ('I'))
110: and (wgp.rate_ib_dels_fgt_term is not null)
111: and (wd.freight_terms_code is not null)

Line 133: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

129: -- count the number of deliveries which should not be rated due to freight term
130: CURSOR c_check_del_freight_term2(c_trip_id NUMBER)
131: IS
132: SELECT count(wd.delivery_id)
133: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
134: WHERE (
135: ((wd.shipment_direction in ('I'))
136: and (wgp.rate_ib_dels_fgt_term is not null)
137: and (wd.freight_terms_code is not null)

Line 3619: FROM WSH_GLOBAL_PARAMETERS wgp;

3615: IS
3616:
3617: CURSOR get_global_expand_rank_flag IS
3618: SELECT wgp.expand_carrier_rankings
3619: FROM WSH_GLOBAL_PARAMETERS wgp;
3620:
3621: CURSOR get_rank_id(c_trip_id IN NUMBER) IS
3622: SELECT t.rank_id
3623: FROM WSH_TRIPS t