APPS.GMD_SPREAD_CALCULATE_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 284: FROM mtl_units_of_measure

280: WHERE line_type = V_line_type
281: AND d1.parent_line_id = d.parent_line_id));
282: CURSOR Cur_std_um (V_uom_type VARCHAR2) IS
283: SELECT uom_code
284: FROM mtl_units_of_measure
285: WHERE uom_class = V_uom_type;
286:
287: X_ingred_vol NUMBER ;
288: X_ingred_volpct NUMBER ;

Line 813: FROM mtl_units_of_measure

809:
810: /* Bug No.8317833 - Changed the SELECT clause of below cursor from unit_of_measure to uom_code */
811: CURSOR get_unit_of_measure(v_yield_type VARCHAR2) IS
812: SELECT uom_code
813: FROM mtl_units_of_measure
814: WHERE uom_class = v_yield_type
815: AND base_uom_flag = 'Y';
816:
817: l_org_id NUMBER;

Line 867: FROM mtl_units_of_measure

863: -- UOM COnversions
864: IF l_rec.detail_uom IS NOT NULL THEN
865: SELECT uom_class
866: INTO l_uom_class
867: FROM mtl_units_of_measure
868: where uom_code = l_rec .detail_uom;
869:
870: IF NVL(l_common_uom_class,l_uom_class) <> l_uom_class THEN
871: OPEN get_unit_of_measure(l_yield_type);