APPS.INV_DECIMALS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 332

     SELECT primary_uom_code, serial_number_control_code, NVL(indivisible_flag,'N')
     INTO l_primary_uom, l_serial_control, l_indivisible_flag
     FROM mtl_system_items
     WHERE inventory_item_id = p_item_id
     AND organization_id = p_organization_id ;

Line: 534

     SELECT primary_uom_code, serial_number_control_code, NVL(indivisible_flag,'N')
     INTO l_primary_uom, l_serial_control, l_indivisible_flag
     FROM mtl_system_items
     WHERE inventory_item_id = p_item_id
     AND organization_id = p_organization_id ;

Line: 649

     SELECT primary_uom_code
     INTO l_primary_uom
     FROM mtl_system_items
     WHERE inventory_item_id = p_inventory_item_id
     AND organization_id = p_organization_id ;