Function to get the Item description by passing parameter as inventory item id

CREATE OR REPLACE FUNCTION getitemd(p1 in number) return varchar2 as
v_item_desc varchar2(240);
begin
select distinct description into v_item_desc from mtl_system_items
where inventory_item_id=p1;
return v_item_desc;
end;
/