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 ('M','Y') 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 ('M' , 'Y') ORDER BY LOOKUP_CODE