7: CURSOR c_cnt_rows IS
8: select sum(cnt)
9: from (select count(*) cnt
10: FROM EDW_LOCAL_INSTANCE ELI, MTL_UOM_CONVERSIONS MUC,
11: MTL_UNITS_OF_MEASURE MUOM, MTL_UNITS_OF_MEASURE BUOM,
12: mtl_system_items_kfv msik
13: WHERE
14: muom.uom_code = muc.uom_code and
15: muom.uom_class = muc.uom_class and
89: -- x_CLASS_CONVERSION_FLAG NUMBER ;
90: FROM
91: EDW_LOCAL_INSTANCE ELI,
92: MTL_UOM_CONVERSIONS MUC,
93: MTL_UNITS_OF_MEASURE MUOM,
94: MTL_UNITS_OF_MEASURE BUOM,
95: mtl_system_items_kfv msik
96: WHERE
97: muom.uom_code = muc.uom_code and
90: FROM
91: EDW_LOCAL_INSTANCE ELI,
92: MTL_UOM_CONVERSIONS MUC,
93: MTL_UNITS_OF_MEASURE MUOM,
94: MTL_UNITS_OF_MEASURE BUOM,
95: mtl_system_items_kfv msik
96: WHERE
97: muom.uom_code = muc.uom_code and
98: muom.uom_class = muc.uom_class and