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 2401: FROM WSH_TRIP_STOPS

2397:
2398:
2399: CURSOR C_ACTUAL_DEPARTURE_DATE IS
2400: SELECT actual_departure_date
2401: FROM WSH_TRIP_STOPS
2402: WHERE stop_id = p_stop_id;
2403:
2404:
2405: i NUMBER := 0;

Line 2964: wsh_trip_stops b,

2960: SELECT a.trip_id, a.freight_cost_id, a.unit_amount, a.currency_code,
2961: c.freight_cost_type_code
2962: , a.conversion_type_code, a.conversion_rate
2963: FROM wsh_freight_costs a,
2964: wsh_trip_stops b,
2965: wsh_freight_cost_types c
2966: WHERE a.trip_id = b.trip_id and
2967: b.stop_id = p_stop_id and
2968: c.freight_cost_type_id = a.freight_cost_type_id and

Line 3011: wsh_trip_stops wts

3007: FROM wsh_freight_costs wfc,
3008: wsh_freight_cost_types wft,
3009: wsh_delivery_legs wdl,
3010: wsh_new_deliveries wnd,
3011: wsh_trip_stops wts
3012: WHERE wts.stop_id = p_stop_id and
3013: wts.stop_id = wdl.pick_up_stop_id and
3014: wts.stop_location_id = wnd.initial_pickup_location_id and
3015: wdl.delivery_id = wnd.delivery_id and

Line 3048: wsh_trip_stops wts

3044: wsh_freight_costs wfc,
3045: wsh_freight_cost_types wft,
3046: wsh_delivery_legs wdl,
3047: wsh_new_deliveries wnd,
3048: wsh_trip_stops wts
3049: WHERE wts.stop_id = wdl.pick_up_stop_id and
3050: wts.stop_id = p_stop_id and
3051: wts.stop_location_id = wnd.initial_pickup_location_id and
3052: wdl.delivery_id = wnd.delivery_id and

Line 3084: wsh_trip_stops wts

3080: wsh_freight_costs wfc,
3081: wsh_freight_cost_types wft,
3082: wsh_delivery_legs wdl,
3083: wsh_new_deliveries wnd,
3084: wsh_trip_stops wts
3085: WHERE wts.stop_id = wdl.pick_up_stop_id and
3086: wts.stop_id = p_stop_id and
3087: wts.stop_location_id = wnd.initial_pickup_location_id and
3088: wdl.delivery_id = wnd.delivery_id and