FND_LOOKUP_VALUES

Details

Schema: LOOKUPS
Object owner: FND
Object type: VIEW

Columns

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

Name

ROW_ID

LOOKUP_TYPE

LOOKUP_CODE

VIEW_APPLICATION_ID

SET_ID

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

DISPLAY_SEQUENCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

TERRITORY_CODE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

TAG

CHANGE_SINCE_LAST_REFRESH

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.LOOKUP_TYPE, B.LOOKUP_CODE, B.VIEW_APPLICATION_ID, B.SET_ID, T.MEANING, T.DESCRIPTION, B.ENABLED_FLAG, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.DISPLAY_SEQUENCE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE, B.TERRITORY_CODE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.TAG, B.CHANGE_SINCE_LAST_REFRESH FROM FND_LOOKUP_VALUES_TL T, FND_LOOKUP_VALUES_B B WHERE T.LOOKUP_TYPE = B.LOOKUP_TYPE AND T.LOOKUP_CODE = B.LOOKUP_CODE AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND T.SET_ID = B.SET_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.LOOKUP_TYPE,

B.LOOKUP_CODE,

B.VIEW_APPLICATION_ID,

B.SET_ID,

T.MEANING,

T.DESCRIPTION,

B.ENABLED_FLAG,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

B.DISPLAY_SEQUENCE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.LAST_UPDATE_DATE,

B.TERRITORY_CODE,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.TAG,

B.CHANGE_SINCE_LAST_REFRESH

FROM

FND_LOOKUP_VALUES_TL T,

FND_LOOKUP_VALUES_B B

WHERE

T.LOOKUP_TYPE = B.LOOKUP_TYPE AND T.LOOKUP_CODE = B.LOOKUP_CODE AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND T.SET_ID = B.SET_ID AND T.LANGUAGE = USERENV('LANG')