SELECT NAME TERMS , DESCRIPTION DESCRIPTION , TERM_ID FROM AP_TERMS WHERE TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
View Text - HTML Formatted
SELECT NAME TERMS , DESCRIPTION DESCRIPTION , TERM_ID FROM AP_TERMS WHERE TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE , SYSDATE - 1) AND NVL(END_DATE_ACTIVE , SYSDATE + 1)