[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_CUSTOMER_MERGE_LOG |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_CUSTOMER_MERGE_LOG
|
| Subobject Name: | |
| Status: | VALID |
The HZ_CUSTOMER_MERGE_LOG table stores information about the account merge audit history. During an account merge this table stores the old and new values of updated columns. Data in this table is for auditing purpose only.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_CUSTOMER_MERGE_LOG_N4 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
 REQUEST_ID
TABLE_NAME
PRIMARY_KEY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MERGE_LOG_ID | NUMBER | (15) | Yes | Merge Log ID used as primary key |
| MERGE_HEADER_ID | NUMBER | (15) | Foreign key to RA_CUSTOMER_MERGE_HEADERS table. | |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| TABLE_NAME | VARCHAR2 | (255) | Yes | Name of updated table. |
| PRIMARY_KEY_ID | NUMBER | (15) | Number primary key component of the record that was updated | |
| PRIMARY_KEY1 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| PRIMARY_KEY2 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| PRIMARY_KEY3 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| PRIMARY_KEY4 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| NUM_COL1_ORIG | NUMBER | Original value of the number column in the updated record | ||
| NUM_COL1_NEW | NUMBER | New value of the number column in the updated record | ||
| NUM_COL2_ORIG | NUMBER | Original value of the number column in the updated record | ||
| NUM_COL2_NEW | NUMBER | New value of the number column in the updated record | ||
| NUM_COL3_ORIG | NUMBER | Original value of the number column in the updated record | ||
| NUM_COL3_NEW | NUMBER | New value of the number column in the updated record | ||
| NUM_COL4_ORIG | NUMBER | Original value of the number column in the updated record | ||
| NUM_COL4_NEW | NUMBER | New value of the number column in the updated record | ||
| NUM_COL5_ORIG | NUMBER | Original value of the number column in the updated record | ||
| NUM_COL5_NEW | NUMBER | New value of the number column in the updated record | ||
| VCHAR_COL1_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record. | |
| VCHAR_COL1_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record. | |
| VCHAR_COL2_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record. | |
| VCHAR_COL2_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record. | |
| VCHAR_COL3_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record. | |
| VCHAR_COL3_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record. | |
| VCHAR_COL4_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record. | |
| VCHAR_COL4_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record. | |
| VCHAR_COL5_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record. | |
| VCHAR_COL5_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record. | |
| DATE_COL1_ORIG | DATE | Original value of the date column in the updated record. | ||
| DATE_COL1_NEW | DATE | New value of the date column in the updated record. | ||
| DATE_COL2_ORIG | DATE | Original value of the date column in the updated record. | ||
| DATE_COL2_NEW | DATE | New value of the date column in the updated record. | ||
| DATE_COL3_ORIG | DATE | Original value of the date column in the updated record. | ||
| DATE_COL3_NEW | DATE | New value of the date column in the updated record. | ||
| DATE_COL4_ORIG | DATE | Original value of the date column in the updated record. | ||
| DATE_COL4_NEW | DATE | New value of the date column in the updated record. | ||
| DATE_COL5_ORIG | DATE | Original value of the date column in the updated record. | ||
| DATE_COL5_NEW | DATE | New value of the date column in the updated record. | ||
| PRIMARY_KEY_ID1 | NUMBER | Number primary key component of the record that was updated. | ||
| PRIMARY_KEY_ID2 | NUMBER | Number primary key component of the record that was updated. | ||
| PRIMARY_KEY_ID3 | NUMBER | Number primary key component of the record that was updated. | ||
| PRIMARY_KEY5 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| PRIMARY_KEY6 | VARCHAR2 | (2000) | Varchar2 primary key component of the record that was updated. For tables with a multicolumn primary key. | |
| NUM_COL6_ORIG | VARCHAR2 | (2000) | Original value of the number column in the updated record. | |
| NUM_COL6_NEW | VARCHAR2 | (2000) | New value of the number column in the updated record. | |
| NUM_COL7_ORIG | VARCHAR2 | (2000) | Original value of the number column in the updated record. | |
| NUM_COL7_NEW | VARCHAR2 | (2000) | New value of the number column in the updated record. | |
| NUM_COL8_ORIG | VARCHAR2 | (2000) | Original value of the number column in the updated record. | |
| NUM_COL8_NEW | VARCHAR2 | (2000) | New value of the number column in the updated record. | |
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| ACTION_FLAG | VARCHAR2 | (1) | Indicates if the record was deleted or updated during account merge. D for deleted, U for updated | |
| DEL_COL1 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL2 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL3 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL4 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL5 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL6 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL7 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL8 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL9 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL10 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL11 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL12 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL13 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL14 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL15 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL16 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL17 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL18 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL19 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL20 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL21 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL22 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL23 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL24 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL25 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL26 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL27 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL28 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL29 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL30 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL31 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL32 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL33 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL34 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL35 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL36 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL37 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL38 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL39 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL40 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL41 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL42 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL43 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL44 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL45 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL46 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL47 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL48 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL49 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL50 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL51 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL52 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL53 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL54 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL55 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL56 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL57 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL58 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL59 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL60 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL61 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL62 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL63 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL64 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL65 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL66 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL67 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL68 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL69 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL70 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL71 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL72 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL73 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL74 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL75 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL76 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL77 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL78 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL79 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL80 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL81 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL82 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL83 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL84 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL85 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL86 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL87 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL88 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL89 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL90 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL91 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL92 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL93 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL94 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL95 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL96 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL97 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL98 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL99 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL100 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL101 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL102 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL103 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL104 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL105 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL106 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL107 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL108 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL109 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL110 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL111 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL112 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL113 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL114 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL115 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL116 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL117 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL118 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL119 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL120 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL121 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL122 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL123 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL124 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL125 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL126 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL127 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL128 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL129 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL130 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL131 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL132 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL133 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL134 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL135 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL136 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL137 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL138 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL139 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL140 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL141 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL142 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL143 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL144 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL145 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL146 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL147 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL148 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL149 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL150 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL151 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL152 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL153 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL154 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL155 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL156 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL157 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL158 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL159 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL160 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL161 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL162 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL163 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL164 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL165 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL166 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL167 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL168 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL169 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL170 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL171 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL172 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL173 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL174 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL175 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL176 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL177 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL178 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL179 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL180 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL181 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL182 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL183 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL184 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL185 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL186 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL187 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL188 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL189 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL190 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL191 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL192 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL193 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL194 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL195 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL196 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL197 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL198 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL199 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| DEL_COL200 | VARCHAR2 | (2000) | Stores data during account merge for a deleted record | |
| VCHAR_COL6_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL7_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL8_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL9_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL10_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL11_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL12_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL13_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL14_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL15_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL16_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL17_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL18_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL19_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL20_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL21_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL22_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL23_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL24_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL25_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL26_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL27_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL28_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL29_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL30_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL31_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL32_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL33_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL34_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL35_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL36_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL37_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL38_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL39_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL40_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL41_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL42_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL43_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL44_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL45_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL46_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL47_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL48_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL49_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL50_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL51_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL52_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL53_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL54_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL55_ORIG | VARCHAR2 | (2000) | Original value of the varchar2 column in the updated record | |
| VCHAR_COL6_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL7_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL8_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL9_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL10_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL11_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL12_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL13_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL14_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL15_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL16_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL17_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL18_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL19_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL20_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL21_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL22_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL23_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL24_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL25_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL26_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL27_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL28_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL29_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL30_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL31_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL32_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL33_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL34_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL35_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL36_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL37_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL38_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL39_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL40_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL41_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL42_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL43_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL44_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL45_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL46_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL47_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL48_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL49_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL50_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL51_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL52_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL53_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL54_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record | |
| VCHAR_COL55_NEW | VARCHAR2 | (2000) | New value of the varchar2 column in the updated record |
Cut, paste (and edit) the following text to query this object:
SELECT MERGE_LOG_ID
, MERGE_HEADER_ID
, REQUEST_ID
, TABLE_NAME
, PRIMARY_KEY_ID
, PRIMARY_KEY1
, PRIMARY_KEY2
, PRIMARY_KEY3
, PRIMARY_KEY4
, NUM_COL1_ORIG
, NUM_COL1_NEW
, NUM_COL2_ORIG
, NUM_COL2_NEW
, NUM_COL3_ORIG
, NUM_COL3_NEW
, NUM_COL4_ORIG
, NUM_COL4_NEW
, NUM_COL5_ORIG
, NUM_COL5_NEW
, VCHAR_COL1_ORIG
, VCHAR_COL1_NEW
, VCHAR_COL2_ORIG
, VCHAR_COL2_NEW
, VCHAR_COL3_ORIG
, VCHAR_COL3_NEW
, VCHAR_COL4_ORIG
, VCHAR_COL4_NEW
, VCHAR_COL5_ORIG
, VCHAR_COL5_NEW
, DATE_COL1_ORIG
, DATE_COL1_NEW
, DATE_COL2_ORIG
, DATE_COL2_NEW
, DATE_COL3_ORIG
, DATE_COL3_NEW
, DATE_COL4_ORIG
, DATE_COL4_NEW
, DATE_COL5_ORIG
, DATE_COL5_NEW
, PRIMARY_KEY_ID1
, PRIMARY_KEY_ID2
, PRIMARY_KEY_ID3
, PRIMARY_KEY5
, PRIMARY_KEY6
, NUM_COL6_ORIG
, NUM_COL6_NEW
, NUM_COL7_ORIG
, NUM_COL7_NEW
, NUM_COL8_ORIG
, NUM_COL8_NEW
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACTION_FLAG
, DEL_COL1
, DEL_COL2
, DEL_COL3
, DEL_COL4
, DEL_COL5
, DEL_COL6
, DEL_COL7
, DEL_COL8
, DEL_COL9
, DEL_COL10
, DEL_COL11
, DEL_COL12
, DEL_COL13
, DEL_COL14
, DEL_COL15
, DEL_COL16
, DEL_COL17
, DEL_COL18
, DEL_COL19
, DEL_COL20
, DEL_COL21
, DEL_COL22
, DEL_COL23
, DEL_COL24
, DEL_COL25
, DEL_COL26
, DEL_COL27
, DEL_COL28
, DEL_COL29
, DEL_COL30
, DEL_COL31
, DEL_COL32
, DEL_COL33
, DEL_COL34
, DEL_COL35
, DEL_COL36
, DEL_COL37
, DEL_COL38
, DEL_COL39
, DEL_COL40
, DEL_COL41
, DEL_COL42
, DEL_COL43
, DEL_COL44
, DEL_COL45
, DEL_COL46
, DEL_COL47
, DEL_COL48
, DEL_COL49
, DEL_COL50
, DEL_COL51
, DEL_COL52
, DEL_COL53
, DEL_COL54
, DEL_COL55
, DEL_COL56
, DEL_COL57
, DEL_COL58
, DEL_COL59
, DEL_COL60
, DEL_COL61
, DEL_COL62
, DEL_COL63
, DEL_COL64
, DEL_COL65
, DEL_COL66
, DEL_COL67
, DEL_COL68
, DEL_COL69
, DEL_COL70
, DEL_COL71
, DEL_COL72
, DEL_COL73
, DEL_COL74
, DEL_COL75
, DEL_COL76
, DEL_COL77
, DEL_COL78
, DEL_COL79
, DEL_COL80
, DEL_COL81
, DEL_COL82
, DEL_COL83
, DEL_COL84
, DEL_COL85
, DEL_COL86
, DEL_COL87
, DEL_COL88
, DEL_COL89
, DEL_COL90
, DEL_COL91
, DEL_COL92
, DEL_COL93
, DEL_COL94
, DEL_COL95
, DEL_COL96
, DEL_COL97
, DEL_COL98
, DEL_COL99
, DEL_COL100
, DEL_COL101
, DEL_COL102
, DEL_COL103
, DEL_COL104
, DEL_COL105
, DEL_COL106
, DEL_COL107
, DEL_COL108
, DEL_COL109
, DEL_COL110
, DEL_COL111
, DEL_COL112
, DEL_COL113
, DEL_COL114
, DEL_COL115
, DEL_COL116
, DEL_COL117
, DEL_COL118
, DEL_COL119
, DEL_COL120
, DEL_COL121
, DEL_COL122
, DEL_COL123
, DEL_COL124
, DEL_COL125
, DEL_COL126
, DEL_COL127
, DEL_COL128
, DEL_COL129
, DEL_COL130
, DEL_COL131
, DEL_COL132
, DEL_COL133
, DEL_COL134
, DEL_COL135
, DEL_COL136
, DEL_COL137
, DEL_COL138
, DEL_COL139
, DEL_COL140
, DEL_COL141
, DEL_COL142
, DEL_COL143
, DEL_COL144
, DEL_COL145
, DEL_COL146
, DEL_COL147
, DEL_COL148
, DEL_COL149
, DEL_COL150
, DEL_COL151
, DEL_COL152
, DEL_COL153
, DEL_COL154
, DEL_COL155
, DEL_COL156
, DEL_COL157
, DEL_COL158
, DEL_COL159
, DEL_COL160
, DEL_COL161
, DEL_COL162
, DEL_COL163
, DEL_COL164
, DEL_COL165
, DEL_COL166
, DEL_COL167
, DEL_COL168
, DEL_COL169
, DEL_COL170
, DEL_COL171
, DEL_COL172
, DEL_COL173
, DEL_COL174
, DEL_COL175
, DEL_COL176
, DEL_COL177
, DEL_COL178
, DEL_COL179
, DEL_COL180
, DEL_COL181
, DEL_COL182
, DEL_COL183
, DEL_COL184
, DEL_COL185
, DEL_COL186
, DEL_COL187
, DEL_COL188
, DEL_COL189
, DEL_COL190
, DEL_COL191
, DEL_COL192
, DEL_COL193
, DEL_COL194
, DEL_COL195
, DEL_COL196
, DEL_COL197
, DEL_COL198
, DEL_COL199
, DEL_COL200
, VCHAR_COL6_ORIG
, VCHAR_COL7_ORIG
, VCHAR_COL8_ORIG
, VCHAR_COL9_ORIG
, VCHAR_COL10_ORIG
, VCHAR_COL11_ORIG
, VCHAR_COL12_ORIG
, VCHAR_COL13_ORIG
, VCHAR_COL14_ORIG
, VCHAR_COL15_ORIG
, VCHAR_COL16_ORIG
, VCHAR_COL17_ORIG
, VCHAR_COL18_ORIG
, VCHAR_COL19_ORIG
, VCHAR_COL20_ORIG
, VCHAR_COL21_ORIG
, VCHAR_COL22_ORIG
, VCHAR_COL23_ORIG
, VCHAR_COL24_ORIG
, VCHAR_COL25_ORIG
, VCHAR_COL26_ORIG
, VCHAR_COL27_ORIG
, VCHAR_COL28_ORIG
, VCHAR_COL29_ORIG
, VCHAR_COL30_ORIG
, VCHAR_COL31_ORIG
, VCHAR_COL32_ORIG
, VCHAR_COL33_ORIG
, VCHAR_COL34_ORIG
, VCHAR_COL35_ORIG
, VCHAR_COL36_ORIG
, VCHAR_COL37_ORIG
, VCHAR_COL38_ORIG
, VCHAR_COL39_ORIG
, VCHAR_COL40_ORIG
, VCHAR_COL41_ORIG
, VCHAR_COL42_ORIG
, VCHAR_COL43_ORIG
, VCHAR_COL44_ORIG
, VCHAR_COL45_ORIG
, VCHAR_COL46_ORIG
, VCHAR_COL47_ORIG
, VCHAR_COL48_ORIG
, VCHAR_COL49_ORIG
, VCHAR_COL50_ORIG
, VCHAR_COL51_ORIG
, VCHAR_COL52_ORIG
, VCHAR_COL53_ORIG
, VCHAR_COL54_ORIG
, VCHAR_COL55_ORIG
, VCHAR_COL6_NEW
, VCHAR_COL7_NEW
, VCHAR_COL8_NEW
, VCHAR_COL9_NEW
, VCHAR_COL10_NEW
, VCHAR_COL11_NEW
, VCHAR_COL12_NEW
, VCHAR_COL13_NEW
, VCHAR_COL14_NEW
, VCHAR_COL15_NEW
, VCHAR_COL16_NEW
, VCHAR_COL17_NEW
, VCHAR_COL18_NEW
, VCHAR_COL19_NEW
, VCHAR_COL20_NEW
, VCHAR_COL21_NEW
, VCHAR_COL22_NEW
, VCHAR_COL23_NEW
, VCHAR_COL24_NEW
, VCHAR_COL25_NEW
, VCHAR_COL26_NEW
, VCHAR_COL27_NEW
, VCHAR_COL28_NEW
, VCHAR_COL29_NEW
, VCHAR_COL30_NEW
, VCHAR_COL31_NEW
, VCHAR_COL32_NEW
, VCHAR_COL33_NEW
, VCHAR_COL34_NEW
, VCHAR_COL35_NEW
, VCHAR_COL36_NEW
, VCHAR_COL37_NEW
, VCHAR_COL38_NEW
, VCHAR_COL39_NEW
, VCHAR_COL40_NEW
, VCHAR_COL41_NEW
, VCHAR_COL42_NEW
, VCHAR_COL43_NEW
, VCHAR_COL44_NEW
, VCHAR_COL45_NEW
, VCHAR_COL46_NEW
, VCHAR_COL47_NEW
, VCHAR_COL48_NEW
, VCHAR_COL49_NEW
, VCHAR_COL50_NEW
, VCHAR_COL51_NEW
, VCHAR_COL52_NEW
, VCHAR_COL53_NEW
, VCHAR_COL54_NEW
, VCHAR_COL55_NEW
FROM AR.HZ_CUSTOMER_MERGE_LOG;
AR.HZ_CUSTOMER_MERGE_LOG does not reference any database object
AR.HZ_CUSTOMER_MERGE_LOG is referenced by following:
AR
HZ_CUSTOMER_MERGE_LOG#
|
|
|
|