CREATE OR REPLACE FUNCTION getitemdesc(p1 in number, p2 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 and organization_id = p2;
return v_item_desc;
end;
/
v_item_desc varchar2(240);
begin
select distinct description into v_item_desc from mtl_system_items
where inventory_item_id=p1 and organization_id = p2;
return v_item_desc;
end;
/
No comments:
Post a Comment