DBA Data[Home] [Help]

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 781: FROM mtl_units_of_measure

777: where entity_id = V_entity_id;
778:
779: CURSOR get_unit_of_measure(v_yield_type VARCHAR2) IS
780: SELECT unit_of_measure
781: FROM mtl_units_of_measure
782: WHERE uom_class = v_yield_type
783: AND base_uom_flag = 'Y';
784:
785: l_org_id NUMBER;

Line 831: FROM mtl_units_of_measure

827: -- UOM COnversions
828: IF l_rec.detail_uom IS NOT NULL THEN
829: SELECT uom_class
830: INTO l_uom_class
831: FROM mtl_units_of_measure
832: where uom_code = l_rec .detail_uom;
833:
834: IF NVL(l_common_uom_class,l_uom_class) <> l_uom_class THEN
835: OPEN get_unit_of_measure(l_yield_type);