eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_UOM_CONV_F_SZ dependencies on EDW_LOCAL_INSTANCE

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 23: edw_local_instance eli,

19: muom.last_update_date between p_from_date and p_to_date
20: UNION
21: select count(*) cnt
22: FROM
23: edw_local_instance eli,
24: mtl_uom_class_conversions mucc ,
25: mtl_system_items_kfv msik
26: where
27: mucc.from_uom_code <> mucc.to_uom_code and

Line 91: EDW_LOCAL_INSTANCE ELI,

87: -- x_CREATION_DATE NUMBER ;
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