APPS.WSH_WVX_PVT dependencies on WSH_DELIVERIES

Line 35: wsh_deliveries wd

31: so_picking_lines_all spl,
32: so_lines_all sl,
33: so_headers_all sh,
34: mtl_system_items msi,
35: wsh_deliveries wd
36: WHERE spld.delivery_id = x_del_id
37: AND wd.delivery_id = x_del_id
38: AND spl.picking_line_id = spld.picking_line_id
39: AND spl.picking_header_id+0 > 0 -- NOT backordered

Line 59: wsh_deliveries wd

55: msi.weight_uom_code uom
56: FROM so_picking_line_details spld,
57: so_picking_lines_all spl,
58: mtl_system_items msi,
59: wsh_deliveries wd
60: WHERE spld.delivery_id = x_del_id
61: AND wd.delivery_id = x_del_id
62: AND spl.picking_line_id = spld.picking_line_id
63: AND spl.picking_header_id+0 > 0 -- NOT backordered

Line 318: from wsh_deliveries wd

314: cursor delivery_uoms(x_delivery_id NUMBER) is
315: select wd.weight_uom_code,
316: wd.volume_uom_code,
317: wd.organization_id
318: from wsh_deliveries wd
319: where wd.delivery_id = x_delivery_id;
320:
321: -- Do not NVL the values because NULL means "don't care".
322: cursor cont_info(x_delivery_id NUMBER) is

Line 381: w_uom WSH_DELIVERIES.weight_uom_code%TYPE := NULL;

377: --
378: -- Note: excess weight and volume are expressed in w_uom and v_uom.
379:
380: excess NUMBER := 0;
381: w_uom WSH_DELIVERIES.weight_uom_code%TYPE := NULL;
382: v_uom WSH_DELIVERIES.volume_uom_code%TYPE := NULL;
383:
384: -- Weight
385: w_count NUMBER := 0;

Line 382: v_uom WSH_DELIVERIES.volume_uom_code%TYPE := NULL;

378: -- Note: excess weight and volume are expressed in w_uom and v_uom.
379:
380: excess NUMBER := 0;
381: w_uom WSH_DELIVERIES.weight_uom_code%TYPE := NULL;
382: v_uom WSH_DELIVERIES.volume_uom_code%TYPE := NULL;
383:
384: -- Weight
385: w_count NUMBER := 0;
386: w_net_excess NUMBER := 0;