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 |