OKC_BUS_VARIABLES_B
This table stores all the business variables that can be used in clauses. This table contains variables of all type - System-defined, User-defined, Table and Deliverable.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
OKC_BUS_VARIABLES_B_PK |
VARIABLE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VARIABLE_CODE | VARCHAR2 | 30 | Yes | This is the primary key. It will be sequence based system generated in the case of user defined variables and a code in the case of seeded variables i.e. system, table or deliverable variables. These seeded variables are prefixed as OKC$S and OKC$B where B and S indicate Buy and Sell respectively. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| VARIABLE_TYPE | VARCHAR2 | 1 | Yes | This defines the type of the variable. The valid values are S=System, U=User Defined, T=Table, D=Deliverable. | |
| EXTERNAL_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate whether this variable can be updated by external users or not e.g. supplier. Currently applicable only to Procurement Contracts. | |
| VARIABLE_INTENT | VARCHAR2 | 1 | Yes | This defines the Intent of the variable i.e. Buy or Sell. Foreign Key to FND_LOOKUPS of lookup_type OKC_ARTICLE_INTENT. | |
| CONTRACT_EXPERT_YN | VARCHAR2 | 1 | Yes/No flag to indicate whether this variable is being used in Contract Expert or not. | ||
| DISABLED_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate whether this variable can no longer be used. | |
| VARIABLE_DATATYPE | VARCHAR2 | 1 | This is the datatype of the variable as defined in the value set corresponding to it (D= Date, N=Number, V=Varchar2). | ||
| APPLICATION_ID | NUMBER | 18 | This column references the owning application in the case of system variables. This is a foreign Key to FND_APPLICATION. | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| VALUE_SET_ID | NUMBER | 18 | This defines the source of the user-defined variable value. This is mandatory for user-defined variables. Foreign Key to FND FLEX Value Sets. | ||
| VARIABLE_DEFAULT_VALUE | VARCHAR2 | 30 | For future use. This column stores the default value for user-defined variables. | ||
| SEEDED_FLAG_YN | VARCHAR2 | 1 | Flag to indicate if the variable is a seeded one. Used to flag the PRM seeded variables | ||
| OBJECT_LOOKUP_CODE | VARCHAR2 | 30 | OBJECT_LOOKUP_CODE | ||
| CHILD_OBJECT_VO | VARCHAR2 | 255 | CHILD_OBJECT_VO | ||
| OBJECT_ID_ATTRIBUTE | VARCHAR2 | 50 | OBJECT_ID_ATTRIBUTE | ||
| OBJECT_VALUE_ATTRIBUTE | VARCHAR2 | 50 | OBJECT_VALUE_ATTRIBUTE | ||
| XPRT_LOOKUP_TYPE | VARCHAR2 | 30 | XPRT_LOOKUP_TYPE | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| XPRT_VALUE_SET_NAME | VARCHAR2 | 60 | Primary source for the contract expert enabled system variable values | ||
| LINE_LEVEL_FLAG | VARCHAR2 | 1 | Identify if the system variable is a line level variable. For all other variable types this would always be 'N' | ||
| DATE_PUBLISHED | DATE | Date the variable was published , specifically used for XML based Clause Import. | |||
| ORIG_SYSTEM_REFERENCE_CODE | VARCHAR2 | 30 | This is used to preserve source of code for variables to be imported from external system. User FYI only. | ||
| ORIG_SYSTEM_REFERENCE_ID1 | VARCHAR2 | 100 | This is used to preserve source of identifier1 for variables to be imported from external system. User FYI only. | ||
| ORIG_SYSTEM_REFERENCE_ID2 | VARCHAR2 | 100 | This is used to preserve source of identifier2 for variables to be imported from external system. User FYI only. | ||
| METHOD_NAME | VARCHAR2 | 200 | This column stores the CLASS.METHODNAME to source user defined variables. This is not applicable / not used in base R12 and prior releases. | ||
| VARIABLE_SOURCE | VARCHAR2 | 1 | Yes | Indicator to identify user defined varaible source. Possible values are M (Manual) and J (Java class and method) | |
| METHOD_TYPE | VARCHAR2 | 1 | Method type | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| okc_bus_variables_tl | okc_bus_variables_b | VARIABLE_CODE |
| okc_article_variables | okc_bus_variables_b | VARIABLE_CODE |
| okc_variable_doc_types | okc_bus_variables_b | VARIABLE_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_BUS_VARIABLES_B_U1 | Unique | Default | VARIABLE_CODE, ORA_SEED_SET1 |
| OKC_BUS_VARIABLES_B_U11 | Unique | Default | VARIABLE_CODE, ORA_SEED_SET2 |