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_IB_TXN_MATCH_PKG dependencies on WSH_TRIP_STOPS

Line 5121: wsh_trip_stops wts,

5117: wt.carrier_id,
5118: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5119: FROM wsh_delivery_legs wdl,
5120: wsh_new_deliveries wnd,
5121: wsh_trip_stops wts,
5122: wsh_trip_stops wts1,
5123: wsh_trips wt
5124: WHERE wnd.delivery_id = p_deliveryId
5125: AND wdl.delivery_id = wnd.delivery_id

Line 5122: wsh_trip_stops wts1,

5118: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5119: FROM wsh_delivery_legs wdl,
5120: wsh_new_deliveries wnd,
5121: wsh_trip_stops wts,
5122: wsh_trip_stops wts1,
5123: wsh_trips wt
5124: WHERE wnd.delivery_id = p_deliveryId
5125: AND wdl.delivery_id = wnd.delivery_id
5126: AND wdl.drop_off_stop_id = wts.stop_id

Line 5138: wsh_trip_stops wts,

5134: wt.carrier_id,
5135: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5136: FROM wsh_delivery_legs wdl,
5137: wsh_new_deliveries wnd,
5138: wsh_trip_stops wts,
5139: wsh_trip_stops wts1,
5140: wsh_trips wt
5141: WHERE wnd.delivery_id = p_deliveryId
5142: AND wdl.delivery_id = wnd.delivery_id

Line 5139: wsh_trip_stops wts1,

5135: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5136: FROM wsh_delivery_legs wdl,
5137: wsh_new_deliveries wnd,
5138: wsh_trip_stops wts,
5139: wsh_trip_stops wts1,
5140: wsh_trips wt
5141: WHERE wnd.delivery_id = p_deliveryId
5142: AND wdl.delivery_id = wnd.delivery_id
5143: AND wdl.pick_up_stop_id = wts.stop_id