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.FTE_FREIGHT_PRICING dependencies on WSH_TRIP_STOPS

Line 65: wsh_trip_stops wts1,

61: SELECT count(delivery_detail_id) FROM wsh_delivery_assignments
62: WHERE delivery_id in
63: (SELECT wdl.delivery_id
64: FROM wsh_delivery_legs wdl,
65: wsh_trip_stops wts1,
66: wsh_trip_stops wts2
67: WHERE wts1.trip_id = c_trip_id
68: AND wts2.trip_id = c_trip_id
69: AND wts1.stop_id = wdl.pick_up_stop_id

Line 66: wsh_trip_stops wts2

62: WHERE delivery_id in
63: (SELECT wdl.delivery_id
64: FROM wsh_delivery_legs wdl,
65: wsh_trip_stops wts1,
66: wsh_trip_stops wts2
67: WHERE wts1.trip_id = c_trip_id
68: AND wts2.trip_id = c_trip_id
69: AND wts1.stop_id = wdl.pick_up_stop_id
70: AND wts2.stop_id = wdl.drop_off_stop_id

Line 126: wsh_trip_stops wts1,

122: )
123: AND wd.delivery_id in
124: (SELECT wdl.delivery_id
125: FROM wsh_delivery_legs wdl,
126: wsh_trip_stops wts1,
127: wsh_trip_stops wts2
128: WHERE wts1.trip_id = c_trip_id
129: AND wts2.trip_id = c_trip_id
130: AND wts1.stop_id = wdl.pick_up_stop_id

Line 127: wsh_trip_stops wts2

123: AND wd.delivery_id in
124: (SELECT wdl.delivery_id
125: FROM wsh_delivery_legs wdl,
126: wsh_trip_stops wts1,
127: wsh_trip_stops wts2
128: WHERE wts1.trip_id = c_trip_id
129: AND wts2.trip_id = c_trip_id
130: AND wts1.stop_id = wdl.pick_up_stop_id
131: AND wts2.stop_id = wdl.drop_off_stop_id

Line 161: wsh_trip_stops wts1,

157: AND b.carrier_manifesting_flag = 'Y'
158: AND a.delivery_id in
159: (SELECT wdl.delivery_id
160: FROM wsh_delivery_legs wdl,
161: wsh_trip_stops wts1,
162: wsh_trip_stops wts2
163: WHERE wts1.trip_id = c_trip_id
164: AND wts2.trip_id = c_trip_id
165: AND wts1.stop_id = wdl.pick_up_stop_id

Line 162: wsh_trip_stops wts2

158: AND a.delivery_id in
159: (SELECT wdl.delivery_id
160: FROM wsh_delivery_legs wdl,
161: wsh_trip_stops wts1,
162: wsh_trip_stops wts2
163: WHERE wts1.trip_id = c_trip_id
164: AND wts2.trip_id = c_trip_id
165: AND wts1.stop_id = wdl.pick_up_stop_id
166: AND wts2.stop_id = wdl.drop_off_stop_id

Line 173: wsh_trip_stops wts1,

169: CURSOR c_cnt_trip_legs(c_trip_id NUMBER)
170: IS
171: SELECT count(wdl.delivery_leg_id)
172: FROM wsh_delivery_legs wdl,
173: wsh_trip_stops wts1,
174: wsh_trip_stops wts2
175: WHERE wts1.trip_id = c_trip_id
176: AND wts2.trip_id = c_trip_id
177: AND wts1.stop_id = wdl.pick_up_stop_id

Line 174: wsh_trip_stops wts2

170: IS
171: SELECT count(wdl.delivery_leg_id)
172: FROM wsh_delivery_legs wdl,
173: wsh_trip_stops wts1,
174: wsh_trip_stops wts2
175: WHERE wts1.trip_id = c_trip_id
176: AND wts2.trip_id = c_trip_id
177: AND wts1.stop_id = wdl.pick_up_stop_id
178: AND wts2.stop_id = wdl.drop_off_stop_id;

Line 182: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt

178: AND wts2.stop_id = wdl.drop_off_stop_id;
179:
180: CURSOR c_count_reprice_reqd(c_trip_id IN NUMBER) IS
181: Select count(*)
182: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
183: where wdl.pick_up_stop_id = wts1.stop_id
184: and wdl.drop_off_stop_id = wts2.stop_id
185: and wdl.reprice_required = 'Y'
186: and wts1.trip_id = wt.trip_id

Line 1979: wsh_trip_stops s,

1975: CURSOR c_get_trip_from_dleg(c_dleg_id IN NUMBER)
1976: IS
1977: SELECT t.trip_id, t.mode_of_transport
1978: FROM wsh_delivery_legs dl,
1979: wsh_trip_stops s,
1980: wsh_trips t
1981: WHERE dl.delivery_leg_id =c_dleg_id AND
1982: dl.pick_up_stop_id=s.stop_id AND
1983: s.trip_id=t.trip_id ;

Line 8478: wsh_trip_stops wts1,

8474: CURSOR c_get_segment IS
8475: SELECT wt.trip_id
8476: FROM wsh_trips wt,
8477: wsh_delivery_legs wdl,
8478: wsh_trip_stops wts1,
8479: wsh_trip_stops wts2
8480: WHERE wts1.stop_id = wdl.pick_up_stop_id
8481: AND wts2.stop_id = wdl.drop_off_stop_id
8482: AND wts1.trip_id = wt.trip_id

Line 8479: wsh_trip_stops wts2

8475: SELECT wt.trip_id
8476: FROM wsh_trips wt,
8477: wsh_delivery_legs wdl,
8478: wsh_trip_stops wts1,
8479: wsh_trip_stops wts2
8480: WHERE wts1.stop_id = wdl.pick_up_stop_id
8481: AND wts2.stop_id = wdl.drop_off_stop_id
8482: AND wts1.trip_id = wt.trip_id
8483: and wts2.trip_id = wt.trip_id

Line 8599: wsh_trip_stops s

8595:
8596: SELECT wfc.freight_cost_id
8597: FROM wsh_freight_costs wfc,
8598: wsh_delivery_legs dl ,
8599: wsh_trip_stops s
8600: WHERE wfc.delivery_leg_id = dl.delivery_leg_id
8601: and dl.pick_up_stop_id=s.stop_id
8602: and s.trip_id=c_segment_id
8603: and wfc.charge_source_code='PRICING_ENGINE'

Line 8734: wsh_trip_stops wts1,

8730: WHERE delivery_leg_id IN (
8731: SELECT wdl.delivery_leg_id
8732: FROM wsh_delivery_legs wdl,
8733: wsh_trips wt,
8734: wsh_trip_stops wts1,
8735: wsh_trip_stops wts2
8736: WHERE wt.trip_id = wts1.trip_id
8737: AND wt.trip_id = wts2.trip_id
8738: AND wts1.stop_id = wdl.pick_up_stop_id

Line 8735: wsh_trip_stops wts2

8731: SELECT wdl.delivery_leg_id
8732: FROM wsh_delivery_legs wdl,
8733: wsh_trips wt,
8734: wsh_trip_stops wts1,
8735: wsh_trip_stops wts2
8736: WHERE wt.trip_id = wts1.trip_id
8737: AND wt.trip_id = wts2.trip_id
8738: AND wts1.stop_id = wdl.pick_up_stop_id
8739: AND wts2.stop_id = wdl.drop_off_stop_id

Line 8841: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt

8837: wda.parent_delivery_id,
8838: wdl.parent_delivery_leg_id
8839: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
8840: wsh_new_deliveries wd,
8841: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
8842: where wdd.delivery_detail_id = wda.delivery_detail_id
8843: and wda.delivery_id = wdl.delivery_id
8844: and wdl.delivery_id = wd.delivery_id
8845: and wdl.pick_up_stop_id = wts1.stop_id

Line 8938: FROM wsh_trip_stops

8934:
8935: CURSOR c_trip_first_stop(c_trip_id NUMBER)
8936: IS
8937: SELECT planned_departure_date
8938: FROM wsh_trip_stops
8939: WHERE trip_id = c_trip_id
8940: AND stop_sequence_number =
8941: (SELECT min(stop_sequence_number)
8942: FROM wsh_trip_stops

Line 8942: FROM wsh_trip_stops

8938: FROM wsh_trip_stops
8939: WHERE trip_id = c_trip_id
8940: AND stop_sequence_number =
8941: (SELECT min(stop_sequence_number)
8942: FROM wsh_trip_stops
8943: WHERE trip_id = c_trip_id);
8944:
8945: CURSOR c_trip_last_stop(c_trip_id NUMBER)
8946: IS

Line 8948: FROM wsh_trip_stops

8944:
8945: CURSOR c_trip_last_stop(c_trip_id NUMBER)
8946: IS
8947: SELECT planned_arrival_date
8948: FROM wsh_trip_stops
8949: WHERE trip_id = c_trip_id
8950: AND stop_sequence_number =
8951: (SELECT max(stop_sequence_number)
8952: FROM wsh_trip_stops

Line 8952: FROM wsh_trip_stops

8948: FROM wsh_trip_stops
8949: WHERE trip_id = c_trip_id
8950: AND stop_sequence_number =
8951: (SELECT max(stop_sequence_number)
8952: FROM wsh_trip_stops
8953: WHERE trip_id = c_trip_id);
8954: --
8955: l_return_status VARCHAR2(1);
8956: l_return_code NUMBER;

Line 10168: wsh_trip_stops wts1,

10164:
10165: CURSOR c_get_distinct_trip_ids(c_dleg_id IN VARCHAR2) IS
10166: SELECT DISTINCT wdl.delivery_id,wts1.trip_id ,wdl.delivery_leg_id,wnd.name
10167: FROM wsh_delivery_legs wdl ,
10168: wsh_trip_stops wts1,
10169: wsh_trip_stops wts2,
10170: wsh_trips wt,
10171: wsh_new_deliveries wnd
10172: WHERE wdl.pick_up_stop_id = wts1.stop_id

Line 10169: wsh_trip_stops wts2,

10165: CURSOR c_get_distinct_trip_ids(c_dleg_id IN VARCHAR2) IS
10166: SELECT DISTINCT wdl.delivery_id,wts1.trip_id ,wdl.delivery_leg_id,wnd.name
10167: FROM wsh_delivery_legs wdl ,
10168: wsh_trip_stops wts1,
10169: wsh_trip_stops wts2,
10170: wsh_trips wt,
10171: wsh_new_deliveries wnd
10172: WHERE wdl.pick_up_stop_id = wts1.stop_id
10173: AND wdl.drop_off_stop_id = wts2.stop_id

Line 11951: wsh_trip_stops s

11947:
11948: CURSOR c_get_dlegs_from_trip(c_trip_id IN NUMBER) IS
11949: SELECT dl.delivery_leg_id,dl.delivery_id
11950: FROM wsh_delivery_legs dl ,
11951: wsh_trip_stops s
11952: WHERE dl.pick_up_stop_id = s.stop_id
11953: and s.trip_id=c_trip_id;
11954:
11955: l_empty_main_row WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

Line 12587: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt

12583: wda.parent_delivery_id,
12584: wdl.parent_delivery_leg_id
12585: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
12586: wsh_new_deliveries wd,
12587: wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
12588: where wdd.delivery_detail_id = wda.delivery_detail_id
12589: and wda.delivery_id = wdl.delivery_id
12590: and wdl.delivery_id = wd.delivery_id
12591: and wdl.pick_up_stop_id = wts1.stop_id