Inventory Configurations Details by Product

Inventory Configurations Details by Product

Submitted by Nathan Clouse on 10/05/15.

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

AX Version: 

Module: 

CREATE view [dbo].[vw_pimProductConfigs] as
select 'productRecId' = erp.recid,
		translate.languageId,
		erc.name,
		translate.description,
		erp.partition
from EcoResProductMasterDimensionValue value
inner join ecoResProduct erp 
	on erp.recid = value.configProductMaster 
	and value.partition = erp.partition
inner join EcoResConfiguration erc 
	on erc.recid = value.color 
	and erc.partition = value.partition
left join EcoResProductMasterDimValueTranslation translate 
	on translate.productMasterDimensionValue = value.recid 
	and translate.partition = value.partition
GO