SELECT lookup_code, meaning, language from fnd_lookup_values where lookup_type='ICX_CAT_CLASSIFICATION_DOMAINS' and nvl(end_date_active, sysdate+1) > sysdate and nvl(start_date_active, sysdate-1) < sysdate and nvl(enabled_flag, 'Y') <> 'N'
SELECT LOOKUP_CODE
, MEANING
, LANGUAGE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE='ICX_CAT_CLASSIFICATION_DOMAINS'
AND NVL(END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(ENABLED_FLAG
, 'Y') <> 'N'
|
|
|