APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIPS

Line 560: from wsh_trips_ob_grp_v trip,

556: l_trip_id NUMBER;
557: BEGIN
558: select trip.name, trip.trip_id
559: into l_trip_name, l_trip_id
560: from wsh_trips_ob_grp_v trip,
561: wsh_trip_stops_ob_grp_v pickup_stop,
562: wsh_trip_stops_ob_grp_v dropoff_stop,
563: wsh_delivery_legs_ob_grp_v wdl,
564: wsh_new_deliveries_ob_grp_v wnd

Line 582: from wsh_trips_ob_grp_v

578: p_trip_name IN VARCHAR2) IS
579: BEGIN
580: open x_trip_lov for
581: select name, trip_id, ship_method_code, carrier_id
582: from wsh_trips_ob_grp_v
583: where name like p_trip_name
584: and status_code = 'OP';
585: end GET_TRIP_LOV;
586:

Line 2369: FROM wsh_trip_stops wts, wsh_trips wt, wsh_delivery_legs wdl

2365:
2366: --Added for Bug 14696492
2367: CURSOR get_dlvy_trip(p_delivery_id NUMBER) IS
2368: SELECT wts.trip_id, wt.name
2369: FROM wsh_trip_stops wts, wsh_trips wt, wsh_delivery_legs wdl
2370: WHERE wdl.delivery_id = p_delivery_id
2371: AND wdl.pick_up_stop_id = wts.stop_id
2372: AND wts.trip_id = wt.trip_id;
2373: l_mul_del_trip VARCHAR2(1) := 'N';

Line 3146: wsh_trips wt

3142: p_trip_id
3143: FROM wsh_new_deliveries del,
3144: wsh_delivery_legs dlg,
3145: wsh_trip_stops st,
3146: wsh_trips wt
3147: WHERE del.delivery_id = dlg.delivery_id
3148: AND dlg.pick_up_stop_id = st.stop_id
3149: AND del.initial_pickup_location_id = st.stop_location_id
3150: AND st.trip_id = wt.trip_id