Inventory Color Details by Product

Inventory Color Details by Product

Submitted by Nathan Clouse on 10/03/15.

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

AX Version: 

Module: 

CREATE view [dbo].[vw_pimProductColors] as

select 'productRecId' = erp.recid,
		translate.languageId,
		erc.name,
		translate.description,
		erp.partition
from EcoResProductMasterDimensionValue value
inner join ecoResProduct erp 
	on erp.recid = value.colorProductMaster 
	and value.partition = erp.partition
inner join ecoResColor 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