APPS.GMIVLDX SQL Statements

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

Line: 214

  SELECT COUNT(1)
  INTO   l_count
  FROM   mtl_transaction_lot_numbers
  WHERE  inventory_item_id <> p_odm_item_id
  AND    lot_number = p_odm_lot_number
  AND    ROWNUM = 1;

Line: 227

  SELECT COUNT(1)
  INTO   l_count
  FROM   mtl_transaction_lots_temp lot, mtl_material_transactions_temp mtl
  WHERE  mtl.inventory_item_id <> p_odm_item_id
  AND    lot.lot_number = p_odm_lot_number
  AND    mtl.transaction_temp_id = lot.transaction_temp_id
  AND    ROWNUM = 1;

Line: 241

  SELECT COUNT(1)
  INTO   l_count
  FROM   mtl_material_transactions_temp mtl
  WHERE  mtl.inventory_item_id <> p_odm_item_id
  AND    mtl.lot_number = p_odm_lot_number
  AND    ROWNUM = 1;