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 1008: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1004: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1005: IF p_in_rec.caller = 'PLSQL' THEN
1006: BEGIN
1007: SELECT 'Y',wt.name into l_status,l_name
1008: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1009: wsh_delivery_assignments wda, wsh_delivery_details wdd
1010: WHERE wt.trip_id = l_trip_id
1011: AND wts.trip_id = wt.trip_id
1012: AND wdl.pick_up_stop_id = wts.stop_id

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

1081: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1082: IF p_in_rec.caller = 'PLSQL' THEN
1083: BEGIN
1084: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1085: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1086: wsh_delivery_assignments wda, wsh_delivery_details wdd
1087: WHERE wts.stop_id = l_stop_id
1088: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1089: AND wnd.delivery_id = wdl.delivery_id

Line 1207: FROM wsh_delivery_legs

1203: l_num_entity := l_num_entity + 1;
1204:
1205: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1206: SELECT delivery_id INTO l_counts
1207: FROM wsh_delivery_legs
1208: WHERE delivery_leg_id = l_freight_info_tab(l_index).delivery_leg_id
1209: AND ROWNUM = 1;
1210:
1211: IF (l_counts = 0) THEN