[Home] [Help]
28: spl.inventory_item_id) ) weight,
29: msi.weight_uom_code uom
30: FROM so_picking_line_details spld,
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
72: sum(NVL(pld.shipped_quantity, 0)) qty
73: FROM so_picking_line_details pld,
74: so_picking_lines_all pl,
75: so_line_details ld,
76: so_lines_all l,
77: so_headers_all h,
78: mtl_system_items i_msi, -- configuration item
79: mtl_system_items m_msi -- model
80: WHERE pld.delivery_id = x_del_id
178: IS
179:
180: CURSOR ato_model(x_a_line_id NUMBER) IS
181: SELECT (NVL(sl.ordered_quantity, 0) - NVL(sl.cancelled_quantity, 0)) qty
182: FROM so_lines_all sl
183: WHERE sl.line_id = x_a_line_id;
184:
185:
186: -- The two cursors ato_weight and ato_volume have the
193: sld.quantity,
194: sld.inventory_item_id) ) weight,
195: msi.weight_uom_code uom
196: FROM so_line_details sld,
197: so_lines_all sl,
198: mtl_system_items msi
199: WHERE sl.ato_line_id = x_a_line_id
200: AND sld.line_id = sl.line_id
201: AND sld.included_item_flag = 'N'
211: sld.quantity,
212: sld.inventory_item_id) ) volume,
213: msi.volume_uom_code uom
214: FROM so_line_details sld,
215: so_lines_all sl,
216: mtl_system_items msi
217: WHERE sl.ato_line_id = x_a_line_id
218: AND sld.line_id = sl.line_id
219: AND sld.included_item_flag = 'N'
747: x_ship_f*pld.requested_quantity)) qty
748: FROM so_picking_line_details pld,
749: so_picking_lines_all pl,
750: so_line_details ld,
751: so_lines_all l,
752: mtl_system_items i_msi, -- configuration item
753: mtl_system_items m_msi -- model
754: WHERE pld.delivery_id = x_del_id
755: AND pld.container_id = x_cont_id