-- 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
FileBrowser ‹ SQLBlog Nederland — WordPress
