162: IF p_inventory_item_id IS NOT NULL THEN
163: BEGIN
164: SELECT substr(global_attribute10,1,4)
165: INTO l_product_line_code
166: FROM mtl_system_items
167: WHERE inventory_item_id = p_inventory_item_id
168: AND organization_id = l_so_org_id;
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN