DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 12640: FROM wsh_delivery_assignments_v wda1

12636: --Commented for BUG#11769042
12637: /* BEGIN
12638: SELECT 'N'
12639: INTO l_allowed
12640: FROM wsh_delivery_assignments_v wda1
12641: , wsh_delivery_assignments_v wda2
12642: , wsh_delivery_details wdd
12643: WHERE wda1.delivery_detail_id = p_backorder_delivery_detail_id
12644: AND wda2.delivery_detail_id = wdd.delivery_detail_id

Line 12641: , wsh_delivery_assignments_v wda2

12637: /* BEGIN
12638: SELECT 'N'
12639: INTO l_allowed
12640: FROM wsh_delivery_assignments_v wda1
12641: , wsh_delivery_assignments_v wda2
12642: , wsh_delivery_details wdd
12643: WHERE wda1.delivery_detail_id = p_backorder_delivery_detail_id
12644: AND wda2.delivery_detail_id = wdd.delivery_detail_id
12645: AND wdd.lpn_id = l_into_lpn_id

Line 12710: FROM wsh_delivery_assignments_v wda ,

12706: IF l_into_lpn_context = 11 THEN
12707:
12708: SELECT wda.delivery_detail_id
12709: INTO l_bo_d_to_id
12710: FROM wsh_delivery_assignments_v wda ,
12711: wsh_delivery_details wdd
12712: WHERE wdd.lpn_id = l_into_lpn_id
12713: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id
12714: AND ROWNUM = 1;