Search 800 + Posts

Apr 11, 2011

API to Convert UOM

Simple API to covert Qty from 'From UOM' to 'To UOM' , there are many API available in apps for same purpose, I used this one .

declare
l number;
l_from_uom VARCHAR2(100):='&Enter_from_uom';
l_to_uom VARCHAR2(100):='&Enter_to_uom';
l_primary_qty NUMBER := &Enetr_qty_in_pri_uom;
l_inv_item_id NUMBER := &Enter_item_id;
begin
--l:=INV_RCV_CACHE.convert_qty(149,120,'EA','DOZ',NULL,NULL,NULL);
l:=INV_RCV_CACHE.convert_qty(l_inv_item_id,l_primary_qty,l_from_uom,l_to_uom,NULL,NULL,NULL);
dbms_output.put_line('l = '||l);
end;

No comments:

Post a Comment