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 8477: wsh_delivery_legs wdl,

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

Line 8515: FROM wsh_delivery_legs

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

Line 8598: wsh_delivery_legs dl ,

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

Line 8728: UPDATE wsh_delivery_legs

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

Line 8732: FROM wsh_delivery_legs wdl,

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

Line 8744: UPDATE wsh_delivery_legs

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

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

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

Line 9835: FROM wsh_delivery_legs

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

Line 10114: FROM wsh_delivery_legs wdl, wsh_new_deliveries wnd

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

Line 10167: FROM wsh_delivery_legs wdl ,

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

Line 11950: FROM wsh_delivery_legs dl ,

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

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