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') |