SELECT 
		T0."UserSign", T0."CreateDate", T0."IntrSerial", T0."ItemCode", T3."Code", T0."BaseType", T0."BaseEntry", T0."BaseLinNum"
	FROM
		OSRI T0
	INNER JOIN
		OITM T1 ON T0."ItemCode" = T1."ItemCode"
	INNER JOIN
		OWHS T2 ON T0."WhsCode" = T2."WhsCode"
	INNER JOIN
		PMX_OSWH T3 ON T2."WhsCode" = T3."SboWhsCode"
	WHERE
		T0."Status" <> 1 
		AND T1."ManSerNum" = 'Y'
		AND T1."MngMethod" = 'A'
		AND T2."U_PMX_IMBP"='Y'
		AND NOT EXISTS (SELECT 1 FROM PMX_SENU S0 WHERE S0."ItemCode" = T0."ItemCode" AND S0."SerialNumber" = T0."IntrSerial")