DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 169: FROM mtl_units_of_measure uom,

165: msi.concatenated_segments
166: INTO l_primary_uom_code,
167: l_primary_uom_class,
168: l_concatenated_segments
169: FROM mtl_units_of_measure uom,
170: mtl_system_items_vl msi
171: WHERE uom.uom_code = msi.primary_uom_code
172: AND msi.organization_id = p_organization_id
173: AND msi.inventory_item_id = p_inventory_item_id;

Line 193: FROM mtl_units_of_measure

189: p_var_value => l_concatenated_segments);
190:
191: SELECT uom_class
192: INTO l_from_uom_class
193: FROM mtl_units_of_measure
194: WHERE uom_code = p_from_uom_code;
195:
196: l_debug_info := 'l_from_uom_class';
197: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 203: FROM mtl_units_of_measure

199: p_var_name => l_debug_info,
200: p_var_value => l_from_uom_class);
201: SELECT uom_class
202: INTO l_to_uom_class
203: FROM mtl_units_of_measure
204: WHERE uom_code = p_to_uom_code;
205:
206: l_debug_info := 'l_to_uom_class';
207: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 354: FROM mtl_units_of_measure uom,

350: msi.concatenated_segments
351: INTO l_primary_uom_code,
352: l_primary_uom_class,
353: l_concatenated_segments
354: FROM mtl_units_of_measure uom,
355: mtl_system_items_vl msi
356: WHERE uom.uom_code = msi.primary_uom_code
357: AND msi.organization_id = p_organization_id
358: AND msi.inventory_item_id = p_inventory_item_id;

Line 374: FROM mtl_units_of_measure

370: p_var_value => l_primary_uom_class);
371:
372: SELECT uom_class
373: INTO l_allocation_uom_class
374: FROM mtl_units_of_measure
375: WHERE uom_code = p_from_uom_code;
376:
377: l_debug_info := 'l_allocation_uom_class';
378: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 401: FROM mtl_units_of_measure

397: p_var_value => TO_CHAR(l_primary_qty));
398:
399: SELECT uom_class
400: INTO l_to_allocation_uom_class
401: FROM mtl_units_of_measure
402: WHERE uom_code = P_to_uom_code;
403:
404: l_debug_info := 'l_to_allocation_uom_class';
405: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,