MOW_ASGN_MATCH_FINAL_GT

MOW_ASGN_MATCH_FINAL_GT is a Global Temp Table to store the data finally on POST phase

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MOW_ASGN_MATCH_FINAL_PK

SEQ_ID

Columns

Name Datatype Precision Not-null Comments
SEQ_ID NUMBER 18 Yes SEQ_ID = To store the primary key value
PARTY_ID NUMBER 18 PARTY_ID = Pulled from MOW_ASGN_MATCH_TF1
TERRITORY_ID NUMBER 18 Yes TERRITORY_ID = Pulled from MOW_ASGN_MATCH_TF1
TERRITORY_VERSION_ID NUMBER 18 Yes TERRITORY_VERSION_ID = Pulled from MOW_ASGN_MATCH_TF1

Indexes

Index Uniqueness Columns
MOW_ASGN_MATCH_FINAL_U1 Unique SEQ_ID