Inventory Style Details by Product

Inventory Style Details by Product

Submitted by Nathan Clouse on 10/06/15.

A view that shows Inventory Style Details by Product with details on the inventory style, if assigned, by product including the name and translated description.

AX Version: 

Module: 

CREATE view [dbo].[vw_pimProductStyles] as
select	'productRecId' = erp.recid,
		translate.languageId,
		ers.name,
		translate.description,
		erp.partition
from EcoResProductMasterDimensionValue value
inner join ecoResProduct erp 
	on erp.recid = value.styleProductMaster
	and value.partition = erp.partition
inner join EcoResStyle ers 
	on ers.recid = value.style
	and ers.partition = value.partition
left join EcoResProductMasterDimValueTranslation translate 
	on translate.productMasterDimensionValue = value.recid
	and translate.partition = value.partition
GO