Next value for Sequence Function
As per the documentation states:


  The NEXT VALUE FOR function is nondeterministic, and is only allowed in contexts where the number of generated sequence values is well defined. Below is the definition of how many values will be used for each referenced sequence object in a given statement:
  
  SELECT - For each referenced sequence object, a new value is generated once per row in the result of the statement.