1. Tables and Views for Sales and Fusion Service
  2. MOW_MRA_RULE_CONDITIONS

MOW_MRA_RULE_CONDITIONS

Rules, conditions, their values and groupings of rules.

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MOW_MRA_RULE_CONDITIONS_PK

RULE_NUMBER, FAMILY_CODE, DATA_SOURCE_NAME, DATA_COLUMN, RHS_DATA_SOURCE_NAME, RHS_DATA_COLUMN

Columns

Name Datatype Length Precision Not-null Comments
RULE_NUMBER NUMBER 18 Yes RULE_NUMBER
FAMILY_CODE VARCHAR2 30 Yes FAMILY_CODE
DATA_SOURCE_NAME VARCHAR2 30 Yes DATA_SOURCE_NAME
DATA_COLUMN VARCHAR2 30 Yes DATA_COLUMN
MATCH_OPERATOR VARCHAR2 30 Yes MATCH_OPERATOR
LITERAL_VALUE CLOB LITERAL_VALUE
VALUE_TYPE VARCHAR2 30 Yes VALUE_TYPE
RHS_DATA_SOURCE_NAME VARCHAR2 30 Yes RHS_DATA_SOURCE_NAME
RHS_DATA_COLUMN VARCHAR2 30 Yes RHS_DATA_COLUMN
LOOK_BACK_RULE VARCHAR2 90 LOOK_BACK_RULE
LOOK_BACK_CONDITION VARCHAR2 100 LOOK_BACK_CONDITION
LOOK_BACK_DETAILS VARCHAR2 4000 LOOK_BACK_DETAILS
TAG VARCHAR2 30 TAG1
EXECUTE_RULE VARCHAR2 1 Yes EXECUTE_RULE
IGNORE_CASE VARCHAR2 1 IGNORE_CASE
RULE_SET_BATCH_NUMBER NUMBER 18 rule_set_batch_number
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
MOW_MRA_RULE_CONDITIONS_U1 Unique Default RULE_NUMBER, FAMILY_CODE, DATA_SOURCE_NAME, DATA_COLUMN, RHS_DATA_SOURCE_NAME, RHS_DATA_COLUMN