SELECT *
  FROM eft_txn_details t1
 WHERE ( (t1.a_date >= '16-Mar-2018' AND t1.a_date <= '31-Mar-2018')
        OR (t1.r_date >= '16-Mar-2018' AND t1.r_date <= '31-Mar-2018'))
       AND t1.a_m = 'NO'
       AND ( (    t1.s_r IN ('EB', 'PH', 'PT', 'SW')
              AND t1.d_m IN ('DM', 'SW')
              AND t1.c_m = 'SW')
            OR (t1.s_r IN ('PH', 'PT') AND t1.d_m = 'SW' AND t1.c_m = 'DM')
            OR (    (t1.s_r = 'EB' AND t1.d_m = 'SW' AND t1.c_m = 'DM')
                AND (b_s != 'A' AND d_w != 'B')
                AND (b_s != 'B' AND d_w != 'A'))
            OR ( (    t1.s_r = 'SW'
                  AND t1.d_m = 'SW'
                  AND t1.c_m = 'DM'
                  AND t1.d_w NOT IN ('A', 'B'))
                AND o_s != 'A'
                AND r_n != '35RE%'))

SELECT *
  FROM eft_txn_details t1
 WHERE ( (t1.a_date >= '16-Mar-2018' AND t1.a_date <= '31-Mar-2018')
        OR (t1.r_date >= '16-Mar-2018' AND t1.r_date <= '31-Mar-2018'))
       AND t1.a_m = 'NO'
       AND ( (    t1.s_r IN ('EB', 'PH', 'PT', 'SW')
              AND t1.d_m IN ('DM', 'SW')
              AND t1.c_m = 'SW')
            OR (t1.s_r IN ('PH', 'PT') AND t1.d_m = 'SW' AND t1.c_m = 'DM')
            OR (    (t1.s_r = 'EB' AND t1.d_m = 'SW' AND t1.c_m = 'DM')
                AND (b_s != 'A' AND d_w != 'B')
                AND (b_s != 'B' AND d_w != 'A'))
            OR ( (    t1.s_r = 'SW'
                  AND t1.d_m = 'SW'
                  AND t1.c_m = 'DM'
                  AND t1.d_w NOT IN ('A', 'B'))
                AND o_s != 'A'
                AND r_n != '35RE%'))