eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GCS.GCS_LEX_MAP_RULES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

GCS.GCS_LEX_MAP_RULES does not reference any database object

GCS.GCS_LEX_MAP_RULES is referenced by following:

APPS: GCS_LEX_MAP_RULES