[Home] [Help] [Dependency Information]
Object Name: | IEC_O_VALIDATION_RULES_TL |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Contains translatable data for validation rules, associating a block of actions/rules with a name.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_O_VALIDATION_RULES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
VALIDATION_RULE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALIDATION_RULE_ID | NUMBER | (15) | Yes | Unique identifier assigned for each validation rule. |
VALIDATION_RULE_NAME | VARCHAR2 | (60) | The name of the validation rule. Will be used to select this validation rule when configuring lists. | |
LANGUAGE | VARCHAR2 | (240) | Yes | Language code for the current record. |
SOURCE_LANG | VARCHAR2 | (240) | Yes | The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
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. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Used for locking in HTML applications. |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. |
Cut, paste (and edit) the following text to query this object:
SELECT VALIDATION_RULE_ID
, VALIDATION_RULE_NAME
, LANGUAGE
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM IEC.IEC_O_VALIDATION_RULES_TL;
IEC.IEC_O_VALIDATION_RULES_TL does not reference any database object
IEC.IEC_O_VALIDATION_RULES_TL is referenced by following:
|
|
|