APPS.GME_CREATE_STEP_PVT dependencies on MTL_UOM_CONVERSIONS

Line 953: FROM mtl_uom_conversions

949: step qty uom used */
950: --get the uom class and conversion rate in step qty uom
951: SELECT uom_class, conversion_rate
952: INTO l_uom_class, l_std_factor
953: FROM mtl_uom_conversions
954: WHERE uom_code = p_recipe_rout_step_tbl (1).process_qty_uom
955: AND inventory_item_id = 0;
956:
957: l_mass_qty := NULL;

Line 2858: FROM mtl_uom_conversions a, mtl_units_of_measure b

2854:
2855: CURSOR cur_get_std_factor (v_uom_code VARCHAR2)
2856: IS
2857: SELECT a.conversion_rate, b.uom_class
2858: FROM mtl_uom_conversions a, mtl_units_of_measure b
2859: WHERE a.uom_code = b.uom_code
2860: AND a.inventory_item_id = 0
2861: AND b.uom_code = v_uom_code;
2862:

Line 3107: FROM mtl_uom_conversions a, mtl_units_of_measure b

3103:
3104: CURSOR get_um_type_and_factor (v_uom_code VARCHAR2)
3105: IS
3106: SELECT b.uom_class, a.conversion_rate
3107: FROM mtl_uom_conversions a, mtl_units_of_measure b
3108: WHERE a.uom_code = b.uom_code
3109: AND a.inventory_item_id = 0
3110: AND b.uom_code = v_uom_code;
3111: BEGIN