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

TABLE: APPLSYS.WF_ROUTING_RULES

Object Details
Object Name: WF_ROUTING_RULES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_ROUTING_RULES
Subobject Name:
Status: VALID


WF_ROUTING_RULES stores all user defined rules for processing notifications.
Users may define rules to automatically forward,
respond to, or ignore incoming notifications.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ROUTING_RULES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Internal Identifier
ROLE VARCHAR2 (320) Yes Owner of rule
ACTION VARCHAR2 (8) Yes Action to take (either forward, respond or ignore)
BEGIN_DATE DATE

Start date
END_DATE DATE

Date finished
MESSAGE_TYPE VARCHAR2 (8)
foreign key to WF_MESSAGES
MESSAGE_NAME VARCHAR2 (30)
Foreign key to WF_MESSAGES
ACTION_ARGUMENT VARCHAR2 (2000)
Currently only of use for forward actions (stores the name of who to forward to)
RULE_COMMENT VARCHAR2 (4000)
User defined comment
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
Query Text

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


SELECT RULE_ID
,      ROLE
,      ACTION
,      BEGIN_DATE
,      END_DATE
,      MESSAGE_TYPE
,      MESSAGE_NAME
,      ACTION_ARGUMENT
,      RULE_COMMENT
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_ROUTING_RULES;

Dependencies

[top of page]

APPLSYS.WF_ROUTING_RULES does not reference any database object

APPLSYS.WF_ROUTING_RULES is referenced by following:

SchemaAPPLSYS
ViewWF_ROUTING_RULES#