APPS.MSC_X_UTIL dependencies on MSC_UNITS_OF_MEASURE

Line 206: | measure in MSC_UNITS_OF_MEASURE. |

202: | Rownum = 1 is used to account for the corner case APS bug |
203: | when the same uom code points to different unit of measures |
204: | in multiple instances. This can be removed when APS makes |
205: | the fix to allow only 1 uom code in addition to unit of |
206: | measure in MSC_UNITS_OF_MEASURE. |
207: +--------------------------------------------------------------*/
208:
209: /*-----------------------------------------------------+
210: | Inventory Item Id = non zero is required only if |

Line 217: from msc_units_of_measure

213:
214: BEGIN
215: select uom_class
216: into l_uom_class
217: from msc_units_of_measure
218: where uom_code = p_uom_code
219: and rownum = 1;
220: EXCEPTION WHEN no_data_found then
221: p_conv_found := FALSE;

Line 229: from msc_units_of_measure

225:
226: BEGIN
227: select uom_class
228: into l_dest_uom_class
229: from msc_units_of_measure
230: where uom_code = p_dest_uom_code
231: and rownum = 1;
232: EXCEPTION WHEN no_data_found then
233: p_conv_found := FALSE;