Thursday, August 18, 2011

Inv Uom QTY Conrt


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;