[Home] [Help]
77: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
78: , NULL -- AGDUMMY
79: FROM wsh_delivery_details wdd,
80: wsh_delivery_assignments_v wda,
81: wsh_delivery_legs wdl,
82: wsh_trip_stops wts1
83: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
84: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
85: AND wda.delivery_id = wdl.delivery_id
108: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
109: , NULL -- AGDUMMY
110: FROM wsh_delivery_details wdd,
111: wsh_delivery_assignments_v wda,
112: wsh_delivery_legs wdl,
113: wsh_trip_stops wts1,
114: wsh_new_deliveries wnd
115: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
116: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
142: , NULL -- AGDUMMY
143: FROM wsh_delivery_details wdd,
144: wsh_delivery_assignments_v wda,
145: wsh_trip_stops wts1,
146: wsh_delivery_legs wdl1,
147: wsh_delivery_legs wdl2,
148: wsh_new_deliveries wnd
149: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
150: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
143: FROM wsh_delivery_details wdd,
144: wsh_delivery_assignments_v wda,
145: wsh_trip_stops wts1,
146: wsh_delivery_legs wdl1,
147: wsh_delivery_legs wdl2,
148: wsh_new_deliveries wnd
149: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
150: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
151: AND wda.delivery_id = wdl1.delivery_id
178: , nvl(wnd.SHIPMENT_DIRECTION,'O')
179: , nvl(wnd.SHIPPING_CONTROL,'BUYER')
180: , NULL -- AGDUMMY
181: FROM wsh_new_deliveries wnd,
182: wsh_delivery_legs wdl,
183: wsh_trip_stops wts1
184: WHERE wnd.delivery_id = wdl.delivery_id
185: AND wdl.pick_up_stop_id = wts1.stop_id
186: AND nvl(wnd.shipping_control,'BUYER') <> 'SUPPLIER'
281: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
282: , NULL --AGDUMMY
283: FROM wsh_delivery_details wdd,
284: wsh_delivery_assignments_v wda,
285: wsh_delivery_legs wdl1,
286: wsh_delivery_legs wdl2
287: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
288: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
289: AND wda.delivery_id = wdl1.delivery_id --c_delivery_id
282: , NULL --AGDUMMY
283: FROM wsh_delivery_details wdd,
284: wsh_delivery_assignments_v wda,
285: wsh_delivery_legs wdl1,
286: wsh_delivery_legs wdl2
287: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
288: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
289: AND wda.delivery_id = wdl1.delivery_id --c_delivery_id
290: AND wdl1.parent_delivery_leg_id = wdl2.delivery_leg_id
7565:
7566: --SBAKSHI
7567: CURSOR c_get_pickup_dropoff_dates(p_delivery_id IN NUMBER, p_trip_id IN NUMBER) IS
7568: SELECT wts1.planned_arrival_date, wts2.planned_arrival_date
7569: FROM wsh_trip_stops wts1, wsh_trip_stops wts2, wsh_delivery_legs wdl
7570: WHERE wts1.trip_id = p_trip_id
7571: AND wts2.trip_id = p_trip_id
7572: AND wdl.delivery_id = p_delivery_id
7573: AND wts1.stop_id = wdl.pick_up_stop_id
9120: wsh_constraint_dleg_tmp v -- global temporary table
9121: where v.delivery_id = c_delivery_id
9122: CONNECT BY PRIOR v.drop_off_stop_location_id = v.pick_up_stop_location_id
9123: START WITH v.pick_up_stop_location_id NOT IN (select nvl(a.physical_location_id,a.stop_location_id)
9124: from wsh_delivery_legs c,wsh_trip_stops a where
9125: c.delivery_id = c_delivery_id and
9126: c.drop_off_stop_id = a.stop_id
9127: );
9128:
9486: wts2.stop_sequence_number dropoff_stop_seq,
9487: wdl.sequence_number,wt.trip_id
9488: --#DUM_LOC(E)
9489: FROM wsh_new_deliveries wnd,
9490: wsh_delivery_legs wdl,
9491: wsh_trips wt,
9492: wsh_trip_stops wts1,
9493: wsh_trip_stops wts2
9494: WHERE wnd.delivery_id = c_delivery_id
10276: wts1.planned_arrival_date ,
10277: wts2.planned_arrival_date ,
10278: wts1.trip_id,
10279: wdl.delivery_id
10280: FROM wsh_delivery_legs wdl,
10281: wsh_trip_stops wts1,
10282: wsh_trip_stops wts2
10283: WHERE wdl.delivery_id = l_delivery_ids(q)
10284: AND wdl.pick_up_stop_id = wts1.stop_id
11593: FROM wsh_trips where trip_id=l_tripid;
11594:
11595: cursor c_gettrip(l_deliveryid IN NUMBER) is
11596: select wts.TRIP_ID
11597: from wsh_trip_stops wts, wsh_delivery_legs wdl
11598: where wdl.delivery_id =l_deliveryid AND
11599: wdl.pick_up_stop_id = wts.stop_id;
11600:
11601: k NUMBER:=0;
13137:
13138: cursor get_num_child_dlegs(p_delivery_leg_id IN NUMBER) IS
13139: SELECT
13140: count(*)
13141: FROM wsh_delivery_legs
13142: WHERE parent_delivery_leg_id = p_delivery_leg_id;
13143:
13144: l_orig_dlvy_puloc NUMBER:=0;
13145: l_orig_dlvy_udloc NUMBER:=0;
16701: wts2.stop_sequence_number dropoff_stop_seq,
16702: wts1.planned_arrival_date pickup_stop_pa_date,
16703: wts2.planned_arrival_date dropoff_stop_pa_date
16704: FROM wsh_new_deliveries wnd,
16705: wsh_delivery_legs wdl,
16706: wsh_trip_stops wts1,
16707: wsh_trip_stops wts2
16708: WHERE wnd.delivery_id = c_delivery_id
16709: AND wdl.delivery_id = wnd.delivery_id
18272: l_msg_data VARCHAR2(2000) := NULL;
18273:
18274: cursor c_gettrip(l_deliveryid IN NUMBER) is
18275: select wts.TRIP_ID
18276: from wsh_trip_stops wts, wsh_delivery_legs wdl
18277: where wdl.delivery_id =l_deliveryid AND
18278: wdl.pick_up_stop_id = wts.stop_id;
18279:
18280: