AND ((UCSII.REC_STATUS = 'A' AND UCSII.UCSIIU_RECEIPT_AT_MOT_DT between to_date(?,'mm/dd/yyyy') and to_date(?,'mm/dd/yyyy') ) -- <1.start date, 2.end date> OR (UCSII.UCSIIU_RECEIPT_AT_MOT_DT between to_date(?,'mm/dd/yyyy') and to_date(?,'mm/dd/yyyy') -- <3.start date, 4.end date> AND UCSII.REC_STATUS = 'I' AND UCSII.UCSIIU_CIF_SENT_TO_ITA_CNT > 0))