APPS.BOM_RTG_EXP_UTIL SQL Statements

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

Line: 26

  SELECT concatenated_segments
  INTO   l_item_name
  FROM   mtl_system_items_kfv
  WHERE  inventory_item_id = P_inventory_item_id
  AND    rownum = 1;

Line: 40

  SELECT inventory_item_id
  INTO   l_item_id
  FROM   mtl_system_items_kfv
  WHERE  concatenated_segments = P_item_name
  AND    rownum = 1;