Untitled

avatar
unknown
plain_text
2 years ago
425 B
2
Indexable
SELECT COUNT(DISTINCT(AC.Location_Barcode)) LocationsWithInventory ,
AC.Warehouse, AC.COMPANY, AC.ZONE Zone,
AC.Assignment_Zone AssignmentZone, 
AC.MAX_VOLUME MaxVolume, 
AC.PICK_DETERMINATION_ZONE DETERMINATION_ZONE FROM "TL2"."BI_DATA"."ACTIVE_LOCATION" AC
where AC.WAREHOUSE = 'CRT' 
AND Actual_Inventory > 0
GROUP BY AC.Warehouse,AC.COMPANY, AC.ZONE, AC.Assignment_Zone , AC.MAX_VOLUME , AC.PICK_DETERMINATION_ZONE