SELECT EMP_ALV_FILE, SUM(EMP_QTE_COURANTE), SUM(CASE WHEN EMP_TYPE_PALETTE = 99 AND EMP_POS_ALVEOLE <= 1 THEN 1 WHEN EMP_TYPE_PALETTE != 0 AND EMP_TYPE_PALETTE != 99 THEN 1 ELSE 0 END) FROM CLAIREFONTAINE.dbo.EMPLACEMENT WHERE EMP_ALV_STOCK = 'ABRI' AND EMP_DISPO = 1 AND EMP_ANOM = 1 AND EMP_TYPE_PALETTE != 0 AND EMP_ZONE != 0 GROUP BY EMP_ALV_FILE ORDER BY EMP_ALV_FILE

Logo Occupation des alvéoles du magasin Abricot Refresh
Allée Occupées Capacité
01D 840 848
01G 689 711
02D 849 875
02G 821 868
03D 937 943
03G 774 874
04D 937 946
04G 907 949
05D 933 965
05G 908 950
06D 927 951
06G 877 945
07D 918 939
07G 782 812
08D 755 848
08G 672 779
09D 779 862
09G 615 720
10D 750 798
10G 665 790
11D 829 879
11G 733 853
12D 492 623
12G 700 813
13D 511 661
13G 367 586