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: *****************************************************************************************************************/
44:

Line 79: FROM mtl_units_of_measure

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

Line 128: l_conv_uom mtl_units_of_measure.uom_code%TYPE;

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

Line 156: FROM mtl_units_of_measure

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

Line 1459: l_conv_uom mtl_units_of_measure.uom_code%TYPE;

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