SELECT LOOKUP_CODE , MEANING , ENABLED_FLAG , START_DATE_ACTIVE START_DATE , END_DATE_ACTIVE END_DATE FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'FIELD_TYPE' AND LOOKUP_CODE IN ('C' , 'N' , 'X' , 'Y') AND VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG')