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_DELIVERY_LEGS_PVT dependencies on WSH_TRIP_STOPS

Line 320: FROM wsh_trip_stops

316: --
317: CURSOR stop_location_cur (p_stop_id NUMBER)
318: IS
319: SELECT stop_location_id
320: FROM wsh_trip_stops
321: WHERE stop_id = p_stop_id;
322: --
323: --
324: CURSOR stop_cur (p_trip_id NUMBER, p_stop_seq NUMBER)

Line 327: FROM wsh_trip_stops

323: --
324: CURSOR stop_cur (p_trip_id NUMBER, p_stop_seq NUMBER)
325: IS
326: SELECT stop_id, stop_sequence_number, stop_location_id
327: FROM wsh_trip_stops
328: WHERE trip_id = p_trip_id
329: AND stop_sequence_number >= p_stop_seq
330: order by stop_sequence_number desc;
331:

Line 1267: FROM wsh_trip_stops wts,

1263: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1265: WHERE delivery_leg_id IN
1266: ( SELECT delivery_leg_id
1267: FROM wsh_trip_stops wts,
1268: wsh_delivery_legs wdl
1269: WHERE wts.trip_id = p_wsh_trip_id
1270: AND wdl.pick_up_stop_id = wts.stop_id
1271: );

Line 1515: FROM wsh_trip_stops

1511: --
1512: CURSOR stop_cur (p_trip_id NUMBER)
1513: IS
1514: SELECT stop_id, stop_location_id, stop_sequence_number
1515: FROM wsh_trip_stops
1516: WHERE trip_id = p_trip_id
1517: order by stop_sequence_number;
1518:
1519: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 2013: FROM wsh_delivery_legs dl, wsh_trip_stops st, wsh_trips t

2009: t.load_tender_status, -- new 11/6 added by dmlewis
2010: t.planned_flag, t.shipments_type_flag, t.vehicle_item_id,
2011: t.vehicle_organization_id, dl.parent_delivery_leg_id,
2012: t.rank_id, t.routing_rule_id, t.append_flag
2013: FROM wsh_delivery_legs dl, wsh_trip_stops st, wsh_trips t
2014: WHERE dl.delivery_leg_id = dLegId
2015: AND dl.pick_up_stop_id = st.stop_id
2016: AND t.trip_id = st.trip_id;
2017: --

Line 2029: FROM wsh_trip_stops st

2025: st.stop_location_id, st.physical_location_id,
2026: st.actual_arrival_date, st.actual_departure_date,
2027: st.planned_arrival_date, st.planned_departure_date,
2028: st.stop_sequence_number, st.status_code
2029: FROM wsh_trip_stops st
2030: WHERE physical_stop_id IS NULL
2031: START WITH stop_id IN
2032: (SELECT stop_id FROM wsh_trip_stops, wsh_delivery_legs
2033: WHERE drop_off_stop_id = stop_id

Line 2032: (SELECT stop_id FROM wsh_trip_stops, wsh_delivery_legs

2028: st.stop_sequence_number, st.status_code
2029: FROM wsh_trip_stops st
2030: WHERE physical_stop_id IS NULL
2031: START WITH stop_id IN
2032: (SELECT stop_id FROM wsh_trip_stops, wsh_delivery_legs
2033: WHERE drop_off_stop_id = stop_id
2034: AND delivery_leg_id = dlegId)
2035: CONNECT BY PRIOR physical_stop_id = stop_id;
2036: --

Line 2053: FROM wsh_trip_stops where trip_id = trip_seg_id

2049: IS
2050: SELECT stop_id, status_code, stop_sequence_number,
2051: stop_location_id,planned_departure_date,
2052: planned_arrival_date
2053: FROM wsh_trip_stops where trip_id = trip_seg_id
2054: AND stop_sequence_number = (
2055: SELECT min(stop_sequence_number)
2056: FROM wsh_trip_stops where trip_id = trip_seg_id);
2057: --

Line 2056: FROM wsh_trip_stops where trip_id = trip_seg_id);

2052: planned_arrival_date
2053: FROM wsh_trip_stops where trip_id = trip_seg_id
2054: AND stop_sequence_number = (
2055: SELECT min(stop_sequence_number)
2056: FROM wsh_trip_stops where trip_id = trip_seg_id);
2057: --
2058: --
2059: -- GET TRIP SEGMENT ORIGIN DESTINATION CURSOR
2060: CURSOR get_trip_seg_dest_cur (trip_seg_Id NUMBER)

Line 2065: FROM wsh_trip_stops where trip_id = trip_seg_id

2061: IS
2062: SELECT stop_id, status_code, stop_sequence_number,
2063: stop_location_id,planned_departure_date,
2064: planned_arrival_date, physical_location_id
2065: FROM wsh_trip_stops where trip_id = trip_seg_id
2066: AND stop_sequence_number = (
2067: SELECT max(stop_sequence_number)
2068: FROM wsh_trip_stops where trip_id = trip_seg_id);
2069: --

Line 2068: FROM wsh_trip_stops where trip_id = trip_seg_id);

2064: planned_arrival_date, physical_location_id
2065: FROM wsh_trip_stops where trip_id = trip_seg_id
2066: AND stop_sequence_number = (
2067: SELECT max(stop_sequence_number)
2068: FROM wsh_trip_stops where trip_id = trip_seg_id);
2069: --
2070: -- GET Mode Of Transport
2071: --
2072: CURSOR get_mode_of_transport_cur (c_mode_code VARCHAR2)