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