SELECT MEANING FOB , LOOKUP_CODE FOB_CODE FROM AR_LOOKUPS WHERE LOOKUP_TYPE = 'FOB' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE, TRUNC(SYSDATE))
View Text - HTML Formatted
SELECT MEANING FOB , LOOKUP_CODE FOB_CODE FROM AR_LOOKUPS WHERE LOOKUP_TYPE = 'FOB' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE , TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))