SELECT distinct vendor_name supplier_name, vendor_id supplier_id from po_vendors where nvl( vendor_type_lookup_code,'VENDOR') <> 'EMPLOYEE' and nvl(end_date_active, sysdate+1) > sysdate order by vendor_name
View Text - HTML Formatted
SELECT DISTINCT VENDOR_NAME SUPPLIER_NAME , VENDOR_ID SUPPLIER_ID FROM PO_VENDORS WHERE NVL( VENDOR_TYPE_LOOKUP_CODE , 'VENDOR') <> 'EMPLOYEE' AND NVL(END_DATE_ACTIVE , SYSDATE+1) > SYSDATE ORDER BY VENDOR_NAME