APPS.WMS_UT_PKG dependencies on WSH_DELIVERY_DETAILS

Line 1909: from wsh_new_deliveries a, wsh_delivery_details b,wsh_delivery_assignments c

1905: l_from_req_date DATE;
1906: l_to_req_date DATE;
1907:
1908: cursor c1 is select distinct a.batch_id
1909: from wsh_new_deliveries a, wsh_delivery_details b,wsh_delivery_assignments c
1910: where c.delivery_id = a.delivery_id
1911: and c.delivery_detail_id = b.delivery_detail_id
1912: and b.batch_id =l_X_BATCH_ID;
1913: Begin

Line 2625: FROM wsh_delivery_details

2621: -- OE_SALES_CAN_UTIL.perform_cancel_order ( p_header_rec => l_soh , x_return_status => l_return_status);
2622: print_debug('Deleting detail deliveries from line ' || s_rec.line_id);
2623: SELECT sum(requested_quantity), max(delivery_detail_id)
2624: INTO l_req_qty, l_max_del_det_id
2625: FROM wsh_delivery_details
2626: WHERE source_line_id = s_rec.line_id;
2627:
2628: DELETE FROM wsh_delivery_details
2629: WHERE source_line_id = s_rec.line_id

Line 2628: DELETE FROM wsh_delivery_details

2624: INTO l_req_qty, l_max_del_det_id
2625: FROM wsh_delivery_details
2626: WHERE source_line_id = s_rec.line_id;
2627:
2628: DELETE FROM wsh_delivery_details
2629: WHERE source_line_id = s_rec.line_id
2630: AND delivery_detail_id <> l_max_del_det_id;
2631:
2632: --- Bug 4951858

Line 2633: UPDATE wsh_delivery_details

2629: WHERE source_line_id = s_rec.line_id
2630: AND delivery_detail_id <> l_max_del_det_id;
2631:
2632: --- Bug 4951858
2633: UPDATE wsh_delivery_details
2634: SET requested_quantity = l_req_qty
2635: WHERE delivery_detail_id = l_max_del_det_id;
2636: END LOOP;
2637:

Line 2647: UPDATE wsh_delivery_details set move_order_line_id = NULL, released_status = 'R'

2643: x_msg_data => l_msg_data,
2644: p_line_id => c_rec.line_id);
2645:
2646:
2647: UPDATE wsh_delivery_details set move_order_line_id = NULL, released_status = 'R'
2648: WHERE move_order_line_id = c_rec.line_id;
2649:
2650: -- INV_MO_ADMIN_PUB.cancel_line(1.0,'F','F',FND_API.G_VALID_LEVEL_FULL,c_rec.line_id,l_msg_count,l_msg_data,l_return_status);
2651: END LOOP;