[Home] [Help] [Dependency Information]
Object Name: | ECE_COLUMN_RULES |
---|---|
Object Type: | TABLE |
Owner: | EC |
FND Design Data: | EC.ECE_COLUMN_RULES |
Subobject Name: | |
Status: | VALID |
ECE_COLUMN_RULES contains column rule definitions for
the generic inbound execution engine. Rules defined for
columns are stored in this table and the associated child
tables depending on the rule type.
Each ECE_COLUMN_RULES row is associated with one row
in ECE_INTERFACE_COLUMNS. There is a one-to-many
relationship between ECE_INTERFACE_COLUMNS and
ECE_COLUMN_RULES.
The column rules of a given interface column are executed
by the SEQUENCE order. Also, each rule has an associated
ACTION_CODE to indicate the action to perform when the
rule is violated.
The 'VALUE_REQUIRED' rule are seeded for the required (not
null) columns and the 'DATATYPE_CHECKING' rule are seeded
for the Number and Date columns. You define new column
rules using the Interface File Definition form.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ECE_COLUMN_RULES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | COLUMN_RULE_ID |
ECE_COLUMN_RULES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | INTERFACE_COLUMN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLUMN_RULE_ID | NUMBER | (15) | Yes | Column Rule ID |
INTERFACE_COLUMN_ID | NUMBER | (15) | Yes | Interface Column ID |
SEQUENCE | NUMBER | (15) | Yes | Sequence of Column Rule |
RULE_TYPE | VARCHAR2 | (80) | Yes | Column Rule Type |
ACTION_CODE | VARCHAR2 | (20) | Yes | Column Rule Action Code |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT COLUMN_RULE_ID
, INTERFACE_COLUMN_ID
, SEQUENCE
, RULE_TYPE
, ACTION_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM EC.ECE_COLUMN_RULES;
EC.ECE_COLUMN_RULES does not reference any database object
EC.ECE_COLUMN_RULES is referenced by following:
|
|
|