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 |