CREATE VIEW "SBODEMODE"."ixvITL_LastWhs" ( "ItemCode", "SysNumber", "WhsCode" ) AS SELECT		T0."ItemCode", lastLogEntry."SysNumber", T0."LocCode" AS "WhsCode" FROM		"SBODEMODE".OITL  T0 INNER JOIN	(SELECT	MAX("LogEntry") AS "LogEntry", "ItemCode", "SysNumber" FROM "SBODEMODE".ITL1 GROUP BY "ItemCode", "SysNumber") AS lastLogEntry ON lastLogEntry."LogEntry" = T0."LogEntry" AND T0."ItemCode" = lastLogEntry."ItemCode" WITH READ ONLY