DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on WSH_DELIVERY_LEGS

Line 1683: wsh_delivery_legs wdl,

1679: --
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

Line 1945: wsh_delivery_legs wdl,

1941: --
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