Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- astpay.CPTLAST_NBR,
- astpay.AST_DEPR1_BASE_AMT,
- AST_PRD1_DEPR1_AMT,
- AST_PRD2_DEPR1_AMT,
- AST_PRD3_DEPR1_AMT,
- AST_PRD4_DEPR1_AMT,
- AST_PRD5_DEPR1_AMT,
- AST_PRD6_DEPR1_AMT,
- AST_PRD7_DEPR1_AMT,
- AST_PRD8_DEPR1_AMT,
- AST_PRD9_DEPR1_AMT,
- AST_PRD10DEPR1_AMT,
- AST_PRD11DEPR1_AMT,
- AST_PRD12DEPR1_AMT
- FROM
- cm_ast_payment_t astpay
- WHERE
- astpay.AST_DEPR1_BASE_AMT < 0
- AND
- (
- AST_PRD1_DEPR1_AMT > 0
- OR
- AST_PRD2_DEPR1_AMT > 0
- OR
- AST_PRD3_DEPR1_AMT > 0
- OR
- AST_PRD4_DEPR1_AMT > 0
- OR
- AST_PRD5_DEPR1_AMT > 0
- OR
- AST_PRD6_DEPR1_AMT > 0
- OR
- AST_PRD7_DEPR1_AMT > 0
- OR
- AST_PRD8_DEPR1_AMT > 0
- OR
- AST_PRD9_DEPR1_AMT > 0
- OR
- AST_PRD10DEPR1_AMT > 0
- OR
- AST_PRD11DEPR1_AMT > 0
- OR
- AST_PRD12DEPR1_AMT > 0
- )
- ORDER BY
- astpay.CPTLAST_NBR ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement