SELECT AC.CHECK_ID , AC.BANK_ACCOUNT_ID , NVL(AC.ACTUAL_VALUE_DATE , NVL(AC.ANTICIPATED_VALUE_DATE , NVL(AC.FUTURE_PAY_DUE_DATE , AC.CHECK_DATE))) , AC.CHECK_NUMBER , -NVL(NVL(AC.CLEARED_BASE_AMOUNT , AC.CLEARED_AMOUNT) , NVL(AC.BASE_AMOUNT , AC.AMOUNT)) , AC.STATUS_LOOKUP_CODE , AC.PAYMENT_METHOD_LOOKUP_CODE FROM AP_CHECKS_ALL AC WHERE AC.STATUS_LOOKUP_CODE IN ('NEGOTIABLE' , 'CLEARED' , 'CLEARED BUT UNACCOUNTED' , 'RECONCILED' , 'RECONCILED UNACCOUNTED') AND AC.VENDOR_SITE_ID IS NOT NULL UNION ALL SELECT AC.CHECK_ID , AC.BANK_ACCOUNT_ID , NVL(AC.ACTUAL_VALUE_DATE , NVL(AC.ANTICIPATED_VALUE_DATE , NVL(AC.FUTURE_PAY_DUE_DATE , AC.CHECK_DATE))) , AC.CHECK_NUMBER , -NVL(NVL(AC.CLEARED_BASE_AMOUNT , AC.CLEARED_AMOUNT) , NVL(AC.BASE_AMOUNT , AC.AMOUNT)) , AC.STATUS_LOOKUP_CODE , AC.PAYMENT_METHOD_LOOKUP_CODE FROM AP_CHECKS_ALL AC WHERE AC.FUTURE_PAY_DUE_DATE IS NOT NULL AND AC.STATUS_LOOKUP_CODE = 'ISSUED' AND AC.VENDOR_SITE_ID IS NOT NULL