APPS.FTE_FREIGHT_PRICING dependencies on WSH_TRIPS

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 295: load_tender_status wsh_trips.load_tender_status%TYPE

291: mode_of_transport VARCHAR2(30),
292: consolidation_allowed VARCHAR2(1),
293: lane_id NUMBER,
294: schedule_id NUMBER,
295: load_tender_status wsh_trips.load_tender_status%TYPE
296: );
297:
298: -- Private APIs
299:

Line 1980: wsh_trips t

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 ;
1984:

Line 1989: FROM wsh_trips t

1985:
1986: CURSOR c_get_mode_for_trip(c_trip_id IN NUMBER)
1987: IS
1988: select t.mode_of_transport
1989: FROM wsh_trips t
1990: WHERE t.trip_id=c_trip_id;
1991:
1992: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1993: l_count NUMBER;

Line 7372: FROM fte_lanes fl, wsh_trips wt, fte_lane_rate_charts flrc

7368: CURSOR c_get_lane_info_from_trip(c_wsh_trip_id IN NUMBER) IS
7369: SELECT fl.lane_id,fl.carrier_id,flrc.list_header_id pricelist_id,
7370: fl.mode_of_transportation_code,fl.origin_id,fl.destination_id,
7371: fl.basis,fl.commodity_catg_id,fl.service_type_code,fl.comm_fc_class_code
7372: FROM fte_lanes fl, wsh_trips wt, fte_lane_rate_charts flrc
7373: WHERE fl.lane_id = wt.lane_id
7374: AND wt.trip_id = c_wsh_trip_id
7375: AND fl.lane_id = flrc.lane_id
7376: AND (flrc.start_date_active is null OR flrc.start_date_active <= p_ship_date)

Line 7392: FROM wsh_trips

7388: AND (flrc.end_date_active is null OR flrc.end_date_active > p_ship_date);
7389:
7390: CURSOR c_get_service_type(c_wsh_trip_id IN NUMBER) IS
7391: SELECT service_level
7392: FROM wsh_trips
7393: WHERE trip_id = c_wsh_trip_id;
7394:
7395: i NUMBER:=0;
7396: j NUMBER:=0;

Line 8413: -- FROM wsh_trips

8409: p_segment_id IN NUMBER ) RETURN BOOLEAN
8410: IS
8411: -- CURSOR c_get_consolidate_flag IS
8412: -- SELECT nvl(consolidation_allowed,'N')
8413: -- FROM wsh_trips
8414: -- WHERE trip_id = p_segment_id;
8415:
8416: CURSOR c_get_lane_function IS
8417: SELECT nvl(value_from, 'NONE')

Line 8418: FROM wsh_trips a, fte_prc_parameters b

8414: -- WHERE trip_id = p_segment_id;
8415:
8416: CURSOR c_get_lane_function IS
8417: SELECT nvl(value_from, 'NONE')
8418: FROM wsh_trips a, fte_prc_parameters b
8419: WHERE a.trip_id = p_segment_id
8420: AND a.lane_id = b.lane_id
8421: AND b.parameter_id = 1;
8422:

Line 8476: FROM wsh_trips wt,

8472: p_delivery_leg_id IN NUMBER ) RETURN NUMBER
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

Line 8733: wsh_trips wt,

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
8737: AND wt.trip_id = wts2.trip_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 9829: FROM fte_trips ft, fte_wsh_trips fwt

9825: l_return_status VARCHAR2(1);
9826: /*
9827: CURSOR c_segment_from_fte_trip IS
9828: SELECT fwt.wsh_trip_id
9829: FROM fte_trips ft, fte_wsh_trips fwt
9830: WHERE ft.fte_trip_id = fwt.fte_trip_id
9831: AND ft.fte_trip_id = p_fte_trip_id;
9832: */
9833: CURSOR c_delivery_leg_from_dlvy IS

Line 10170: wsh_trips wt,

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
10174: AND wdl.delivery_leg_id = c_dleg_id

Line 10392: FROM wsh_trips wt

10388: wt.consolidation_allowed,
10389: wt.lane_id,
10390: wt.schedule_id,
10391: wt.load_tender_status
10392: FROM wsh_trips wt
10393: WHERE wt.trip_id = c_trip_id;
10394:
10395: CURSOR c_get_trip_direction(c_trip_id NUMBER)
10396: IS

Line 10398: FROM wsh_trips

10394:
10395: CURSOR c_get_trip_direction(c_trip_id NUMBER)
10396: IS
10397: SELECT shipments_type_flag
10398: FROM wsh_trips
10399: WHERE trip_id = c_trip_id;
10400:
10401: l_trip_info trip_info_rec;
10402: i NUMBER;

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