APPS.INL_LANDEDCOST_PVT dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 217: FROM mtl_uom_conversions_view

213: -- first get it converted to the primary
214: IF p_from_uom_code <> l_primary_uom_code THEN
215: SELECT 1/NVL(conversion_rate,0) * NVL(p_unit_price,0)
216: INTO l_converted_price
217: FROM mtl_uom_conversions_view
218: WHERE primary_uom_class = l_primary_uom_class
219: AND primary_uom_code = l_primary_uom_code
220: AND uom_class = l_from_uom_class
221: AND uom_code = p_from_uom_code

Line 227: FROM mtl_uom_conversions_view

223: AND inventory_item_id = p_inventory_item_id;
224:
225: SELECT NVL(conversion_rate,0) * NVL(l_converted_price,0)
226: INTO l_converted_price
227: FROM mtl_uom_conversions_view
228: WHERE primary_uom_class = l_primary_uom_class
229: AND primary_uom_code = l_primary_uom_code
230: AND uom_class = l_to_uom_class
231: AND uom_code = p_to_uom_code

Line 242: FROM mtl_uom_conversions_view

238: p_var_name => l_debug_info,
239: p_var_value => l_converted_price);
240: ELSE
241: SELECT (SELECT (conversion_rate * p_unit_price) as conversion_rate
242: FROM mtl_uom_conversions_view
243: WHERE primary_uom_class = l_from_uom_class
244: AND primary_uom_code = p_from_uom_code
245: AND uom_class = l_to_uom_class
246: AND uom_code = p_to_uom_code

Line 251: FROM mtl_uom_conversions_view

247: AND organization_id = p_organization_id
248: AND inventory_item_id = p_inventory_item_id
249: UNION
250: SELECT (1/conversion_rate * p_unit_price) as conversion_rate
251: FROM mtl_uom_conversions_view
252: WHERE primary_uom_class = l_to_uom_class
253: AND primary_uom_code = p_to_uom_code
254: AND uom_class = l_from_uom_class
255: AND uom_code = p_from_uom_code

Line 385: FROM mtl_uom_conversions_view

381: p_var_value => l_allocation_uom_class);
382:
383: SELECT NVL(conversion_rate,0) * NVL(p_qty,0)
384: INTO l_primary_qty
385: FROM mtl_uom_conversions_view
386: WHERE primary_uom_class = l_primary_uom_class
387: AND primary_uom_code = l_primary_uom_code
388: AND uom_class = l_allocation_uom_class
389: AND uom_code = p_from_uom_code

Line 412: FROM mtl_uom_conversions_view

408: p_var_value => l_to_allocation_uom_class);
409:
410: SELECT 1/NVL(conversion_rate,0) * NVL(l_primary_qty,0)
411: INTO l_converted_qty
412: FROM mtl_uom_conversions_view
413: WHERE primary_uom_class = l_primary_uom_class
414: AND primary_uom_code = l_primary_uom_code
415: AND uom_class = l_to_allocation_uom_class
416: AND uom_code = p_to_uom_code