Torna al Thread
select DISTINCT P.AUFNR as BATCH_ORDER,
B.MATNR as AQST,
SUBSTRING (P.ZSDMODCODE, 4, 1) as BATCH_GROUP,
SUBSTRING (P.ZSDMODCODE, 11, 1) as ROTATION,
P.MATNR as SAUER_CODE,
B.POSNR as ID_BOM,
B2.POSNR as ID2_BOM,
SUBSTRING (B2.MAKTX, 22, 29) as ALTERNATIVE_CODE,
P.GAMNG as QUANTITY,
LEFT (P.ZSDMODCODE,16) as IMMC,
RIGHT (P.ZSDMODCODE,16) as IIMMC,
UPPER (REPLACE (CONVERT (Varchar, GETDATE(), 106), ' ', '/')) as MARKING_DATE
from dbo.PRODORDER as P
INNER JOIN dbo.BOM as B
ON P.AUFNR = B.AUFNR
INNER JOIN dbo.BOM as B2
ON P.AUFNR = B2.AUFNR
where P.AUFNR in (5947133, 5954096, 5959053, 5960458, 5966239) and (B.POSNR = '9999' and B2.POSNR = '9500')