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_DELIVERY_LEGS

Line 51: FROM wsh_delivery_legs

47:
48: CURSOR c_get_delivery_id(c_leg_id NUMBER)
49: IS
50: SELECT delivery_id
51: FROM wsh_delivery_legs
52: WHERE delivery_leg_id = c_leg_id;
53:
54: CURSOR c_count_delivery_details(c_delivery_id NUMBER)
55: IS

Line 64: FROM wsh_delivery_legs wdl,

60: IS
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

Line 125: FROM wsh_delivery_legs wdl,

121: )
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

Line 160: FROM wsh_delivery_legs wdl,

156: AND c.manifesting_enabled_flag = 'Y'
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

Line 172: FROM wsh_delivery_legs wdl,

168:
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

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 1891: SELECT count(delivery_leg_id) FROM wsh_delivery_legs

1887:
1888: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
1889:
1890: CURSOR c_get_legs(c_delivery_id NUMBER) IS
1891: SELECT count(delivery_leg_id) FROM wsh_delivery_legs
1892: WHERE delivery_id = c_delivery_id;
1893:
1894: l_count NUMBER :=0;
1895:

Line 1978: FROM wsh_delivery_legs dl,

1974:
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

Line 4126: FROM wsh_delivery_legs

4122: AND line_type_code = 'SUMMARY';
4123:
4124: CURSOR c_get_dlv_id(c_dleg_id IN NUMBER) IS
4125: SELECT delivery_id
4126: FROM wsh_delivery_legs
4127: WHERE delivery_leg_id = c_dleg_id;
4128:
4129: j NUMBER:=0;
4130: k NUMBER:=0;

Line 8476: wsh_delivery_legs wdl,

8472: IS
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

Line 8514: FROM wsh_delivery_legs

8510: p_delivery_leg_id IN NUMBER ) RETURN NUMBER
8511: IS
8512: CURSOR c_get_delivery IS
8513: SELECT delivery_id
8514: FROM wsh_delivery_legs
8515: WHERE delivery_leg_id = p_delivery_leg_id;
8516:
8517: l_delivery_id NUMBER;
8518:

Line 8597: wsh_delivery_legs dl ,

8593: IS
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

Line 8727: UPDATE wsh_delivery_legs

8723: RETURN;
8724:
8725: ELSIF p_delivery_leg_id IS NULL THEN
8726:
8727: UPDATE wsh_delivery_legs
8728: SET reprice_required = 'N'
8729: WHERE delivery_leg_id IN (
8730: SELECT wdl.delivery_leg_id
8731: FROM wsh_delivery_legs wdl,

Line 8731: FROM wsh_delivery_legs wdl,

8727: UPDATE wsh_delivery_legs
8728: SET reprice_required = 'N'
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

Line 8743: UPDATE wsh_delivery_legs

8739: AND wt.trip_id = p_segment_id );
8740:
8741: ELSIF p_segment_id IS NULL THEN
8742:
8743: UPDATE wsh_delivery_legs
8744: SET reprice_required = 'N'
8745: WHERE delivery_leg_id = p_delivery_leg_id;
8746:
8747: END IF;

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 8925: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,

8921: NULL, -- comm_category_id
8922: wda.type,
8923: wda.parent_delivery_id,
8924: wdl.parent_delivery_leg_id
8925: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
8926: wsh_new_deliveries wd
8927: where wdd.delivery_detail_id = wda.delivery_detail_id
8928: and wda.delivery_id = wdl.delivery_id
8929: and wdl.delivery_id = wd.delivery_id

Line 9834: FROM wsh_delivery_legs

9830: AND ft.fte_trip_id = p_fte_trip_id;
9831: */
9832: CURSOR c_delivery_leg_from_dlvy IS
9833: SELECT delivery_leg_id
9834: FROM wsh_delivery_legs
9835: WHERE delivery_id = p_delivery_id;
9836:
9837:
9838: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;

Line 10113: FROM wsh_delivery_legs wdl, wsh_new_deliveries wnd

10109: l_index NUMBER := 0;
10110:
10111: CURSOR c_get_delivery_legs_detail(c_delivery_id IN NUMBER) IS
10112: SELECT wdl.delivery_id,delivery_leg_id,wnd.name
10113: FROM wsh_delivery_legs wdl, wsh_new_deliveries wnd
10114: WHERE wdl.delivery_id= c_delivery_id
10115: AND wnd.delivery_id = wdl.delivery_id;
10116:
10117: BEGIN

Line 10166: FROM wsh_delivery_legs wdl ,

10162: IS
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

Line 11949: FROM wsh_delivery_legs dl ,

11945:
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:

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