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