SELECT *
   FROM DEV.TRANSACTOPMS
      WHERE TRANSACTION_CD IN ('146','147')
      AND AMT < 0
      AND ASOF_DATE = '30-APR-2011'