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

TABLE: AX.AX_RULES

Object Details
Object Name: AX_RULES
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_RULES
Subobject Name:
Status: VALID


This table stores the header information for each archived rule set.
It contains a row for every archived rule set available for an
application.
Each row contains the identifier, the name of the rule set and the
identifier of the related application.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_RULES_PK
  1. ColumnRULE_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAX_RULE_LINES AX_RULE_LINES_FK1 AX_RULES AX_RULE_LINES RULE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
RULE_ID NUMBER
Yes Rule identifier
RULE_NAME VARCHAR2 (100)
Rule name
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
RULE_VERSION VARCHAR2 (30)
Reserved for a future release
RULE_SUB_VERSION VARCHAR2 (30)
Reserved for a future release
RULE_REVISION VARCHAR2 (30)
Reserved for a future release
PROCESSED_FLAG VARCHAR2 (1)
stores information about processing by compiler
Query Text

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


SELECT APPLICATION_ID
,      RULE_ID
,      RULE_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RULE_VERSION
,      RULE_SUB_VERSION
,      RULE_REVISION
,      PROCESSED_FLAG
FROM AX.AX_RULES;

Dependencies

[top of page]

AX.AX_RULES does not reference any database object

AX.AX_RULES is referenced by following:

SchemaAPPS
SynonymAX_RULES