CREATE VIEW "SBODEMODE"."B1_SnBOpenQtyInnerViewOrder" ( "AllocateTp", "AllocatEnt", "AllocateLn", "AppSubLine", "ManagedBy", "LogEntry", "ItemCode", "SysNumber", "LocCode", "TransId", "OrderedQty" ) AS SELECT T0."AllocateTp", T0."AllocatEnt", T0."AllocateLn", T0."AppSubLine", T0."ManagedBy", T1."LogEntry", T0."ItemCode", T1."SysNumber", T0."LocCode", T0."TransId", T1."OrderedQty" FROM  "SBODEMODE"."OITL" T0  INNER  JOIN "SBODEMODE"."ITL1" T1  ON  T1."LogEntry" = T0."LogEntry"   WHERE T0."AllocateTp" IN(234000031 ) WITH READ ONLY