APPS.INL_LANDEDCOST_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 204: FROM mtl_units_of_measure uom,

200: msi.concatenated_segments
201: INTO l_primary_uom_code,
202: l_primary_uom_class,
203: l_concatenated_segments
204: FROM mtl_units_of_measure uom,
205: mtl_system_items_vl msi
206: WHERE uom.uom_code = msi.primary_uom_code
207: AND msi.organization_id = p_organization_id
208: AND msi.inventory_item_id = p_inventory_item_id;

Line 231: FROM mtl_units_of_measure

227: p_var_value => l_concatenated_segments);
228:
229: SELECT uom_class
230: INTO l_from_uom_class
231: FROM mtl_units_of_measure
232: WHERE uom_code = p_from_uom_code;
233:
234: l_debug_info := 'l_from_uom_class';
235: INL_LOGGING_PVT.Log_Variable (

Line 242: FROM mtl_units_of_measure

238: p_var_name => l_debug_info,
239: p_var_value => l_from_uom_class);
240: SELECT uom_class
241: INTO l_to_uom_class
242: FROM mtl_units_of_measure
243: WHERE uom_code = p_to_uom_code;
244:
245: l_debug_info := 'l_to_uom_class';
246: INL_LOGGING_PVT.Log_Variable (

Line 319: FROM mtl_units_of_measure

315: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
316: BEGIN
317: SELECT unit_of_measure_tl
318: INTO l_debug_info
319: FROM mtl_units_of_measure
320: WHERE uom_code = p_from_uom_code;
321: l_debug_info := p_from_uom_code||'-'||l_debug_info;
322: EXCEPTION
323: WHEN OTHERS THEN

Line 330: FROM mtl_units_of_measure

326: FND_MESSAGE.SET_TOKEN('FROM_UOM_CODE',l_debug_info);
327: BEGIN
328: SELECT unit_of_measure_tl
329: INTO l_debug_info
330: FROM mtl_units_of_measure
331: WHERE uom_code = p_to_uom_code;
332: l_debug_info := p_to_uom_code||'-'||l_debug_info;
333: EXCEPTION
334: WHEN OTHERS THEN

Line 434: FROM mtl_units_of_measure uom,

430: INTO
431: l_primary_uom_code,
432: l_primary_uom_class,
433: l_concatenated_segments
434: FROM mtl_units_of_measure uom,
435: mtl_system_items_vl msi
436: WHERE uom.uom_code = msi.primary_uom_code
437: AND msi.organization_id = p_organization_id
438: AND msi.inventory_item_id = p_inventory_item_id;

Line 458: FROM mtl_units_of_measure

454: );
455:
456: SELECT uom_class
457: INTO l_allocation_uom_class
458: FROM mtl_units_of_measure
459: WHERE uom_code = p_from_uom_code;
460:
461: l_debug_info := 'l_allocation_uom_class';
462: INL_LOGGING_PVT.Log_Variable (

Line 502: FROM mtl_units_of_measure

498: );
499:
500: SELECT uom_class
501: INTO l_to_allocation_uom_class
502: FROM mtl_units_of_measure
503: WHERE uom_code = P_to_uom_code;
504:
505: l_debug_info := 'l_to_allocation_uom_class';
506: INL_LOGGING_PVT.Log_Variable (

Line 569: FROM mtl_units_of_measure

565:
566: BEGIN
567: SELECT unit_of_measure_tl
568: INTO l_debug_info
569: FROM mtl_units_of_measure
570: WHERE uom_code = p_from_uom_code;
571: l_debug_info := p_from_uom_code||'-'||l_debug_info;
572: EXCEPTION
573: WHEN OTHERS THEN

Line 580: FROM mtl_units_of_measure

576: FND_MESSAGE.SET_TOKEN('FROM_UOM_CODE',l_debug_info);
577: BEGIN
578: SELECT unit_of_measure_tl
579: INTO l_debug_info
580: FROM mtl_units_of_measure
581: WHERE uom_code = p_to_uom_code;
582: l_debug_info := p_to_uom_code||'-'||l_debug_info;
583: EXCEPTION
584: WHEN OTHERS THEN

Line 603: FROM mtl_units_of_measure

599:
600: BEGIN
601: SELECT unit_of_measure_tl
602: INTO l_debug_info
603: FROM mtl_units_of_measure
604: WHERE uom_code = p_from_uom_code;
605: l_debug_info := p_from_uom_code||'-'||l_debug_info;
606: EXCEPTION
607: WHEN OTHERS THEN

Line 614: FROM mtl_units_of_measure

610: FND_MESSAGE.SET_TOKEN('FROM_UOM_CODE',l_debug_info);
611: BEGIN
612: SELECT unit_of_measure_tl
613: INTO l_debug_info
614: FROM mtl_units_of_measure
615: WHERE uom_code = p_to_uom_code;
616: l_debug_info := p_to_uom_code||'-'||l_debug_info;
617: EXCEPTION
618: WHEN OTHERS THEN