VIEW: APPS.IGW_LOOKUPS_V

Source

View Text - Preformatted

SELECT lookup_type, lookup_code, meaning, description from fnd_lookups WHERE enabled_flag = 'Y' and start_date_active <= sysdate and ( end_date_active is null or end_date_active >= sysdate )

View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
FROM FND_LOOKUPS
WHERE ENABLED_FLAG = 'Y'
AND START_DATE_ACTIVE <= SYSDATE
AND ( END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE >= SYSDATE )