I'm trying to create a view with several select and I don't have any error message but it doesn't seem to work properly.

Is there something to do under SQL Server to use views ?

Here is the query for it:
create view V_PARK
AS select distinct a.account as 'ACCOUNT', k.externalnumber as 'KEY',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='AAD') as 'AAD',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='API') as 'API',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='ARC') as 'ARC',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='BDI') as 'BDI',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='BPA') as 'BPA',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='DAT') as 'DAT',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='DER') as 'DER',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='DES') as 'DES',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='DEV') as 'DEV',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='DOC') as 'DOC',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='GEN') as 'GEN',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='INT') as 'INT',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='Lan') as 'Lan',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='PRO') as 'PRO',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='SRV') as 'SRV',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='SUI') as 'SUI',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='SUP') as 'SUP',
(select m2.quantity
from sysdba.c_movement m2 inner join sysdba.product p on m2.productid=p.productid
where m2.c_deliverylineid=m.c_deliverylineid
and p.actualid='WEB') as 'WEB'
from (((sysdba.c_movement m inner join sysdba.c_deliveryline dl on m.c_deliverylineid=dl.c_deliverylineid)
inner join sysdba.c_key k on dl.c_keyid=k.c_keyid)
inner join sysdba.c_delivery d on dl.c_deliveryid=d.c_deliveryid)
inner join sysdba.account a on d.accountid=a.accountid
where dl.inpark='T'