MOW_ASGN_MATCH_REGULAR_T2_GT

MOW_ASGN_MATCH_REGULAR_T2_GT is a Global Temp Table used at regular matching phase

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_MATCH_REGULAR_T2_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_REGULAR_T1
PARTY_ID	NUMBER	18	Yes	PARTY_ID Pulled from MOW_ASGN_MATCH_REGULAR_T1
TERRITORY_ID	NUMBER	18	Yes	TERRITORY_ID Pulled from MOW_ASGN_MATCH_REGULAR_T1
TERRITORY_VERSION_ID	NUMBER	18	Yes	TERRITORY_VERSION_ID Pulled from MOW_ASGN_MATCH_REGULAR_T1
TERR_RULE_ID	NUMBER	18	Yes	TERR_RULE_ID Pulled from MOW_ASGN_MATCH_REGULAR_T1

Indexes

Index	Uniqueness	Columns
MOW_ASGN_MATCH_REGULAR_T2_U1	Unique	SEQ_ID