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