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.WSH_FREIGHT_COSTS_GRP dependencies on WSH_DELIVERY_LEGS

Line 1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1050: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1051: IF p_in_rec.caller = 'PLSQL' THEN
1052: BEGIN
1053: SELECT 'Y',wt.name into l_status,l_name
1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1055: wsh_delivery_assignments wda, wsh_delivery_details wdd
1056: WHERE wt.trip_id = l_trip_id
1057: AND wts.trip_id = wt.trip_id
1058: AND wdl.pick_up_stop_id = wts.stop_id

Line 1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1127: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1128: IF p_in_rec.caller = 'PLSQL' THEN
1129: BEGIN
1130: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1132: wsh_delivery_assignments wda, wsh_delivery_details wdd
1133: WHERE wts.stop_id = l_stop_id
1134: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1135: AND wnd.delivery_id = wdl.delivery_id

Line 1253: FROM wsh_delivery_legs

1249: l_num_entity := l_num_entity + 1;
1250:
1251: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1252: SELECT delivery_id INTO l_counts
1253: FROM wsh_delivery_legs
1254: WHERE delivery_leg_id = l_freight_info_tab(l_index).delivery_leg_id
1255: AND ROWNUM = 1;
1256:
1257: IF (l_counts = 0) THEN