MOT_TERR_RESTORE_GT

This table, temporarily maintains denormalized definition of the territory hierarchy that is required for territory restore functionality.

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Not-null Comments
TERRITORY_VERSION_ID NUMBER 18 Yes Indicates version id of the territory.
TERRITORY_LEVEL NUMBER 18 Yes Level of Territory in Territory Hierarchy.

Indexes

Index Uniqueness Columns
MOT_TERR_RESTORE_GT_U1 Unique TERRITORY_LEVEL, TERRITORY_VERSION_ID