DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on WSH_TRIP_STOPS

Line 1684: wsh_trip_stops wts

1680: SELECT wts.actual_departure_date
1681: INTO l_txn_date
1682: FROM wsh_new_deliveries wnd,
1683: wsh_delivery_legs wdl,
1684: wsh_trip_stops wts
1685: WHERE wnd.delivery_id = wdl.delivery_id
1686: AND wdl.pick_up_stop_id = wts.stop_id
1687: AND wnd.initial_pickup_location_id = wts.stop_location_id
1688: AND wnd.delivery_id = p_delivery_id;

Line 1946: wsh_trip_stops wts

1942: SELECT wts.actual_departure_date
1943: INTO l_txn_date
1944: FROM wsh_new_deliveries wnd,
1945: wsh_delivery_legs wdl,
1946: wsh_trip_stops wts
1947: WHERE wnd.delivery_id = wdl.delivery_id
1948: AND wdl.pick_up_stop_id = wts.stop_id
1949: AND wnd.initial_pickup_location_id = wts.stop_location_id
1950: AND wnd.delivery_id = p_delivery_id;