CREATE VIEW "SBODEMODE"."B1_SnBOpenQtyInnerViewAlloc" ( "AllocateTp", "AllocatEnt", "AllocateLn", "AppSubLine", "ManagedBy", "LogEntry", "ItemCode", "SysNumber", "LocCode", "TransId", "AllocQty" ) AS SELECT T0."AllocateTp", T0."AllocatEnt", T0."AllocateLn", T0."AppSubLine", T0."ManagedBy", T1."LogEntry", T0."ItemCode", T1."SysNumber", T0."LocCode", T0."TransId", T1."AllocQty" FROM  "SBODEMODE"."OITL" T0  INNER  JOIN "SBODEMODE"."ITL1" T1  ON  T1."LogEntry" = T0."LogEntry"   WHERE T0."AllocateTp" IN(13 ,17 ,1250000001 ,202 ,234000032 ) WITH READ ONLY