SELECT TO_CHAR(AIP.INVOICE_PAYMENT_ID)||'-'||TO_CHAR(AIP.ORG_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE , 1 , 40) , AIP.LAST_UPDATE_DATE FROM AP_INVOICE_PAYMENTS_ALL AIP , AP_CHECKS_ALL AC , AP_INVOICES_ALL AI WHERE AIP.INVOICE_ID = AI.INVOICE_ID AND AIP.ORG_ID = AI.ORG_ID AND AIP.CHECK_ID = AC.CHECK_ID AND AIP.ORG_ID = AC.ORG_ID AND AC.STATUS_LOOKUP_CODE NOT IN ('OVERFLOW' , 'SET UP' , 'SPOILED' , 'UNCONFIRMED SET UP' , 'VOIDED')