List of Matrix Items linked to Template Item

Hi @manikantad18 I have created a simple SQL View and then created a GI for the same.

I have tested it and seems working well. Please import the below GI into your instance and verify.

drop view IF EXISTS NBTemplateItemsWithoutMatrix
GO
create view NBTemplateItemsWithoutMatrix
as
Select CompanyID,  InventoryID, InventoryCD, Descr from Inventoryitem where CompanyID=2 and istemplate=1 and InventoryID not in( Select TemplateItemID from InventoryItem Where CompanyID=2 and TemplateItemID is not null)

Hope this helps!!