DBA Data[Home] [Help]

APPS.IEX_STRY_UTL_PUB dependencies on MTL_UOM_CONVERSIONS

Line 1018: select conversion_rate into l_conversion from mtl_uom_conversions

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