FND_COMMON_LOOKUPS

Details

• Schema: LOOKUPS

• Object owner: FND

• Object type: VIEW

Columns

Name

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

Query

SQL_Statement

( SELECT FLV.LOOKUP_TYPE, FLV.LOOKUP_CODE, FLV.MEANING, FLV.DESCRIPTION, FLV.ENABLED_FLAG, FLV.START_DATE_ACTIVE, FLV.END_DATE_ACTIVE, FLV.DISPLAY_SEQUENCE,FLV.CHANGE_SINCE_LAST_REFRESH, FLV.CREATED_BY, FLV.CREATION_DATE, FLV.LAST_UPDATED_BY, FLV.LAST_UPDATE_DATE, FLV.LAST_UPDATE_LOGIN, FLV.ATTRIBUTE_CATEGORY, FLV.ATTRIBUTE1, FLV.ATTRIBUTE2, FLV.ATTRIBUTE3, FLV.ATTRIBUTE4, FLV.ATTRIBUTE5, FLV.ATTRIBUTE6, FLV.ATTRIBUTE7, FLV.ATTRIBUTE8, FLV.ATTRIBUTE9, FLV.ATTRIBUTE10, FLV.ATTRIBUTE11, FLV.ATTRIBUTE12, FLV.ATTRIBUTE13, FLV.ATTRIBUTE14, FLV.ATTRIBUTE15,FLV.TAG FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.VIEW_APPLICATION_ID = 3 AND FLV.SET_ID = 0)