APPS.INV_DECIMALS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 334: FROM mtl_system_items

330: -- get the item's primary uom, serial_number_control_code, and the item's indivisible flag
331:
332: SELECT primary_uom_code, serial_number_control_code, NVL(indivisible_flag,'N')
333: INTO l_primary_uom, l_serial_control, l_indivisible_flag
334: FROM mtl_system_items
335: WHERE inventory_item_id = p_item_id
336: AND organization_id = p_organization_id ;
337:
338: -- if the primary uom is same as input uom, then nothing more to validate

Line 533: FROM mtl_system_items

529: -- get the item's primary uom, serial_number_control_code, and the item's indivisible flag
530: IF (p_item_id IS NOT NULL) then
531: SELECT primary_uom_code, serial_number_control_code, NVL(indivisible_flag,'N')
532: INTO l_primary_uom, l_serial_control, l_indivisible_flag
533: FROM mtl_system_items
534: WHERE inventory_item_id = p_item_id
535: AND organization_id = p_organization_id ;
536: END IF;
537:

Line 648: FROM mtl_system_items

644: end if;
645:
646: SELECT primary_uom_code
647: INTO l_primary_uom
648: FROM mtl_system_items
649: WHERE inventory_item_id = p_inventory_item_id
650: AND organization_id = p_organization_id ;
651:
652: return( inv_convert.inv_um_convert(