SELECT lookup_code duration_type, meaning from fnd_lookup_values where enabled_flag = 'Y' and lookup_type = 'IBY_DURATION_TYPE' and language = userenv('LANG') and lookup_code IN ('D','W') order by lookup_code
View Text - HTML Formatted
SELECT LOOKUP_CODE DURATION_TYPE , MEANING FROM FND_LOOKUP_VALUES WHERE ENABLED_FLAG = 'Y' AND LOOKUP_TYPE = 'IBY_DURATION_TYPE' AND LANGUAGE = USERENV('LANG') AND LOOKUP_CODE IN ('D' , 'W') ORDER BY LOOKUP_CODE