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.MST_WB_UTIL dependencies on MTL_UOM_CONVERSIONS

Line 6137: FROM mtl_uom_conversions muc1,

6133: WHERE uom_code = p_uom_code;
6134:
6135: CURSOR l_intraclass_conversion_cur (p_from_uom_code VARCHAR2, p_to_uom_code VARCHAR2) IS
6136: SELECT muc2.conversion_rate/muc1.conversion_rate
6137: FROM mtl_uom_conversions muc1,
6138: mtl_uom_conversions muc2
6139: WHERE muc1.inventory_item_id = 0
6140: AND muc2.inventory_item_id = 0
6141: AND muc1.uom_class = l_to_uom_class

Line 6138: mtl_uom_conversions muc2

6134:
6135: CURSOR l_intraclass_conversion_cur (p_from_uom_code VARCHAR2, p_to_uom_code VARCHAR2) IS
6136: SELECT muc2.conversion_rate/muc1.conversion_rate
6137: FROM mtl_uom_conversions muc1,
6138: mtl_uom_conversions muc2
6139: WHERE muc1.inventory_item_id = 0
6140: AND muc2.inventory_item_id = 0
6141: AND muc1.uom_class = l_to_uom_class
6142: AND muc1.uom_code = p_to_uom_code

Line 6148: FROM mtl_uom_conversions_view muc

6144: AND muc2.uom_code = p_from_uom_code;
6145:
6146: CURSOR l_interclass_conversion_cur (p_uom1 VARCHAR2, p_uom2 VARCHAR2, p_org_id NUMBER, p_inventory_item_id NUMBER) IS
6147: SELECT muc.conversion_rate
6148: FROM mtl_uom_conversions_view muc
6149: WHERE muc.inventory_item_id = p_inventory_item_id
6150: AND muc.organization_id = p_org_id
6151: AND muc.primary_uom_code = p_uom1
6152: AND muc.uom_code = p_uom2;