1. Tables and Views for Common Features
  2. FND_LOOKUPS

FND_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

TAG

Query

SQL_Statement

SELECT

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,TAG

FROM

FND_LOOKUP_VALUES_VL

WHERE VIEW_APPLICATION_ID = 0

AND SET_ID = 0