APPS.WMS_PUTAWAY_UTILS dependencies on WSH_DELIVERY_DETAILS

Line 12642: , wsh_delivery_details wdd

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
12646: AND Nvl(wda1.delivery_id,-1) <> Nvl(wda2.delivery_id,-2);

Line 12711: wsh_delivery_details wdd

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;
12715:

Line 12755: wsh_delivery_details_grp.get_carton_grouping(p_line_rows => v_line_rows,

12751: v_line_rows(2) := l_bo_d_to_id;
12752:
12753: IF l_bo_d_to_id IS NOT NULL AND l_bo_d_frm_id IS NOT NULL THEN
12754:
12755: wsh_delivery_details_grp.get_carton_grouping(p_line_rows => v_line_rows,
12756: x_grouping_rows => v_grouping_rows,
12757: x_return_status => l_return_status);
12758: IF (l_debug = 1) THEN
12759: debug('l_return_status: '||l_return_status,'validate_into_lpn',9);

Line 14605: debug('populate_grouping_rows: before calling wsh_delivery_details_grp.get_carton_grouping');

14601:
14602: IF (l_count_so > 0 ) THEN --We are dealing with SO xdock lines here.
14603: IF (l_debug = 1) THEN
14604: debug('populate_grouping_rows: g_line_rows.count='||g_line_rows.count);
14605: debug('populate_grouping_rows: before calling wsh_delivery_details_grp.get_carton_grouping');
14606: END IF;
14607:
14608: l_progress := 400;
14609:

Line 14610: wsh_delivery_details_grp.get_carton_grouping(p_line_rows => g_line_rows,

14606: END IF;
14607:
14608: l_progress := 400;
14609:
14610: wsh_delivery_details_grp.get_carton_grouping(p_line_rows => g_line_rows,
14611: x_grouping_rows => g_grouping_rows,
14612: x_return_status => l_return_status);
14613:
14614: l_progress := 500;

Line 14617: debug('populate_grouping_rows: after calling wsh_delivery_details_grp.get_carton_grouping');

14613:
14614: l_progress := 500;
14615:
14616: IF (l_debug = 1) THEN
14617: debug('populate_grouping_rows: after calling wsh_delivery_details_grp.get_carton_grouping');
14618: debug('populate_grouping_rows: g_grouping_rows.count='||g_grouping_rows.COUNT);
14619: END IF;
14620:
14621: IF (l_count_non_so > 0) THEN --If there are any non-so lines, lets append them