SELECT *
   FROM $schema.TRANSACTOPMS
      WHERE TRANSACTION_CD IN ('146','147')
      AND AMT < 0
      AND ASOF_DATE = '$test_date'