APPS.FTE_TRIP_RATING_GRP dependencies on WSH_TRIPS

Line 26: load_tender_status wsh_trips.load_tender_status%TYPE,

22: service_level VARCHAR2(30),
23: mode_of_transport VARCHAR2(30),
24: lane_id NUMBER,
25: schedule_id NUMBER,
26: load_tender_status wsh_trips.load_tender_status%TYPE,
27: tp_plan_name wsh_trips.tp_plan_name%TYPE,
28: move_id NUMBER
29: );
30:

Line 27: tp_plan_name wsh_trips.tp_plan_name%TYPE,

23: mode_of_transport VARCHAR2(30),
24: lane_id NUMBER,
25: schedule_id NUMBER,
26: load_tender_status wsh_trips.load_tender_status%TYPE,
27: tp_plan_name wsh_trips.tp_plan_name%TYPE,
28: move_id NUMBER
29: );
30:
31: TYPE trip_info_tab IS TABLE OF trip_info_rec INDEX BY BINARY_INTEGER;

Line 48: FROM wsh_trips wt, fte_trip_moves ftm

44: wt.schedule_id,
45: wt.load_tender_status,
46: wt.tp_plan_name,
47: ftm.move_id
48: FROM wsh_trips wt, fte_trip_moves ftm
49: WHERE wt.trip_id = c_trip_id
50: AND wt.trip_id = ftm.trip_id (+) ;
51:
52:

Line 2068: FROM wsh_trips

2064: l_api_name CONSTANT VARCHAR2(30) := 'Rate_Trip_conc';
2065:
2066: CURSOR c_get_trip_id(c_trip_name VARCHAR2) IS
2067: SELECT trip_id
2068: FROM wsh_trips
2069: WHERE name = c_trip_name;
2070:
2071: BEGIN
2072: FTE_FREIGHT_PRICING_UTIL.initialize_logging(p_debug_mode => 'CONC',

Line 2355: FROM wsh_trips t

2351:
2352: CURSOR c_trip_mode(c_trip_id NUMBER)
2353: IS
2354: SELECT t.mode_of_transport
2355: FROM wsh_trips t
2356: WHERE t.trip_id=c_trip_id;
2357:
2358:
2359: BEGIN