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 835 847
01G 640 686
02D 775 856
02G 652 821
03D 907 932
03G 600 802
04D 850 919
04G 806 933
05D 761 926
05G 775 923
06D 806 913
06G 727 924
07D 823 919
07G 690 784
08D 598 785
08G 544 743
09D 598 789
09G 508 691
10D 564 758
10G 509 697
11D 706 837
11G 582 787
12D 352 566
12G 604 759
13D 348 583
13G 285 514