1. Tables and Views for Common Features
  2. FND_FLEX_VALUES_VL

FND_FLEX_VALUES_VL

Details

  • Schema: EBS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

FLEX_VALUE_SET_ID

FLEX_VALUE_ID

FLEX_VALUE

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

SUMMARY_FLAG

PARENT_FLEX_VALUE_LOW

PARENT_FLEX_VALUE_HIGH

STRUCTURED_HIERARCHY_LEVEL

HIERARCHY_LEVEL

COMPILED_VALUE_ATTRIBUTES

VALUE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ATTRIBUTE31

ATTRIBUTE32

ATTRIBUTE33

ATTRIBUTE34

ATTRIBUTE35

ATTRIBUTE36

ATTRIBUTE37

ATTRIBUTE38

ATTRIBUTE39

ATTRIBUTE40

ATTRIBUTE41

ATTRIBUTE42

ATTRIBUTE43

ATTRIBUTE44

ATTRIBUTE45

ATTRIBUTE46

ATTRIBUTE47

ATTRIBUTE48

ATTRIBUTE49

ATTRIBUTE50

ATTRIBUTE_SORT_ORDER

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

FLEX_VALUE_MEANING

DESCRIPTION

Query

SQL_Statement

SELECT

B.ROW_ID ROW_ID,

B.FLEX_VALUE_SET_ID,

B.FLEX_VALUE_ID,

B.FLEX_VALUE,

B.ENABLED_FLAG,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

B.SUMMARY_FLAG,

B.PARENT_FLEX_VALUE_LOW,

B.PARENT_FLEX_VALUE_HIGH,

B.STRUCTURED_HIERARCHY_LEVEL,

B.HIERARCHY_LEVEL,

B.COMPILED_VALUE_ATTRIBUTES,

B.VALUE_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.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

B.ATTRIBUTE31,

B.ATTRIBUTE32,

B.ATTRIBUTE33,

B.ATTRIBUTE34,

B.ATTRIBUTE35,

B.ATTRIBUTE36,

B.ATTRIBUTE37,

B.ATTRIBUTE38,

B.ATTRIBUTE39,

B.ATTRIBUTE40,

B.ATTRIBUTE41,

B.ATTRIBUTE42,

B.ATTRIBUTE43,

B.ATTRIBUTE44,

B.ATTRIBUTE45,

B.ATTRIBUTE46,

B.ATTRIBUTE47,

B.ATTRIBUTE48,

B.ATTRIBUTE49,

B.ATTRIBUTE50,

B.ATTRIBUTE_SORT_ORDER,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

T.FLEX_VALUE_MEANING,

T.DESCRIPTION

FROM FND_FLEX_VALUES B,

FND_FLEX_VALUES_TL T

WHERE B.FLEX_VALUE_ID = T.FLEX_VALUE_ID

AND T.LANGUAGE = USERENV('LANG')