APPS.INL_LANDEDCOST_PVT dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 257: FROM mtl_uom_conversions_view

253: -- first get it converted to the primary
254: IF p_from_uom_code <> l_primary_uom_code THEN
255: SELECT 1/NVL(conversion_rate,0) * NVL(p_unit_price,0)
256: INTO l_converted_price
257: FROM mtl_uom_conversions_view
258: WHERE primary_uom_class = l_primary_uom_class
259: AND primary_uom_code = l_primary_uom_code
260: AND uom_class = l_from_uom_class
261: AND uom_code = p_from_uom_code

Line 267: FROM mtl_uom_conversions_view

263: AND inventory_item_id = p_inventory_item_id;
264:
265: SELECT NVL(conversion_rate,0) * NVL(l_converted_price,0)
266: INTO l_converted_price
267: FROM mtl_uom_conversions_view
268: WHERE primary_uom_class = l_primary_uom_class
269: AND primary_uom_code = l_primary_uom_code
270: AND uom_class = l_to_uom_class
271: AND uom_code = p_to_uom_code

Line 282: FROM mtl_uom_conversions_view

278: p_var_name => l_debug_info,
279: p_var_value => l_converted_price);
280: ELSE
281: SELECT (SELECT (conversion_rate * p_unit_price) as conversion_rate
282: FROM mtl_uom_conversions_view
283: WHERE primary_uom_class = l_from_uom_class
284: AND primary_uom_code = p_from_uom_code
285: AND uom_class = l_to_uom_class
286: AND uom_code = p_to_uom_code

Line 291: FROM mtl_uom_conversions_view

287: AND organization_id = p_organization_id
288: AND inventory_item_id = p_inventory_item_id
289: UNION
290: SELECT (1/conversion_rate * p_unit_price) as conversion_rate
291: FROM mtl_uom_conversions_view
292: WHERE primary_uom_class = l_to_uom_class
293: AND primary_uom_code = p_to_uom_code
294: AND uom_class = l_from_uom_class
295: AND uom_code = p_from_uom_code

Line 473: FROM mtl_uom_conversions_view

469: BEGIN
470:
471: SELECT NVL(conversion_rate,0) * NVL(p_qty,0)
472: INTO l_primary_qty
473: FROM mtl_uom_conversions_view
474: WHERE
475: primary_uom_class = l_primary_uom_class
476: AND primary_uom_code = l_primary_uom_code
477: AND uom_class = l_allocation_uom_class

Line 517: FROM mtl_uom_conversions_view

513: BEGIN
514:
515: SELECT 1/NVL(conversion_rate,0) * NVL(l_primary_qty,0)
516: INTO l_converted_qty
517: FROM mtl_uom_conversions_view
518: WHERE primary_uom_class = l_primary_uom_class
519: AND primary_uom_code = l_primary_uom_code
520: AND uom_class = l_to_allocation_uom_class
521: AND uom_code = p_to_uom_code