FA_LOOKUP_VALUES

Details

• Schema: FUSION

• Object owner: FA

• Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE DISPLAYED_FIELD DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE

Query

SQL_Statement
SELECT LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.MEANING DISPLAYED_FIELD, LV.DESCRIPTION, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV, FND_LOOKUP_TYPES LT WHERE LV.LANGUAGE = userenv('LANG') AND LV.LOOKUP_TYPE = LT.LOOKUP_TYPE AND LT.MODULE_ID = ( SELECT MODULE_ID FROM FND_APPLICATION WHERE APPLICATION_SHORT_NAME = 'FA')