DBA Data[Home] [Help]

APPS.IEX_STRY_UTL_PUB dependencies on MTL_UOM_CONVERSIONS

Line 1012: select conversion_rate into l_conversion from mtl_uom_conversions

1008: iex_debug_pub.logmessage ('get_date before get conversion rate ');
1009: END IF;
1010: --Start of bug 7434190 22-Jan-2009 barathsr
1011: l_jtf_time_uom_class := fnd_profile.value_specific(NAME => 'JTF_TIME_UOM_CLASS',APPLICATION_ID =>695);
1012: select conversion_rate into l_conversion from mtl_uom_conversions
1013: --Use the profile 'unit of measure class' value if it is set at application level, else use it from site level
1014: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */
1015: where UOM_code = l_UOM and uom_class = l_jtf_time_uom_class
1016: --End of Bug 7434190 22-Jan-2009 barathsr