FND_VS_VALUES_B

Flexfields: Value Sets: Value (_B) Table.

Details

  • Schema: VST

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_VS_VALUES_B_PK

VALUE_ID, ENTERPRISE_ID, SANDBOX_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
SANDBOX_ID VARCHAR2 64 Yes SANDBOX_ID
VALUE_ID NUMBER 18 Yes Primary key by itself (See U1 index). Only used to join _B and _TL tables.
VALUE_SET_ID NUMBER 18 Yes Value is a member of this Value Set.
VALUE VARCHAR2 150 Yes VARCHAR2 Value for VARCHAR2 typed value sets. VARCHAR2 representation of Value for NUMBER, DATE, and TIMESTAMP typed value sets.
VALUE_NUMBER NUMBER NUMBER Value for NUMBER typed value sets.
VALUE_DATE DATE DATE Value for DATE typed value sets.
VALUE_TIMESTAMP TIMESTAMP TIMESTAMP Value for TIMESTAMP typed value sets.
INDEPENDENT_VALUE VARCHAR2 150 For Dependent Value Sets only. VARCHAR2 Independent Value for VARCHAR2 typed independent value sets. VARCHAR2 representation of Independent Value for NUMBER, DATE, and TIMESTAMP typed independent value sets.
INDEPENDENT_VALUE_NUMBER NUMBER NUMBER Independent Value for NUMBER typed independent value sets.
INDEPENDENT_VALUE_DATE DATE DATE Independent Value for DATE typed independent value sets.
INDEPENDENT_VALUE_TIMESTAMP TIMESTAMP TIMESTAMP Independent Value for TIMESTAMP typed independent value sets.
ENABLED_FLAG VARCHAR2 1 Yes ENABLED_FLAG
START_DATE_ACTIVE DATE START_DATE_ACTIVE
END_DATE_ACTIVE DATE END_DATE_ACTIVE
SORT_ORDER NUMBER 18 SORT_ORDER
ATTRIBUTE_CATEGORY VARCHAR2 60 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE31 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE32 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE33 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE34 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE35 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE36 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE37 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE38 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE39 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE40 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE41 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE42 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE43 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE44 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE45 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE46 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE47 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE48 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE49 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE50 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
SUMMARY_FLAG VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/SUMMARY_FLAG.
FLEX_VALUE_ATTRIBUTE1 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/DETAIL_POSTING_ALLOWED.
FLEX_VALUE_ATTRIBUTE2 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/DETAIL_BUDGETING_ALLOWED.
FLEX_VALUE_ATTRIBUTE3 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/GL_ACCOUNT_TYPE.
FLEX_VALUE_ATTRIBUTE4 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/GL_CONTROL_ACCOUNT.
FLEX_VALUE_ATTRIBUTE5 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/RECONCILIATION_FLAG.
FLEX_VALUE_ATTRIBUTE6 VARCHAR2 30 Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/FINANCIAL_CATEGORY.
FLEX_VALUE_ATTRIBUTE7 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE7
FLEX_VALUE_ATTRIBUTE8 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE8
FLEX_VALUE_ATTRIBUTE9 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE9
FLEX_VALUE_ATTRIBUTE10 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE10
FLEX_VALUE_ATTRIBUTE11 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE11
FLEX_VALUE_ATTRIBUTE12 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE12
FLEX_VALUE_ATTRIBUTE13 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE13
FLEX_VALUE_ATTRIBUTE14 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE14
FLEX_VALUE_ATTRIBUTE15 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE15
FLEX_VALUE_ATTRIBUTE16 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE16
FLEX_VALUE_ATTRIBUTE17 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE17
FLEX_VALUE_ATTRIBUTE18 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE18
FLEX_VALUE_ATTRIBUTE19 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE19
FLEX_VALUE_ATTRIBUTE20 VARCHAR2 30 FLEX_VALUE_ATTRIBUTE20
CUSTOM_VALUE_ATTRIBUTE1 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE1
CUSTOM_VALUE_ATTRIBUTE2 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE2
CUSTOM_VALUE_ATTRIBUTE3 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE3
CUSTOM_VALUE_ATTRIBUTE4 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE4
CUSTOM_VALUE_ATTRIBUTE5 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE5
CUSTOM_VALUE_ATTRIBUTE6 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE6
CUSTOM_VALUE_ATTRIBUTE7 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE7
CUSTOM_VALUE_ATTRIBUTE8 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE8
CUSTOM_VALUE_ATTRIBUTE9 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE9
CUSTOM_VALUE_ATTRIBUTE10 VARCHAR2 30 CUSTOM_VALUE_ATTRIBUTE10
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE VARCHAR2 512 Seed data file from which the row originates.
EXTERNAL_DATA_SOURCE VARCHAR2 512 External data source from which the row originates.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns
FND_VS_VALUES_B_N1 Non Unique Default VALUE_SET_ID, VALUE, ENTERPRISE_ID, SANDBOX_ID
FND_VS_VALUES_B_N2 Non Unique Default VALUE_SET_ID, UPPER("VALUE"), INDEPENDENT_VALUE, ENTERPRISE_ID, SANDBOX_ID
FND_VS_VALUES_B_U1 Unique Default VALUE_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1
FND_VS_VALUES_B_U11 Unique Default VALUE_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2
FND_VS_VALUES_B_U2 Unique Default VALUE_SET_ID, INDEPENDENT_VALUE, VALUE, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1
FND_VS_VALUES_B_U21 Unique Default VALUE_SET_ID, INDEPENDENT_VALUE, VALUE, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2