DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on WSH_DELIVERY_LEGS

Line 2458: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts

2454: wdd.released_status,
2455: wdd.delivery_detail_id
2456: INTO l_demand_info
2457: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
2458: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts
2459: WHERE wnd.delivery_id(+) = wda.delivery_id
2460: AND wlg.delivery_id(+) = wnd.delivery_id
2461: AND wts.stop_id(+) = wlg.pick_up_stop_id
2462: AND NVL(wlg.sequence_number,-1) =

Line 2464: FROM wsh_delivery_legs g

2460: AND wlg.delivery_id(+) = wnd.delivery_id
2461: AND wts.stop_id(+) = wlg.pick_up_stop_id
2462: AND NVL(wlg.sequence_number,-1) =
2463: (SELECT NVL(min(g.sequence_number),-1)
2464: FROM wsh_delivery_legs g
2465: WHERE g.delivery_id(+) = wnd.delivery_id )
2466: AND wdd.delivery_detail_id = wda.delivery_detail_id
2467: AND wdd.move_order_line_id = p_mo_line_rec.line_id
2468: AND wdd.move_order_line_Id IS NOT NULL