MOW_ASGN_MATCH_TF0_GT

MOW_ASGN_MATCH_TF0_GT is a Global Temp Table where we finally store the data on matching phase

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_MATCH_TF0_PK	SEQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEQ_ID	NUMBER		18	Yes	SEQ_ID = To store the primary key value
PARTY_ID	NUMBER		18	Yes	PARTY_ID = Pulled from MOW_ASGN_MATCH REGULAR and OTHER, based on the last table we got
INCLUSION_FLAG	VARCHAR2	1			INCLUSION_FLAG = Pulled from table MOT_TERR_BNDRY_VALS_DN_V
TERRITORY_ID	NUMBER		18	Yes	TERRITORY_ID = Pulled from table MOT_TERR_BNDRY_VALS_DN_V
TERRITORY_VERSION_ID	NUMBER		18	Yes	TERRITORY_VERSION_ID = Pulled from table MOT_TERR_BNDRY_VALS_DN_V
TERRITORY_ID1	NUMBER		18	Yes	TERRITORY_ID1 = Pulled from table MOT_TERR_HIERARCHY_DN

Indexes

Index	Uniqueness	Columns
MOW_ASGN_MATCH_TF0_U1	Unique	SEQ_ID