MOW_ASGN_MATCH_OTHERS_T1_GT

MOW_ASGN_MATCH_OTHERS_T1_GT is a Global Temp Table used at incluion matching phase

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_MATCH_OTHERS_T1_PK	SEQ_ID

Columns

Name	Datatype	Precision	Not-null	Comments
SEQ_ID	NUMBER	18	Yes	SEQ_ID = To Store the primary key value
TERR_RULE_BNDRY_VALS_DN_ID	NUMBER	18	Yes	TERR_RULE_BNDRY_VALS_DN_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T2
PARTY_ID	NUMBER	18	Yes	PARTY_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T2
TERRITORY_ID	NUMBER	18	Yes	TERRITORY_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T2
TERRITORY_VERSION_ID	NUMBER	18	Yes	TERRITORY_VERSION_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T2
TERR_RULE_ID	NUMBER	18	Yes	TERR_RULE_ID = Pulled from MOW_ASGN_MATCH_OTHERS_T2

Indexes

Index	Uniqueness	Columns
MOW_ASGN_MATCH_OTHERS_T1_U1	Unique	SEQ_ID