APPS.FTE_DELIVERY_LEGS_PVT dependencies on WSH_TRIPS

Line 313: FROM wsh_trips

309: IS
310: SELECT lane_id, schedule_id,
311: carrier_id, mode_of_transport, service_level,
312: NVL(consolidation_allowed,'N') consolidation_allowed
313: FROM wsh_trips
314: WHERE trip_id = p_trip_id;
315: --
316: --
317: CURSOR stop_location_cur (p_stop_id NUMBER)

Line 1169: fte_wsh_trips_pvt.Create_Update_Trip_Wrapper

1165: --}
1166: END IF;
1167: --
1168: --
1169: fte_wsh_trips_pvt.Create_Update_Trip_Wrapper
1170: (
1171: p_init_msg_list => FND_API.G_FALSE,
1172: x_return_status => l_return_status,
1173: x_msg_count => l_msg_count,

Line 1185: p_api_name => 'FTE_WSH_TRIPS_PVT.CREATE_UPDATE_TRIP_WRAPPER',

1181: --
1182: --
1183: FTE_MLS_UTIL.api_post_call
1184: (
1185: p_api_name => 'FTE_WSH_TRIPS_PVT.CREATE_UPDATE_TRIP_WRAPPER',
1186: p_api_return_status => l_return_status,
1187: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',
1188: p_delivery_id => p_delivery_id,
1189: p_delivery_name => p_delivery_name,

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