509: --yawang fix bug 2326128, re-design the way we calculate the unit weight
510: --Find the class of transaction uom
511: SELECT uom_class
512: INTO l_tranx_uom_class
513: FROM mtl_units_of_measure_vl
514: WHERE uom_code = p_tranx_uom_code;
515:
516: --Find the class of movement uom defined on movement statistics parameter form
517: SELECT uom_class
515:
516: --Find the class of movement uom defined on movement statistics parameter form
517: SELECT uom_class
518: INTO l_stat_typ_uom_class
519: FROM mtl_units_of_measure_vl
520: WHERE uom_code = p_stat_typ_uom_code;
521:
522: --Scenario 1, the transaction uom is of weight class
523: --we will do intra-class conversion if the transaction uom is different