169: IF p_inventory_item_id IS NOT NULL THEN
170: BEGIN
171: SELECT substr(global_attribute10,1,4)
172: INTO l_product_line_code
173: FROM mtl_system_items
174: WHERE inventory_item_id = p_inventory_item_id
175: AND organization_id = l_so_org_id;
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN