APPS.WSH_WF_STD dependencies on WSH_DELIVERY_LEGS

Line 1786: from WSH_DELIVERY_LEGS wdl,

1782: WHERE wf_item_key = l_wf_item_key;
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:

Line 1983: wsh_delivery_legs wdl,

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

Line 2183: wsh_delivery_legs wdl,

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