APPS.WSH_FC_INTERFACE_PKG dependencies on WSH_TRIP_STOPS

Line 95: wsh_trip_stops st

91: CURSOR c_pickup_deliveries (c_stop_id NUMBER) IS
92: SELECT dg.delivery_id
93: FROM wsh_delivery_legs dg,
94: wsh_new_deliveries dl,
95: wsh_trip_stops st
96: WHERE st.stop_id = dg.pick_up_stop_id AND
97: st.stop_id = c_stop_id AND
98: st.stop_location_id = dl.initial_pickup_location_id AND
99: dg.delivery_id = dl.delivery_id;

Line 103: FROM wsh_trip_stops

99: dg.delivery_id = dl.delivery_id;
100:
101: CURSOR c_trip_stops (c_trip_id NUMBER) IS
102: SELECT stop_id
103: FROM wsh_trip_stops
104: WHERE trip_id = c_trip_id
105: AND nvl(shipments_type_flag,'O') IN ('O','M');
106:
107: l_detail_info c_delivery_details%ROWTYPE;

Line 2080: FROM wsh_trip_stops st,

2076: IS
2077:
2078: CURSOR C_Sharing_Stops IS
2079: SELECT distinct st.stop_id
2080: FROM wsh_trip_stops st,
2081: wsh_new_deliveries nd,
2082: wsh_delivery_legs dl,
2083: wsh_delivery_assignments_v da,
2084: wsh_delivery_details dd

Line 2156: from wsh_trip_stops st,

2152: END IF;
2153: --
2154: /* get number of stops with pickup deliveries in this trip */
2155: select count(distinct st.stop_id) into l_number_of_stops
2156: from wsh_trip_stops st,
2157: wsh_new_deliveries nd,
2158: wsh_delivery_legs dl,
2159: wsh_delivery_assignments_v da,
2160: wsh_delivery_details dd

Line 2408: FROM WSH_TRIP_STOPS

2404:
2405:
2406: CURSOR C_ACTUAL_DEPARTURE_DATE IS
2407: SELECT actual_departure_date
2408: FROM WSH_TRIP_STOPS
2409: WHERE stop_id = p_stop_id;
2410:
2411:
2412: i NUMBER := 0;

Line 2971: wsh_trip_stops b,

2967: SELECT a.trip_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2968: c.freight_cost_type_code
2969: , a.conversion_type_code, a.conversion_rate
2970: FROM wsh_freight_costs a,
2971: wsh_trip_stops b,
2972: wsh_freight_cost_types c
2973: WHERE a.trip_id = b.trip_id and
2974: b.stop_id = p_stop_id and
2975: c.freight_cost_type_id = a.freight_cost_type_id and

Line 3018: wsh_trip_stops wts

3014: FROM wsh_freight_costs wfc,
3015: wsh_freight_cost_types wft,
3016: wsh_delivery_legs wdl,
3017: wsh_new_deliveries wnd,
3018: wsh_trip_stops wts
3019: WHERE wts.stop_id = p_stop_id and
3020: wts.stop_id = wdl.pick_up_stop_id and
3021: wts.stop_location_id = wnd.initial_pickup_location_id and
3022: wdl.delivery_id = wnd.delivery_id and

Line 3055: wsh_trip_stops wts

3051: wsh_freight_costs wfc,
3052: wsh_freight_cost_types wft,
3053: wsh_delivery_legs wdl,
3054: wsh_new_deliveries wnd,
3055: wsh_trip_stops wts
3056: WHERE wts.stop_id = wdl.pick_up_stop_id and
3057: wts.stop_id = p_stop_id and
3058: wts.stop_location_id = wnd.initial_pickup_location_id and
3059: wdl.delivery_id = wnd.delivery_id and

Line 3091: wsh_trip_stops wts

3087: wsh_freight_costs wfc,
3088: wsh_freight_cost_types wft,
3089: wsh_delivery_legs wdl,
3090: wsh_new_deliveries wnd,
3091: wsh_trip_stops wts
3092: WHERE wts.stop_id = wdl.pick_up_stop_id and
3093: wts.stop_id = p_stop_id and
3094: wts.stop_location_id = wnd.initial_pickup_location_id and
3095: wdl.delivery_id = wnd.delivery_id and