APPS.FTE_DELIVERY_ACTIVITY dependencies on WSH_TRIP_STOPS

Line 94: from wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt

90:
91: cursor c_dlegs(p_trip_id NUMBER) is
92: select wdl.delivery_id delivery_id, wdl.delivery_leg_id delivery_leg_id ,
93: wt.carrier_id carrier_id, wt.mode_of_transport mode_of_transport , wt.service_level service_level
94: from wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt
95: where wdl.pick_up_stop_id = wts.stop_id
96: and wts.trip_id = p_trip_id
97: and wt.trip_id= p_trip_id;
98:

Line 155: FROM wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt

151: CURSOR c_dlegs(c_trip_id NUMBER) is
152: SELECT wdl.delivery_id delivery_id, wdl.delivery_leg_id delivery_leg_id ,
153: wt.carrier_id carrier_id, wt.mode_of_transport mode_of_transport ,
154: wt.service_level service_level, wt.wf_item_key, wt.rank_id
155: FROM wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt
156: WHERE wdl.pick_up_stop_id = wts.stop_id
157: AND wts.trip_id = c_trip_id
158: AND wt.trip_id= c_trip_id ;
159: --}