Allegra Term / Sold Herds As of: 2019.08.08 22:35 Reported Termination Date - when termination was done COUNT(1) PR TDATE Status --------- -- ------------ ----------- 2 02 01-JUL-19 Sold 1 03 01-JUL-19 Sold 10 04 01-JUL-19 Sold 10 05 01-JUL-19 Sold COUNT(1) PR TDATE Status --------- -- ------------ ----------- 2 03 01-JUL-19 Term 15 04 01-JUL-19 Term 6 05 01-JUL-19 Term 4 08 01-JUL-19 Term group by hrd.prv_cd, * ERROR at line 15: ORA-01787: only one clause allowed per query block