The OrderItemsView view object now contains attributes from both the OrderItems entity object and the ProductsBase entity object. Notice that OrderItemsView contains two ProductId attributes: ProductId from the OrderItems entity object and ProductId1 from the ProductsBase entity object; this is necessary to specify the join between the two entity objects.
You can see the query that the view object executes to fetch the data by selecting the Query tab in the overview editor.
Copyright © 1997, 2009, Oracle. All rights reserved.