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_ROUTING_RESPONSE_PKG dependencies on WSH_DELIVERY_LEGS

Line 431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt

427: -- Get the pickup stop Id, trip Id
428: --
429: CURSOR c_GetPickupStopId(p_delId IN NUMBER) IS
430: SELECT wdl.pick_up_stop_id, wt.trip_id, wnd.name, wt.planned_flag, wnd.planned_flag
431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt
432: WHERE wnd.delivery_id = p_delId
433: and wnd.delivery_id = wdl.delivery_id
434: and wdl.pick_up_stop_id = wts.stop_id
435: and wnd.initial_pickup_location_id = wts.stop_location_id

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

438: -- Get the drop off Stop Id
439: --
440: CURSOR c_GetDropoffStopId(p_delId IN NUMBER) IS
441: SELECT nvl(wts.physical_stop_id,drop_off_stop_id) drop_off_stop_id
442: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl
443: WHERE wnd.delivery_id = p_delId
444: and wnd.delivery_id = wdl.delivery_id
445: and wdl.drop_off_stop_id = wts.stop_id
446: and wnd.ultimate_dropoff_location_id = wts.stop_location_id;

Line 1602: wsh_delivery_legs wdl,

1598: --Cursor to find ,if first leg is created for a delivery.
1599: CURSOR validate_first_leg_csr(cp_delivery_id NUMBER) IS
1600: SELECT wts.trip_id,wnd.organization_id,wnd.shipping_control
1601: FROM wsh_new_deliveries wnd,
1602: wsh_delivery_legs wdl,
1603: wsh_trip_stops wts
1604: WHERE wnd.delivery_id = p_delivery_id
1605: AND wnd.delivery_id = wdl.delivery_id
1606: AND wdl.pick_up_stop_id = wts.stop_id