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

;
-- tran_code 1753
SELECT *
      FROM $schema.TRAN
      WHERE TRANSACTION_CD IN ('196','197')
      AND ASOF_DATE = '$test_date'
      AND RECORD_VERSION_NBR = '0'
;

-- tran_code 1758
SELECT COUNT(SS_NO), SUM(ABS(SS_PRINCIPAL))     
      FROM $schema.SS_MLA_TRAN
      WHERE INVESTOR_ID = '195'
      AND MAN_CD = '4'
      AND ASOF_DATE = '$test_date'
      AND RECORD_VERSION_NBR = '0'
      and GROUP_ID = 'PCC'
;      

-- tran_code 1765
      ... and so on, you get the idea
;      
#==================================================#