DBA Data[Home] [Help]

APPS.OPI_EDW_UOM_CONV_F_SZ dependencies on MTL_UOM_CONVERSIONS

Line 10: FROM EDW_LOCAL_INSTANCE ELI, MTL_UOM_CONVERSIONS MUC,

6: p_num_rows OUT NOCOPY NUMBER) IS
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

Line 92: MTL_UOM_CONVERSIONS MUC,

88: avg(nvl(vsize(MUC.CREATION_DATE), 0))
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