select payments for reclassified assets

SELECT
astpay.CPTLAST_NBR,
astpay.AST_DEPR1_BASE_AMT,
astpay.AST_ACUM_DEPR1_AMT
FROM
cm_ast_payment_t astpay
inner join CM_AST_PAYMENT_EXT_T payext ON
astpay.CPTLAST_NBR = payext.CPTLAST_NBR
AND
astpay.AST_PMT_SEQ_NBR = payext.AST_PMT_SEQ_NBR
AND
payext.AST_RECLASS_IND = 'Y'
ORDER BY
astpay.CPTLAST_NBR DESC