[Home] [Help] [Dependency Information]
Object Name: | GCS_LEX_MAP_RULES |
---|---|
Object Type: | TABLE |
Owner: | GCS |
FND Design Data: | GCS.GCS_LEX_MAP_RULES |
Subobject Name: | |
Status: | VALID |
GCS_LEX_MAP_RULES contains rules that are defined for target columns in a stage of a Transformation Rule Set. A rule consists of one or more conditional derivations, and can be validated using a Lookup Table or a Value Set. Only one rule may be defined for a particular target column within a stage. Additional rules can be defined for the same target column as long as the rules are contained in different stages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GCS_LEX_MAP_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RULE_ID |
GCS_LEX_MAP_RULES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RULE_STAGE_ID
TARGET_COLUMN_ID |
SYS_IL0000326089C00013$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (15) | Yes | Rule identifier |
RULE_STAGE_ID | NUMBER | (15) | Yes | Stage identifier |
TARGET_COLUMN_ID | NUMBER | (15) | Yes | Rule target column |
VALIDATION_TYPE_CODE | VARCHAR2 | (30) | Yes | L(Lookup Table), V(Value Set), or N(None) for transformation rule sets, and CONDITION, LOOKUP, or PLSQL for validation rule sets |
VALUE_SET_ID | NUMBER | (15) | Value set used if the validation type is Value Set | |
LOOKUP_TABLE_ID | NUMBER | (15) | Lookup table used if the validation type is Lookup Table | |
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 | |
RULE_NAME | VARCHAR2 | (30) | User entered rule name | |
ERROR_MESSAGE | CLOB | (4000) | Error message for validation rules |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, RULE_STAGE_ID
, TARGET_COLUMN_ID
, VALIDATION_TYPE_CODE
, VALUE_SET_ID
, LOOKUP_TABLE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RULE_NAME
, ERROR_MESSAGE
FROM GCS.GCS_LEX_MAP_RULES;
GCS.GCS_LEX_MAP_RULES does not reference any database object
GCS.GCS_LEX_MAP_RULES is referenced by following:
|
|
|