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'