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

Line 53: from mtl_uom_conversions

49: cursor l_standard_conversion(l_item_id number
50: ,l_uom_class varchar2
51: ,l_unit_of_measure varchar2) is
52: select conversion_rate
53: from mtl_uom_conversions
54: where uom_class = l_uom_class
55: and unit_of_measure = l_unit_of_measure
56: and INVENTORY_ITEM_ID in (l_item_id,0)
57: -- to take care of item specific vs standard conversion

Line 68: FROM mtl_uom_conversions

64: cursor l_standard_conversion2(l_item_id NUMBER
65: ,l_uom_class VARCHAR2
66: ,l_uom_code VARCHAR2) is
67: SELECT conversion_rate
68: FROM mtl_uom_conversions
69: WHERE uom_class = l_uom_class
70: AND uom_code = l_uom_code
71: AND INVENTORY_ITEM_ID in (l_item_id,0)
72: -- to take care of item specific vs standard conversion

Line 252: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_from_unit_of_measure AND inventory_item_id=0) from_uom,

248: l_conversion_rate := 1;
249:
250: SELECT (from_uom.conversion_rate * (1/to_uom.conversion_rate)) rate into l_conversion_rate
251: FROM
252: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_from_unit_of_measure AND inventory_item_id=0) from_uom,
253: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_to_unit_of_measure AND inventory_item_id=0) to_uom
254: WHERE
255: from_uom.uom_class=to_uom.uom_class;
256:

Line 253: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_to_unit_of_measure AND inventory_item_id=0) to_uom

249:
250: SELECT (from_uom.conversion_rate * (1/to_uom.conversion_rate)) rate into l_conversion_rate
251: FROM
252: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_from_unit_of_measure AND inventory_item_id=0) from_uom,
253: (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_to_unit_of_measure AND inventory_item_id=0) to_uom
254: WHERE
255: from_uom.uom_class=to_uom.uom_class;
256:
257: return l_conversion_rate;