MOT_SALES_ACCT_TEMP_FILTERS
This entity is introduced to enhance performance when showing Sales Accounts in the Territory Manager UI ( ie Dimension shuttle) It is used in flows where it is necessary to filter the sales account dimension by the values for the other dimensions selected for the Territory in context. It holds the user entered values for the chosen dimensions and related sequence number information. Data in this table is temporary and will be purged as soon as the user completes the selection of the sales account. Note: The data will be purged in a separate process in cases where data remains i the table when the user terminates the application by any other means.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SESSION_ID | VARCHAR2 | 256 | Yes | Indicates user session | |
| TERR_DIMENSION_CODE | VARCHAR2 | 5 | Yes | Refers to Terr Dimension Code in MOT_TERR_DIMENSIONS_B table. | |
| SEQUENCE_LOW | NUMBER | 18 | Yes | Sequence Low for dimension member, used by Assignment Manager to identify territory which should be selected for given dimension. | |
| SEQUENCE_HIGH | NUMBER | 18 | Yes | Sequence High for dimension member, used by Assignment Manager to identify territory which should be selected for given dimension. | |
| UNSPEC_FLAG | VARCHAR2 | 1 | Used in generating a separate predicate for 'Unspecified' dimension members. Valid values are 'Y' and 'N'. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_SALES_ACCT_TEMP_FILTERS_N1 | Non Unique | Default | SESSION_ID |