[Home] [Help]
[Dependency Information]
VIEW: SYS.ALL_RULES
Object Details
Object Name: | ALL_RULES |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Rules seen by the user
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
RULE_OWNER |
VARCHAR2 |
(128) |
Yes |
Owner of the rule |
RULE_NAME |
VARCHAR2 |
(128) |
Yes |
Name of the rule |
RULE_CONDITION |
CLOB |
(4000) |
|
the rule expression |
RULE_EVALUATION_CONTEXT_OWNER |
VARCHAR2 |
(128) |
|
owner of the evaluation context on which rule is defined |
RULE_EVALUATION_CONTEXT_NAME |
VARCHAR2 |
(128) |
|
name of the evaluation context on which rule is defined |
RULE_ACTION_CONTEXT |
RE$NV_LIST |
(64) |
|
action context of the rule |
RULE_COMMENT |
VARCHAR2 |
(4000) |
|
user description of the rule |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT RULE_OWNER
, RULE_NAME
, RULE_CONDITION
, RULE_EVALUATION_CONTEXT_OWNER
, RULE_EVALUATION_CONTEXT_NAME
, RULE_ACTION_CONTEXT
, RULE_COMMENT
FROM SYS.ALL_RULES;
Dependencies
[top of page]
SYS.ALL_RULES references the following:
-
SYS
-
OBJ$
-
OBJAUTH$
-
RE$NV_LIST
-
RULE$
-
STANDARD
- show dependent code
-
USER$
-
-
-
-
SYS.ALL_RULES is referenced by following:
-
APPLSYS
-
AQ$FND_CP_GSM_IPC_AQTBL_R
-
AQ$FND_CP_GSM_OPP_AQTBL_R
-
AQ$FND_CP_TM_AQTBL_R
-
AQ$FND_CP_TM_RET_AQTBL_R
-
AQ$WF_JAVA_DEFERRED_R
-
AQ$WF_JAVA_ERROR_R
-
AQ$WF_JMS_JMS_OUT_R
-
AQ$WF_WS_JMS_IN_R
-
AQ$WF_WS_JMS_OUT_R
-
AQ$WF_WS_SAMPLE_R
-
APPS
-
AQ$WF_BPEL_QTAB_R
-
AR
-
AQ$HZ_JMS_OUT_R
-
GSMADMIN_INTERNAL
-
AQ$CHANGE_LOG_QUEUE_TABLE_R
-
PO
-
AQ$PO_OTM_OUT_R
-
PUBLIC
-
ALL_RULES
-
SYS
-
ALL_APPLY_ENQUEUE
-
ALL_APPLY_EXECUTE
-
ALL_STREAMS_GLOBAL_RULES
-
ALL_STREAMS_MESSAGE_RULES
-
ALL_STREAMS_SCHEMA_RULES
-
ALL_STREAMS_TABLE_RULES
-
ALL_STREAMS_TRANSFORM_FUNCTION
-
AQ$ALERT_QT_R
-
AQ$AQ_PROP_TABLE_R
-
AQ$SCHEDULER$_EVENT_QTAB_R
-
AQ$SCHEDULER$_REMDB_JOBQTAB_R
-
AQ$SCHEDULER_FILEWATCHER_QT_R
-
AQ$SYS$SERVICE_METRICS_TAB_R
-
DBMS_SCHEDULER
- show dependent code