DBA Data[Home] [Help]

APPS.JMF_SHIKYU_UTIL dependencies on MTL_UNITS_OF_MEASURE

Line 272: FROM mtl_units_of_measure

268: END IF;
269:
270: SELECT uom_code
271: INTO l_uom_code
272: FROM mtl_units_of_measure
273: WHERE unit_of_measure = p_unit_of_measure;
274:
275: IF g_fnd_debug = 'Y' AND
276: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 497: FROM mtl_units_of_measure

493: END IF;
494:
495: SELECT uom_code
496: INTO l_from_code
497: FROM mtl_units_of_measure
498: WHERE unit_of_measure = p_purchasing_UOM ;
499:
500: SELECT mum.uom_code
501: INTO l_to_code

Line 502: FROM mtl_units_of_measure mum

498: WHERE unit_of_measure = p_purchasing_UOM ;
499:
500: SELECT mum.uom_code
501: INTO l_to_code
502: FROM mtl_units_of_measure mum
503: , mtl_system_items msi
504: WHERE mum.unit_of_measure = msi.primary_unit_of_measure
505: AND msi.inventory_item_id = p_inventory_item_id
506: AND msi.primary_unit_of_measure = mum.unit_of_measure