Active item list Query

SELECT T0.ItemCode

FROM dbo.OITM T0

WHERE T0.ITEMCODE IN (SELECT DISTINCT CODE FROM dbo.ITT1) OR

T0.ITEMCODE IN (SELECT DISTINCT CODE FROM dbo.OITT) OR T0.ITEMCODE

IN (SELECT DISTINCT ITEMCODE FROM dbo.OINM) OR T0.ITEMCODE IN (SELECT

DISTINCT ITEMCODE FROM dbo.ADO1)