One time supplier query in oracle apps

select * from ap_suppliers where ONE_TIME_FLAG = 'Y' and VENDOR_TYPE_LOOKUP_CODE != 'Employee' and END_DATE_ACTIVE is null