Wednesday 28 March 2012

Function to get the Item_code by passing the inventory item id

CREATE OR REPLACE FUNCTION getitem(p1 in number) return varchar2 as
v_item_code varchar2(30);
begin
select distinct segment1 into v_item_code from mtl_system_items
where inventory_item_id=p1;
return v_item_code;
end;
/

No comments:

Post a Comment