APPS.INV_PICK_RELEASE_PVT dependencies on WSH_NEW_DELIVERIES

Line 2148: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts

2144: wdd.released_status,
2145: wdd.delivery_detail_id
2146: INTO l_demand_info
2147: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
2148: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts
2149: WHERE wnd.delivery_id(+) = wda.delivery_id
2150: AND wlg.delivery_id(+) = wnd.delivery_id
2151: AND wts.stop_id(+) = wlg.pick_up_stop_id
2152: AND NVL(wlg.sequence_number,-1) =