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

TABLE: OKC.OKC_XPRT_RULE_EVAL_RESULT_T

Object Details
Object Name: OKC_XPRT_RULE_EVAL_RESULT_T
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_XPRT_RULE_EVAL_RESULT_T
Subobject Name:
Status: VALID


This table stores the evaluation result of the rules and conditions at any point of time


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_XPRT_RULE_EVAL_RESULT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_CONDITION_RESULT_ID
OKC_XPRT_RULE_EVAL_RESULT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_ID
ColumnDOC_TYPE
ColumnRULE_ID
OKC_XPRT_RULE_EVAL_RESULT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_ID
ColumnDOC_TYPE
ColumnRULE_ID
ColumnCONDITION_ID
Columns
Name Datatype Length Mandatory Comments
RULE_CONDITION_RESULT_ID NUMBER (22) Yes Unique Id
DOC_ID NUMBER (22) Yes Business Document Id
DOC_TYPE VARCHAR2 (30) Yes Business Document Type
RULE_ID NUMBER (22) Yes Rule Id
CONDITION_ID NUMBER (22)
Rule Condition Id
CONDITION_TYPE VARCHAR2 (30)
Condition Type
OBJECT_CODE VARCHAR2 (40)
LHS of the rule condition
RULE_EXPR_TYPE VARCHAR2 (30)
Rule Type
OBJECT_VALUE_TYPE VARCHAR2 (30)
Type of the RHS of the rule condition
OBJECT_VALUE_CODE VARCHAR2 (1000)
RHS value of the rule condition
RESULT VARCHAR2 (30)
Result of the rule or condition
COND_OPERATOR VARCHAR2 (30)
Operator of the rule condition
Query Text

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


SELECT RULE_CONDITION_RESULT_ID
,      DOC_ID
,      DOC_TYPE
,      RULE_ID
,      CONDITION_ID
,      CONDITION_TYPE
,      OBJECT_CODE
,      RULE_EXPR_TYPE
,      OBJECT_VALUE_TYPE
,      OBJECT_VALUE_CODE
,      RESULT
,      COND_OPERATOR
FROM OKC.OKC_XPRT_RULE_EVAL_RESULT_T;

Dependencies

[top of page]

OKC.OKC_XPRT_RULE_EVAL_RESULT_T does not reference any database object

OKC.OKC_XPRT_RULE_EVAL_RESULT_T is referenced by following:

SchemaOKC
ViewOKC_XPRT_RULE_EVAL_RESULT_T#