how to get the Inventory dimension combination ItemCategory in D365F&O

InventDimCombination    inventDimCombinationLoc;

InventDim               inventDimLoc,inventDimCombLoc;

select inventDimLoc where inventDimLoc.inventDimId == prodTable.InventDimId;

select inventDimCombinationLoc join inventDimCombLoc

where inventDimCombinationLoc.ItemId == prodTable.ItemId

&&    inventDimCombinationLoc.InventDimId == inventDimCombLoc.inventDimId

&&    inventDimCombLoc.InventColorId      == inventDimLoc.InventColorId

&&    inventDimCombLoc.InventSizeId       == inventDimLoc.InventSizeId

&&    inventDimCombLoc.InventStyleId      == inventDimLoc.InventStyleId

&&    inventDimCombLoc.configId           == inventDimLoc.configId;