SELECT * FROM ASS_MASTER WHERE( AMORTIZED_AMT < AMORT_AMT OR AMORTIZED_MONTH < AMORT_MONTH) AND AMORT_STATUS NOT IN ('CKH','DKH','DTL','KKH','VNM')