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

Line 82: wsh_trip_stops wts1

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
86: AND wdl.pick_up_stop_id = wts1.stop_id

Line 113: wsh_trip_stops wts1,

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

Line 145: wsh_trip_stops wts1,

141: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
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

Line 183: wsh_trip_stops wts1

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'
187: AND wts1.trip_id = c_trip_id;

Line 206: FROM wsh_trip_stops wts

202: , wts.PHYSICAL_LOCATION_ID
203: --#DUM_LOC(E)
204: --#SBAKSHI
205: , wts.PHYSICAL_STOP_ID
206: FROM wsh_trip_stops wts
207: WHERE wts.trip_id = c_tripid
208: order by wts.PLANNED_ARRIVAL_DATE;
209:
210: CURSOR c_get_dlvy(c_delivery_id IN NUMBER) IS

Line 299: FROM wsh_trip_stops wts

295: --#DUM_LOC(S)
296: SELECT nvl(wts.physical_location_id,wts.stop_location_id),
297: --#DUM_LOC(E)
298: wts.stop_sequence_number,wts.planned_arrival_date
299: FROM wsh_trip_stops wts
300: WHERE wts.stop_id = c_stop_id
301: order by wts.planned_arrival_date;
302:
303: -- AGDUMMY

Line 307: FROM wsh_trip_stops wts

303: -- AGDUMMY
304: -- This cursor might return both the dummy and the physical stop
305: CURSOR c_get_stop(c_location_id IN NUMBER,c_trip_id IN NUMBER) IS
306: SELECT wts.stop_sequence_number,wts.planned_arrival_date
307: FROM wsh_trip_stops wts
308: --#DUM_LOC(S)
309: WHERE nvl(wts.physical_location_id,wts.stop_location_id) = c_location_id
310: --#DUM_LOC(E)
311: AND wts.trip_id = c_trip_id;

Line 7569: FROM wsh_trip_stops wts1, wsh_trip_stops wts2, wsh_delivery_legs wdl

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

Line 9124: from wsh_delivery_legs c,wsh_trip_stops a where

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:

Line 9492: wsh_trip_stops wts1,

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
9495: AND wdl.delivery_id = wnd.delivery_id
9496: AND wdl.pick_up_stop_id = wts1.stop_id

Line 9493: wsh_trip_stops wts2

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
9495: AND wdl.delivery_id = wnd.delivery_id
9496: AND wdl.pick_up_stop_id = wts1.stop_id
9497: AND wdl.drop_off_stop_id = wts2.stop_id

Line 10281: wsh_trip_stops wts1,

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
10285: AND wdl.drop_off_stop_id = wts2.stop_id

Line 10282: wsh_trip_stops wts2

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
10285: AND wdl.drop_off_stop_id = wts2.stop_id
10286: AND wdl.delivery_leg_id NOT IN

Line 11597: from wsh_trip_stops wts, wsh_delivery_legs wdl

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;

Line 16688: FROM wsh_trips wt, wsh_trip_stops wts

16684: CURSOR c_gettripdetails (l_stop_id IN NUMBER) is
16685: SELECT wt.TRIP_ID, 'Y'as exists_in_database, wt.NAME, wt.PLANNED_FLAG, wt.STATUS_CODE, wt.VEHICLE_ITEM_ID, wt.VEHICLE_NUMBER,
16686: wt.CARRIER_ID, wt.SHIP_METHOD_CODE, wt.VEHICLE_ORGANIZATION_ID, wt.VEHICLE_NUM_PREFIX, wt.SERVICE_LEVEL,
16687: wt.MODE_OF_TRANSPORT
16688: FROM wsh_trips wt, wsh_trip_stops wts
16689: WHERE wts.stop_id = l_stop_id
16690: AND wts.trip_id= wt.trip_id;
16691:
16692: CURSOR c_gettripinfo (l_trip_id IN NUMBER) is

Line 16706: wsh_trip_stops wts1,

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
16710: AND wdl.pick_up_stop_id = wts1.stop_id

Line 16707: wsh_trip_stops wts2

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
16710: AND wdl.pick_up_stop_id = wts1.stop_id
16711: AND wdl.drop_off_stop_id = wts2.stop_id

Line 18276: from wsh_trip_stops wts, wsh_delivery_legs wdl

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: