IEX_LOOKUPS_V

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY MEANING ENABLED_FLAG DESCRIPTION ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 VIEW_APPLICATION_ID SET_ID START_DATE_ACTIVE END_DATE_ACTIVE

Query

SQL_Statement

SELECT fndlkpv.Lookup_Type , fndlkpv.Lookup_Code , fndlkpv.Last_update_date , fndlkpv.last_updated_by , fndlkpv.last_update_login , fndlkpv.creation_date , fndlkpv.created_by , fndlkpv.Meaning , fndlkpv.Enabled_flag , fndlkpv.description , fndlkpv.attribute_category , fndlkpv.attribute1 , fndlkpv.attribute2 , fndlkpv.attribute3 , fndlkpv.attribute4 , fndlkpv.attribute5 , fndlkpv.attribute6 , fndlkpv.attribute7 , fndlkpv.attribute8 , fndlkpv.attribute9 , fndlkpv.attribute10 , fndlkpv.attribute11 , fndlkpv.attribute12 , fndlkpv.attribute13 , fndlkpv.attribute14 , fndlkpv.attribute15, fndlkpv.view_application_id, fndlkpv.set_id, fndlkpv.start_date_active, fndlkpv.end_date_active FROM FND_LOOKUP_VALUES fndlkpv WHERE FNDLKPV.LANGUAGE = userenv('LANG') AND FNDLKPV.VIEW_APPLICATION_ID = 695