CREATE OR REPLACE FORCE VIEW "SUPERMAG"."SVGRANTEDLOCALSHOPS" ("ID", "NAME", "IDCLASS", "ACCEPTED", "PRTY", "FLAGS", "LOCTYPE", "PARENTLOC", "RGNID", "ADDRESS", "TEL", "FAX", "COMMENTARY", "ORDERALG", "CARDTYPE", "FORMATID", "PRICINGMETHOD", "SUGGESTORDERALG", "FLOORSPACE", "GLN", "SHORTNAME", "SPOILAGELOC", "CLOSEDEDITDATE", "KPP")
AS
select LS."ID",LS."NAME",LS."IDCLASS",LS."ACCEPTED",LS."PRTY",LS."FLAGS",LS."LOCTYPE",LS."PARENTLOC",LS."RGNID",LS."ADDRESS",LS."TEL",LS."FAX",LS."COMMENTARY",LS."ORDERALG",
LS."CARDTYPE",LS."FORMATID",LS."PRICINGMETHOD",LS."SUGGESTORDERALG",LS."FLOORSPACE",LS."GLN",LS."SHORTNAME",LS."SPOILAGELOC",LS."CLOSEDEDITDATE",LS."KPP" from
SVLocalShops LS, SVGrantedLocs L where LS.ID=L.ID;