MOW_MRA_PROCESS_ITEMS

Used in match resolve act flow. This table data act as input to process the extension rules.

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MOW_MRA_PROCESS_ITEMS_PK

EXECUTION_NUMBER, SEQUENCE_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
EXECUTION_NUMBER NUMBER 18 Yes EXECUTION_NUMBER
SEQUENCE_NUMBER NUMBER 18 Yes SEQUENCE_NUMBER
FAMILY_CODE VARCHAR2 30 FAMILY_CODE
DATA_SOURCE_NAME VARCHAR2 30 DATA_SOURCE
OBJECT_ID NUMBER 18 OBJECT_ID
OBJECT_NUMBER VARCHAR2 1000 OBJECT_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_PROCESS_ITEMS_U1 Unique Default EXECUTION_NUMBER, SEQUENCE_NUMBER