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_RATING_DLVY_GRP dependencies on WSH_TRIPS

Line 46: load_tender_status wsh_trips.load_tender_status%TYPE

42: mode_of_transport VARCHAR2(30),
43: consolidation_allowed VARCHAR2(1),
44: lane_id NUMBER,
45: schedule_id NUMBER,
46: load_tender_status wsh_trips.load_tender_status%TYPE
47: );
48: --
49: TYPE trip_info_tab IS TABLE OF trip_info_rec INDEX BY BINARY_INTEGER;
50: --

Line 298: FROM wsh_trips wt,

294: wt.consolidation_allowed,
295: wt.lane_id,
296: wt.schedule_id,
297: wt.load_tender_status
298: FROM wsh_trips wt,
299: wsh_delivery_legs wdl,
300: wsh_trip_stops wts1,
301: wsh_trip_stops wts2
302: WHERE wts1.stop_id = wdl.pick_up_stop_id

Line 322: FROM wsh_trips wt

318: wt.consolidation_allowed,
319: wt.lane_id,
320: wt.schedule_id,
321: wt.load_tender_status
322: FROM wsh_trips wt
323: WHERE wt.trip_id = c_trip_id;
324:
325: CURSOR c_trip_first_stop(c_trip_id NUMBER)
326: IS

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

354: AND wts2.stop_id = wdl.drop_off_stop_id;
355:
356: CURSOR c_count_reprice_reqd(c_trip_id IN NUMBER) IS
357: Select count(*)
358: from wsh_delivery_legs wdl, wsh_trip_stops wts1, wsh_trip_stops wts2,wsh_trips wt
359: where wdl.pick_up_stop_id = wts1.stop_id
360: and wdl.drop_off_stop_id = wts2.stop_id
361: and wdl.reprice_required = 'Y'
362: and wts1.trip_id = wt.trip_id

Line 1160: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1156: x_msg_count OUT NOCOPY NUMBER,
1157: x_msg_data OUT NOCOPY VARCHAR2)
1158: IS
1159: l_api_version_number NUMBER := 1;
1160: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1161: l_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1162: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1163: l_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1164: l_vehicle_item_id NUMBER;

Line 1161: l_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;

1157: x_msg_data OUT NOCOPY VARCHAR2)
1158: IS
1159: l_api_version_number NUMBER := 1;
1160: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1161: l_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1162: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1163: l_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1164: l_vehicle_item_id NUMBER;
1165: l_vehicle_org_id NUMBER;

Line 1162: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

1158: IS
1159: l_api_version_number NUMBER := 1;
1160: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1161: l_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1162: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1163: l_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1164: l_vehicle_item_id NUMBER;
1165: l_vehicle_org_id NUMBER;
1166: l_return_status VARCHAR2(1);

Line 1163: l_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;

1159: l_api_version_number NUMBER := 1;
1160: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1161: l_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1162: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1163: l_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1164: l_vehicle_item_id NUMBER;
1165: l_vehicle_org_id NUMBER;
1166: l_return_status VARCHAR2(1);
1167: l_return_status_1 VARCHAR2(1);

Line 1190: select * from wsh_trips

1186:
1187: --
1188: cursor c_trip(c_trip_id NUMBER)
1189: is
1190: select * from wsh_trips
1191: where trip_id = c_trip_id;
1192: --
1193: c_trip_rec c_trip%ROWTYPE;
1194: --

Line 3463: wsh_new_deliveries wd, wsh_trips wt, wsh_trip_stops wts1, wsh_trip_stops wts2

3459: wda.type,
3460: wda.parent_delivery_id,
3461: wdl.parent_delivery_leg_id
3462: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_delivery_legs wdl,
3463: wsh_new_deliveries wd, wsh_trips wt, wsh_trip_stops wts1, wsh_trip_stops wts2
3464: where wdd.delivery_detail_id = wda.delivery_detail_id
3465: and wda.delivery_id = wdl.delivery_id
3466: and wdl.delivery_id = wd.delivery_id
3467: and wdl.pick_up_stop_id = wts1.stop_id

Line 3623: FROM WSH_TRIPS t

3619: FROM WSH_GLOBAL_PARAMETERS wgp;
3620:
3621: CURSOR get_rank_id(c_trip_id IN NUMBER) IS
3622: SELECT t.rank_id
3623: FROM WSH_TRIPS t
3624: WHERE t.trip_id=c_trip_id;
3625:
3626:
3627: CURSOR c_get_vehicle_item_org (c_vehicle_type_id IN NUMBER)