APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_NEW_DELIVERIES

Line 114: wsh_new_deliveries wnd

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'
117: AND wda.delivery_id = wdl.delivery_id
118: AND wdl.pick_up_stop_id = wts1.stop_id

Line 148: wsh_new_deliveries wnd

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
152: AND wdl1.parent_delivery_leg_id = wdl2.delivery_leg_id

Line 181: FROM wsh_new_deliveries wnd,

177: , wnd.PARTY_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

Line 233: FROM wsh_new_deliveries wnd

229: , wnd.PARTY_ID
230: , nvl(wnd.SHIPMENT_DIRECTION,'O')
231: , nvl(wnd.SHIPPING_CONTROL,'BUYER')
232: , NULL -- AGDUMMY
233: FROM wsh_new_deliveries wnd
234: WHERE wnd.delivery_id = c_delivery_id;
235:
236: CURSOR c_get_details(c_delivery_id IN NUMBER) IS
237: SELECT wdd.DELIVERY_DETAIL_ID

Line 9111: FROM wsh_new_deliveries

9107:
9108: CURSOR c_get_dlvy_locs(c_delivery_id IN NUMBER) IS
9109: SELECT initial_pickup_location_id,
9110: ultimate_dropoff_location_id
9111: FROM wsh_new_deliveries
9112: WHERE delivery_id = c_delivery_id;
9113:
9114: -- AGDUMMY
9115: -- all the stop_location_id

Line 9489: FROM wsh_new_deliveries wnd,

9485: nvl(wts2.physical_location_id,wts2.stop_location_id) dropoff_stop_loc ,
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

Line 16699: FROM wsh_new_deliveries wnd,

16695: SELECT wts1.stop_sequence_number pickup_stop_seq,
16696: wts2.stop_sequence_number dropoff_stop_seq,
16697: wts1.planned_arrival_date pickup_stop_pa_date,
16698: wts2.planned_arrival_date dropoff_stop_pa_date
16699: FROM wsh_new_deliveries wnd,
16700: wsh_delivery_legs wdl,
16701: wsh_trip_stops wts1,
16702: wsh_trip_stops wts2
16703: WHERE wnd.delivery_id = c_delivery_id

Line 18299: FROM wsh_new_deliveries wnd

18295: , wnd.PARTY_ID
18296: , nvl(wnd.SHIPMENT_DIRECTION,'O')
18297: , nvl(wnd.SHIPPING_CONTROL,'BUYER')
18298: , NULL -- AGDUMMY
18299: FROM wsh_new_deliveries wnd
18300: WHERE wnd.delivery_id = c_delivery_id;
18301:
18302: BEGIN
18303: