Showing posts with label API to Convert UOM(INVENTORY). Show all posts
Showing posts with label API to Convert UOM(INVENTORY). Show all posts

Wednesday, 13 April 2011

API to Convert UOM(INVENTORY)

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;