SELECT lookup_type , lookup_code , meaning from MFG_LOOKUPS WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS' and nvl(start_date_active,sysdate) <= sysdate and nvl(end_date_active,sysdate) >= sysdate
View Text - HTML Formatted
SELECT LOOKUP_TYPE , LOOKUP_CODE , MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'MTL_DEMAND_INTERFACE_ERRORS' AND NVL(START_DATE_ACTIVE , SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE , SYSDATE) >= SYSDATE