APPS.WMS_PUTAWAY_UTILS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 11660: FROM wsh_delivery_assignments_v wda1

11656: -- Make sure that the Into LPN does not contain other deliveres
11657: BEGIN
11658: SELECT 'N'
11659: INTO l_allowed
11660: FROM wsh_delivery_assignments_v wda1
11661: , wsh_delivery_assignments_v wda2
11662: , wsh_delivery_details wdd
11663: WHERE wda1.delivery_detail_id = p_backorder_delivery_detail_id
11664: AND wda2.delivery_detail_id = wdd.delivery_detail_id

Line 11661: , wsh_delivery_assignments_v wda2

11657: BEGIN
11658: SELECT 'N'
11659: INTO l_allowed
11660: FROM wsh_delivery_assignments_v wda1
11661: , wsh_delivery_assignments_v wda2
11662: , wsh_delivery_details wdd
11663: WHERE wda1.delivery_detail_id = p_backorder_delivery_detail_id
11664: AND wda2.delivery_detail_id = wdd.delivery_detail_id
11665: AND wdd.lpn_id = l_into_lpn_id

Line 12478: wsh_delivery_assignments_v wda

12474: CURSOR c_lpn_bo_dd_id (v_lpn_id NUMBER)IS
12475: SELECT mtrl.backorder_delivery_detail_id,
12476: wda.delivery_id
12477: FROM mtl_txn_request_lines mtrl,
12478: wsh_delivery_assignments_v wda
12479: WHERE lpn_id = v_lpn_id
12480: AND mtrl.backorder_delivery_detail_id = wda.delivery_detail_id;
12481:
12482: l_count NUMBER := 1;