302: l_item_control_rec.bom_item_type,
303: l_item_control_rec.primary_uom_code,
304: l_item_control_rec.model_item_id,
305: l_item_control_rec.pick_components_flag
306: FROM mtl_system_items
307: WHERE inventory_item_id = l_item_control_rec.inventory_item_id
308: AND organization_id = l_item_control_rec.organization_id;
309: EXCEPTION
310: WHEN no_data_found THEN
317:
318: BEGIN
319: SELECT distinct serial_number_control_code
320: INTO l_tmp_id1
321: FROM mtl_system_items_b
322: WHERE inventory_item_id = l_item_control_rec.inventory_item_id;
323: l_item_control_rec.mult_srl_control_flag := 'N';
324: EXCEPTION
325: WHEN too_many_rows THEN