SELECT COUNT(1) FROM OAPP_INVOICE_TRX WHERE AP_INVOICE_STATUS<>'V' AND FLAG_DELETED='N' AND ( TRIM(UPPER(INV_NO_SUPPLIER))= TRIM(UPPER(:B4 )) OR AP_INVOICE_NO=:B3 ) AND BOOK_CODE=:B2 AND AP_INVOICE_DATE BETWEEN '01-JAN-'||TO_CHAR(TO_DATE(:B1 ),'YYYY') AND '31-DEC-'||TO_CHAR(TO_DATE(:B1 ),'YYYY')