SELECT pov.vendor_id,pov.vendor_name, pov.segment1 from po_vendors pov where pov.enabled_flag = 'Y' and sysdate between nvl(pov.start_date_active, sysdate-1) and nvl(pov.end_date_active, sysdate+1)
View Text - HTML Formatted
SELECT POV.VENDOR_ID , POV.VENDOR_NAME , POV.SEGMENT1 FROM PO_VENDORS POV WHERE POV.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(POV.START_DATE_ACTIVE , SYSDATE-1) AND NVL(POV.END_DATE_ACTIVE , SYSDATE+1)