IF object_id('tempdb..#itemtype_temporary') IS NOT NULL
BEGIN
DROP TABLE #itemtype_temporary
END
CREATE TABLE #itemtype_temporary
(
itemtype NVARCHAR (30)
)
DECLARE @part_no NVARCHAR(30)
DECLARE @sql NVARCHAR(300)
DECLARE @itemtype NVARCHAR(30)
SET @part_no='9H.A0G01.8TE'
SET @sql='INSERT INTO #itemtype_temporary (itemtype) SELECT * FROM OPENQUERY(EBS12D,''SELECT ITEMTYPE FROM APPS.XXIN_GSN_SN_FLAG_v WHERE ITEMNO='''''+@part_no+''''''')';
EXEC sp_executesql @sql
SELECT @itemtype=itemtype FROM #itemtype_temporary
DROP TABLE #itemtype_temporary
PRINT @itemtype