APPS.GMD_COMMON_SCALE dependencies on MTL_UNITS_OF_MEASURE

Line 40: * to sy_uoms table to mtl_units_of measure and used the INV_CONVERT.inv_um_convert

36: * In the ceil_up and floor_down procedures, the qty. should first be rounded off
37: * to 9 digits before integer scaling is done.
38: * S.Sriram 26-Nov2004 NPD Convergence.
39: * Added orgn_id in scale and theoretical_yield procedures and modified references
40: * to sy_uoms table to mtl_units_of measure and used the INV_CONVERT.inv_um_convert
41: * procedure for Qty. conversion.
42: * TDaniel 21-NOV-2006 Bug 5667857 - Changed unit_of_measure reference to UOM_CODE.
43: * Raju 31-DEC-2011 Bug 13603986 - Changed mtl_unit_of_measure reference to mtl_unit_of_measure_vl.
44: *****************************************************************************************************************/

Line 80: FROM mtl_units_of_measure_vl

76: IS
77:
78: CURSOR sy_uoms_typ_cursor(v_yield_type VARCHAR2) IS
79: SELECT uom_code
80: FROM mtl_units_of_measure_vl
81: WHERE uom_class = v_yield_type
82: AND base_uom_flag = 'Y';
83:
84: l_yield_type VARCHAR2(30);

Line 129: l_conv_uom mtl_units_of_measure.uom_code%TYPE;

125: --End Bug#3164299
126: l_qty NUMBER;
127: l_tab_size NUMBER;
128: -- l_conv_uom sy_uoms_mst.um_code%TYPE;
129: l_conv_uom mtl_units_of_measure.uom_code%TYPE;
130: l_type_0_Y_outputs NUMBER:= 0;
131: l_type_1_Y_outputs NUMBER:= 0;
132: l_type_2_Y_outputs NUMBER:= 0;
133: l_type_0_N_outputs NUMBER:= 0;

Line 157: FROM mtl_units_of_measure_vl

153: l_output_total NUMBER:= 0;
154:
155: CURSOR sy_uoms_typ_cursor(v_yield_type VARCHAR2) IS
156: SELECT uom_code
157: FROM mtl_units_of_measure_vl
158: WHERE uom_class = v_yield_type
159: AND base_uom_flag = 'Y';
160:
161: l_yield_type VARCHAR2(30);

Line 1460: l_conv_uom mtl_units_of_measure.uom_code%TYPE;

1456:
1457: l_qty NUMBER;
1458: l_tab_size NUMBER;
1459: --l_conv_uom sy_uoms_mst.um_code%TYPE;
1460: l_conv_uom mtl_units_of_measure.uom_code%TYPE;
1461: l_type_0_Y_outputs NUMBER:= 0;
1462: l_type_1_Y_outputs NUMBER:= 0;
1463: l_type_2_Y_outputs NUMBER:= 0;
1464: l_type_0_Y_inputs NUMBER:= 0;