APPS.GME_CREATE_STEP_PVT dependencies on MTL_UOM_CONVERSIONS

Line 1038: FROM mtl_uom_conversions

1034: step qty uom used */
1035: --get the uom class and conversion rate in step qty uom
1036: SELECT uom_class, conversion_rate
1037: INTO l_uom_class, l_std_factor
1038: FROM mtl_uom_conversions
1039: WHERE uom_code = p_recipe_rout_step_tbl (1).process_qty_uom
1040: AND inventory_item_id = 0;
1041:
1042: l_mass_qty := NULL;

Line 3359: FROM mtl_uom_conversions a, mtl_units_of_measure b

3355:
3356: CURSOR cur_get_std_factor (v_uom_code VARCHAR2)
3357: IS
3358: SELECT a.conversion_rate, b.uom_class
3359: FROM mtl_uom_conversions a, mtl_units_of_measure b
3360: WHERE a.uom_code = b.uom_code
3361: AND a.inventory_item_id = 0
3362: AND b.uom_code = v_uom_code;
3363:

Line 3608: FROM mtl_uom_conversions a, mtl_units_of_measure b

3604:
3605: CURSOR get_um_type_and_factor (v_uom_code VARCHAR2)
3606: IS
3607: SELECT b.uom_class, a.conversion_rate
3608: FROM mtl_uom_conversions a, mtl_units_of_measure b
3609: WHERE a.uom_code = b.uom_code
3610: AND a.inventory_item_id = 0
3611: AND b.uom_code = v_uom_code;
3612: BEGIN