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