APPS.WSH_WF_STD dependencies on WSH_TRIP_STOPS

Line 1787: WSH_TRIP_STOPS wts

1783:
1784: CURSOR get_trip_del(l_trip_id IN NUMBER) IS
1785: select delivery_id
1786: from WSH_DELIVERY_LEGS wdl,
1787: WSH_TRIP_STOPS wts
1788: where wdl.pick_up_stop_id = wts.stop_id and
1789: wts.trip_id = l_trip_id;
1790:
1791: CURSOR get_delivery(l_event_key IN VARCHAR2) IS

Line 1984: wsh_trip_stops wts,

1980: NVL(wt.carrier_id, wnd.carrier_id) carrier_id
1981: FROM
1982: wsh_trips wt,
1983: wsh_delivery_legs wdl,
1984: wsh_trip_stops wts,
1985: wsh_new_deliveries wnd
1986: WHERE wts.trip_id = wt.trip_id
1987: AND wdl.pick_up_stop_id = wts.stop_id
1988: AND wnd.initial_pickup_location_id = wts.stop_location_id

Line 2184: wsh_trip_stops wts

2180: wnd.delivery_id
2181: FROM
2182: wsh_new_deliveries wnd,
2183: wsh_delivery_legs wdl,
2184: wsh_trip_stops wts
2185: WHERE
2186: wts.trip_id = p_trip_id AND
2187: wts.stop_id = wdl.pick_up_stop_id AND
2188: wnd.initial_pickup_location_id = wts.stop_location_id AND