XLE_LOOKUPS

Details

• Schema: FUSION

• Object owner: XLE

• Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE

Query

SQL_Statement

SELECT LOOKUP_TYPE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV WHERE LANGUAGE = userenv('LANG') and LOOKUP_TYPE LIKE 'XLE_%' UNION ALL SELECT LOOKUP_TYPE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE FROM HZ_LOOKUPS HZLV WHERE LANGUAGE = userenv('LANG') AND LOOKUP_TYPE = 'LEGISLATIVE_CATEGORY'