Untitled
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