Wednesday 28 March 2012

Function to get the Item description by passing parameters as inventory item id and organziation id

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;
/

No comments:

Post a Comment