SELECT NAME PAYMENT_TERM , DESCRIPTION , TERM_ID PAYMENT_TERM_ID FROM RA_TERMS WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE)
View Text - HTML Formatted
SELECT NAME PAYMENT_TERM , DESCRIPTION , TERM_ID PAYMENT_TERM_ID FROM RA_TERMS WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE , SYSDATE) AND NVL(END_DATE_ACTIVE , SYSDATE)