infor.allvariationsincludearchived() table function
The
infor.allvariationsincludearchived() 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 or archived.The infor.allvariationsincludearchived() table function requires a
parameter. The parameter is the object name, and the object name must be enclosed within
single quotes. The infor.allvariationsincludearchived function and the object
name are case-insensitive.
Query
select * from infor.allvariationsincludearchived('Products'