MOW_ASGN_GEO_HIERARCHY_GT

MOW_ASGN_GEO_HIERARCHY_GT is a Global Temp Table to store the GEO HIERARCHY

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_GEO_HIERARCHY_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_ACCOUNTS table
CHILD_ID	NUMBER		18	Yes	CHILD_ID = Pulled from table HZ_HIERARCHY_NODES
PARENT_ID	NUMBER		18	Yes	PARENT_ID = Pulled from table HZ_HIERARCHY_NODES
TERRITORY_GEOGRAPHY_NAME	VARCHAR2	360			TERRITORY_GEOGRAPHY_NAME = To store the value of column BASE_ZONE_NAME of table HZ_GEO_HIERARCHY_CF

Indexes

Index	Uniqueness	Columns
MOW_ASGN_GEO_HIERARCHY_U1	Unique	SEQ_ID