HZ_GEO_NAME_REFERENCE_LOG
The HZ_GEO_NAME_REFERENCE_LOG table stores the mapping log between location elements and Master Reference geography elements based on Geography Name Matching. The table is designed to store the mapping logs from any location table.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
HZ_GEO_NAME_REFERENCE_LOG_PK |
GEO_NAME_REFERENCE_LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GEO_NAME_REFERENCE_LOG_ID | NUMBER | 18 | Yes | Unique geography name reference log identifier. | |
| LOCATION_ID | NUMBER | 18 | Yes | Location identifier from location table | |
| LOCATION_TABLE_NAME | VARCHAR2 | 30 | Yes | Location table name | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Concurrent Program who column - Identifies the concurrent program. FK to fnd_global.conc_program_name. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Concurrent Program who column - Identifies the Application name spawning the Concurrent Request. FK to fnd_global.prog_appl_name. | ||
| 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. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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. | ||
| MAP_STATUS | VARCHAR2 | 30 | Yes | Mapping status | |
| MESSAGE_TEXT | VARCHAR2 | 2000 | Encoded error message text | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| USAGE_CODE | VARCHAR2 | 30 | Yes | Code for address usage | |
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| LOC_EFFECTIVE_START_DATE | DATE | Date effectivity column | |||
| LOC_EFFECTIVE_END_DATE | DATE | Date effectivity column |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_GEO_NAME_REFERENCE_LOG_N1 | Non Unique | Default | LOCATION_ID, LOCATION_TABLE_NAME, USAGE_CODE |
| HZ_GEO_NAME_REFERENCE_LOG_PK | Unique | Default | GEO_NAME_REFERENCE_LOG_ID |