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 536: FROM mtl_system_items

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

Line 651: FROM mtl_system_items

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