1. Tables and Views for Common Features
  2. FND_SETID_LOOKUPS

FND_SETID_LOOKUPS

Details

  • Schema: LOOKUPS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LOOKUP_CODE

SET_ID

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 LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.SET_ID,

LV.MEANING, LV.DESCRIPTION, LV.ENABLED_FLAG,

LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.DISPLAY_SEQUENCE,LV.CHANGE_SINCE_LAST_REFRESH,

LV.CREATED_BY, LV.CREATION_DATE, LV.LAST_UPDATED_BY,

LV.LAST_UPDATE_DATE, LV.LAST_UPDATE_LOGIN, LV.TAG

FROM FND_LOOKUP_VALUES_VL LV

WHERE LV.VIEW_APPLICATION_ID = 2