infor.allvariations() table function

The infor.allvariations() table function is used in the from clause of a query. The function parameter is the object for which you want to select all variations, including lower variations and variations marked as deleted.

The infor.allvariations() table function requires a parameter. The parameter is the object name, and the object name must be enclosed within single quotes. The infor.allvariations function and the object name are case-insensitive.

Query

select * from infor.allvariations('Products')