[Home] [Help] [Dependency Information]
Object Name: | IBY_VALIDATION_VALUES |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_VALIDATION_VALUES |
Subobject Name: | |
Status: | VALID |
IBY_VALIDATION_VALUES stores the values for each validation parameter. For example, one validation controls the maximum amount that can be paid in a single payment instruction. The maximum amount parameter is stored in this table, and the actual value is stored in the associated table, IBY_VALIDATION_VALUES. This table corresponds to the Validations regions on the Payment Method and Format pages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_VALIDATION_VALUES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
VALIDATION_ASSIGNMENT_ID
VALIDATION_PARAMETER_CODE |
IBY_VALIDATION_VALUES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VALIDATION_SET_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALIDATION_ASSIGNMENT_ID | NUMBER | (15) | Yes | Validation assignment Identifier |
VALIDATION_PARAMETER_CODE | VARCHAR2 | (100) | Yes | Name or token of the parameter that uses this value |
VALIDATION_SET_CODE | VARCHAR2 | (30) | Yes | Validation set code |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object version number |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
VAL_PARAM_VARCHAR2_VALUE | VARCHAR2 | (3000) | Value of the validation parameter if it is of type VARCHAR2 | |
VAL_PARAM_NUMBER_VALUE | NUMBER | Value of the validation parameter if it is of type NUMBER | ||
VAL_PARAM_DATE_VALUE | DATE | Value of the validation parameter if it is of type DATE |
Cut, paste (and edit) the following text to query this object:
SELECT VALIDATION_ASSIGNMENT_ID
, VALIDATION_PARAMETER_CODE
, VALIDATION_SET_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN
, VAL_PARAM_VARCHAR2_VALUE
, VAL_PARAM_NUMBER_VALUE
, VAL_PARAM_DATE_VALUE
FROM IBY.IBY_VALIDATION_VALUES;
IBY.IBY_VALIDATION_VALUES does not reference any database object
IBY.IBY_VALIDATION_VALUES is referenced by following:
|
|
|