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 8477: wsh_trip_stops wts1,

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

Line 8478: wsh_trip_stops wts2

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

Line 8598: wsh_trip_stops s

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

Line 8733: wsh_trip_stops wts1,

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

Line 8734: wsh_trip_stops wts2

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

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

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

Line 8937: FROM wsh_trip_stops

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

Line 8941: FROM wsh_trip_stops

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

Line 8947: FROM wsh_trip_stops

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

Line 8951: FROM wsh_trip_stops

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

Line 10167: wsh_trip_stops wts1,

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

Line 10168: wsh_trip_stops wts2,

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

Line 11950: wsh_trip_stops s

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

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

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