-- Generated views based on schema DS_TEST.dbo (11003) - 19-10-2010 15:34 -- Powered by Quipu - Open source datawarehouse management -- Repository version: 1.0.3.383 -- http://www.datawarehousemanagement.org USE AdventureWorks_dv GO --View of HUB BillOfMaterials_h CREATE VIEW src_BillOfMaterials_h_actual AS SELECT h.BillOfMaterials_hid , h.BillOfMaterialsID , t11260.BOMLevel , t11260.EndDate , t11260.ModifiedDate , t11260.PerAssemblyQty , t11260.StartDate , t11260.UnitMeasureCode , l11256.Product_hid , l11258.Product_hid FROM BillOfMaterials_h h LEFT JOIN BillOfMaterials_h_s t11260 ON h.BillOfMaterials_hid = t11260.BillOfMaterials_hid AND t11260.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_h_s WHERE h.BillOfMaterials_hid = BillOfMaterials_hid) LEFT JOIN BillOfMaterials_Product_Component_l l11256 ON h.BillOfMaterials_hid = l11256.BillOfMaterials_mid LEFT JOIN BillOfMaterials_Product_Component_l_s ls11257 ON l11256.BillOfMaterials_Product_Component_lid = ls11257.BillOfMaterials_Product_Component_lid AND ls11257.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_Product_Component_l_s WHERE l11256.BillOfMaterials_Product_Component_lid = BillOfMaterials_Product_Component_lid) LEFT JOIN Product_h f11243_1 ON f11243_1.Product_hid = l11256.Product_hid LEFT JOIN BillOfMaterials_Product_ProductAssembly_l l11258 ON h.BillOfMaterials_hid = l11258.BillOfMaterials_mid LEFT JOIN BillOfMaterials_Product_ProductAssembly_l_s ls11259 ON l11258.BillOfMaterials_Product_ProductAssembly_lid = ls11259.BillOfMaterials_Product_ProductAssembly_lid AND ls11259.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_Product_ProductAssembly_l_s WHERE l11258.BillOfMaterials_Product_ProductAssembly_lid = BillOfMaterials_Product_ProductAssembly_lid) LEFT JOIN Product_h f11243_2 ON f11243_2.Product_hid = l11258.Product_hid WHERE t11260.voided = 0 AND ls11257.voided = 0 AND ls11259.voided = 0 GO --View of HUB Product_h CREATE VIEW src_Product_h_actual AS SELECT h.Product_hid , h.ProductID , t11255.Class , t11255.Color , t11255.DaysToManufacture , t11255.DiscontinuedDate , t11255.FinishedGoodsFlag , t11255.ListPrice , t11255.MakeFlag , t11255.ModifiedDate , t11255.Name , t11255.ProductLine , t11255.ProductNumber , t11255.ReorderPoint , t11255.rowguid , t11255.SafetyStockLevel , t11255.SellEndDate , t11255.SellStartDate , t11255."Size" , t11255.SizeUnitMeasureCode , t11255.StandardCost , t11255.Style , t11255.Weight , t11255.WeightUnitMeasureCode , l11251.ProductModel_hid , l11253.ProductSubcategory_hid FROM Product_h h LEFT JOIN Product_h_s t11255 ON h.Product_hid = t11255.Product_hid AND t11255.load_date = (SELECT MAX(load_date) FROM Product_h_s WHERE h.Product_hid = Product_hid) LEFT JOIN Product_ProductModel_l l11251 ON h.Product_hid = l11251.Product_mid LEFT JOIN Product_ProductModel_l_s ls11252 ON l11251.Product_ProductModel_lid = ls11252.Product_ProductModel_lid AND ls11252.load_date = (SELECT MAX(load_date) FROM Product_ProductModel_l_s WHERE l11251.Product_ProductModel_lid = Product_ProductModel_lid) LEFT JOIN ProductModel_h f11241_1 ON f11241_1.ProductModel_hid = l11251.ProductModel_hid LEFT JOIN Product_ProductSubcategory_l l11253 ON h.Product_hid = l11253.Product_mid LEFT JOIN Product_ProductSubcategory_l_s ls11254 ON l11253.Product_ProductSubcategory_lid = ls11254.Product_ProductSubcategory_lid AND ls11254.load_date = (SELECT MAX(load_date) FROM Product_ProductSubcategory_l_s WHERE l11253.Product_ProductSubcategory_lid = Product_ProductSubcategory_lid) LEFT JOIN ProductSubcategory_h f11242_2 ON f11242_2.ProductSubcategory_hid = l11253.ProductSubcategory_hid WHERE t11255.voided = 0 AND ls11252.voided = 0 AND ls11254.voided = 0 GO --View of HUB ProductCategory_h CREATE VIEW src_ProductCategory_h_actual AS SELECT h.ProductCategory_hid , h.ProductCategoryID , t11246.ModifiedDate , t11246.Name , t11246.rowguid FROM ProductCategory_h h LEFT JOIN ProductCategory_h_s t11246 ON h.ProductCategory_hid = t11246.ProductCategory_hid AND t11246.load_date = (SELECT MAX(load_date) FROM ProductCategory_h_s WHERE h.ProductCategory_hid = ProductCategory_hid) WHERE t11246.voided = 0 GO --View of HUB ProductModel_h CREATE VIEW src_ProductModel_h_actual AS SELECT h.ProductModel_hid , h.ProductModelID , t11247.CatalogDescription , t11247.Instructions , t11247.ModifiedDate , t11247.Name , t11247.rowguid FROM ProductModel_h h LEFT JOIN ProductModel_h_s t11247 ON h.ProductModel_hid = t11247.ProductModel_hid AND t11247.load_date = (SELECT MAX(load_date) FROM ProductModel_h_s WHERE h.ProductModel_hid = ProductModel_hid) WHERE t11247.voided = 0 GO --View of HUB ProductReview_h CREATE VIEW src_ProductReview_h_actual AS SELECT h.ProductReview_hid , h.ProductReviewID , t11263.Comments , t11263.EmailAddress , t11263.ModifiedDate , t11263.Rating , t11263.ReviewDate , t11263.ReviewerName , l11261.Product_hid FROM ProductReview_h h LEFT JOIN ProductReview_h_s t11263 ON h.ProductReview_hid = t11263.ProductReview_hid AND t11263.load_date = (SELECT MAX(load_date) FROM ProductReview_h_s WHERE h.ProductReview_hid = ProductReview_hid) LEFT JOIN Product_ProductReview_l l11261 ON h.ProductReview_hid = l11261.ProductReview_mid LEFT JOIN Product_ProductReview_l_s ls11262 ON l11261.Product_ProductReview_lid = ls11262.Product_ProductReview_lid AND ls11262.load_date = (SELECT MAX(load_date) FROM Product_ProductReview_l_s WHERE l11261.Product_ProductReview_lid = Product_ProductReview_lid) LEFT JOIN Product_h f11243_1 ON f11243_1.Product_hid = l11261.Product_hid WHERE t11263.voided = 0 AND ls11262.voided = 0 GO --View of HUB ProductSubcategory_h CREATE VIEW src_ProductSubcategory_h_actual AS SELECT h.ProductSubcategory_hid , h.ProductSubcategoryID , t11250.ModifiedDate , t11250.Name , t11250.rowguid , l11248.ProductCategory_hid FROM ProductSubcategory_h h LEFT JOIN ProductSubcategory_h_s t11250 ON h.ProductSubcategory_hid = t11250.ProductSubcategory_hid AND t11250.load_date = (SELECT MAX(load_date) FROM ProductSubcategory_h_s WHERE h.ProductSubcategory_hid = ProductSubcategory_hid) LEFT JOIN ProductCategory_ProductSubcategory_l l11248 ON h.ProductSubcategory_hid = l11248.ProductSubcategory_mid LEFT JOIN ProductCategory_ProductSubcategory_l_s ls11249 ON l11248.ProductCategory_ProductSubcategory_lid = ls11249.ProductCategory_ProductSubcategory_lid AND ls11249.load_date = (SELECT MAX(load_date) FROM ProductCategory_ProductSubcategory_l_s WHERE l11248.ProductCategory_ProductSubcategory_lid = ProductCategory_ProductSubcategory_lid) LEFT JOIN ProductCategory_h f11240_1 ON f11240_1.ProductCategory_hid = l11248.ProductCategory_hid WHERE t11250.voided = 0 AND ls11249.voided = 0 GO
One or more plugins have been activated or deactivated, please .