SELECT MEANING FREIGHT_TERMS , LOOKUP_CODE FREIGHT_TERMS_CODE , START_DATE_ACTIVE , END_DATE_ACTIVE , DESCRIPTION FROM OE_LOOKUPS WHERE LOOKUP_TYPE = 'FREIGHT_TERMS' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE , TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))