[Home] [Help] [Dependency Information]

TABLE: AX.AX_RULE_LINES

Object Details

Object Name:	AX_RULE_LINES
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_RULE_LINES
Subobject Name:
Status:	VALID

This table stores the components of a rule set.
It includes a row for every field of every row of every table used by
the rule set. The standard Row-Who fields are not stored.
Each row contains the table name, the column name and the column
value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_RULE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_ID RECORD_ID
AX_RULE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_ID TABLE_NAME RECORD_ID COLUMN_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_RULE_LINES		AX_RULES	AX_RULE_LINES RULE_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT RULE_ID
,      RECORD_ID
,      TABLE_NAME
,      COLUMN_NAME
,      COLUMN_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AX.AX_RULE_LINES;

Dependencies

[top of page]

AX.AX_RULE_LINES does not reference any database object

AX.AX_RULE_LINES is referenced by following:

APPS

AX_RULE_LINES