select bc.business_case_id AS bc from " +
    "(select * from LH_MTG_CONDITION cond2 where " +
//       "cond2.REAL_DELIVERY_DATE IS NULL " +
    "cond2.DELIVERY_STATE_CODE IN ('1','3','5','6','8') " + //stavy oznacujuce dokument za nepredlozeny              //doklad nepredlozeny
    "AND cond2.REQ_DELIVERY_DATE IS NOT NULL " +
    "AND to_char(cond2.REQ_DELIVERY_DATE, 'YYYY') < '9999') cond, " +
    "LH_MTG_CONDITION_MONITOR mon, LH_BUSINESS_CASE bc " +
    "where cond.TYPE = '3' " +
    "AND (cond.OBJ_STATUS != 3 OR cond.OBJ_STATUS IS NULL) " +
    "AND (bc.CASE_STATE = '9' OR bc.CASE_STATE = '8' OR bc.CASE_STATE is NULL) " +
    "AND (cond.REQ_DELIVERY_DATE) < trunc(sysdate) " +
    "AND bc.BUSINESS_CASE_PK = mon.BUSINESS_CASE_FK(+) " +
    "AND bc.BUSINESS_CASE_PK = cond.BUSINESS_CASE_FK " +
    "AND (mon.REMINDER_NUMBER IS NULL OR mon.REMINDER_NUMBER = 0) " +
    "AND (mon.CASE_CHECK_FLAG IS NULL OR mon.CASE_CHECK_FLAG = '0' ) " +
    "group by bc.BUSINESS_CASE_ID