635: > SYSDATE
636: AND ROWNUM = 1
637: UNION
638: SELECT -9999
639: FROM DUAL
640: WHERE PVC.VENDOR_CONTACT_ID IS NULL)
641:
642: ORDER BY PV.VENDOR_NAME,
643: PVS.VENDOR_SITE_CODE