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 to select all variations,
including lower variations and variations marked as deleted. Archived records and their
variations are not returned by this function.
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')