[Home] [Help] [Dependency Information]
Object Name: | HZ_MERGE_PARTY_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_MERGE_PARTY_HISTORY |
Subobject Name: | |
Status: | VALID |
The HZ_MERGE_PARTY_HISTORY table stores information about the operations performed and the records affected by a party merge operation. Operations that could have been performed as a result of a merge could either be Merge or Transfer. For example, if a Party Site were transferred to the Merge-to Party, a record is created in this table.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_MERGE_PARTY_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | BATCH_PARTY_ID |
HZ_MERGE_PARTY_HISTORY_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | MERGE_DICT_ID |
HZ_MERGE_PARTY_HISTORY_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | FROM_ENTITY_ID |
HZ_MERGE_PARTY_HISTORY_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | TO_ENTITY_ID |
HZ_MERGE_PARTY_HISTORY_N5 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PARTY_ID | NUMBER | (15) | Yes | Id of the batch and party record |
REQUEST_ID | NUMBER | (15) | Yes | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
FROM_ENTITY_ID | NUMBER | Yes | Id of the entity record that is being merged | |
FROM_ENTITY_DESC | VARCHAR2 | (2000) | Description of the entity record that is being merged | |
TO_ENTITY_ID | NUMBER | Id of the entity record to which from entity record is being merged to | ||
TO_ENTITY_DESC | VARCHAR2 | (2000) | Description of the entity record to which from entity record is being merged to | |
FROM_PARENT_ENTITY_ID | NUMBER | ID of the From parent (if operation was transfer) | ||
TO_PARENT_ENTITY_ID | NUMBER | ID of the To parent (if operation was transfer) | ||
OPERATION_TYPE | VARCHAR2 | (30) | Type of Merge Operation. Values allowed are T - Transfer, M - Merge. Based on Lookup Type MERGE_OPERATION in AR_LOOKUPS. | |
MERGE_DICT_ID | NUMBER | (15) | ID of the Merge dictionary rule that caused this merge to be performed. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
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). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_PARTY_ID
, REQUEST_ID
, FROM_ENTITY_ID
, FROM_ENTITY_DESC
, TO_ENTITY_ID
, TO_ENTITY_DESC
, FROM_PARENT_ENTITY_ID
, TO_PARENT_ENTITY_ID
, OPERATION_TYPE
, MERGE_DICT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM AR.HZ_MERGE_PARTY_HISTORY;
AR.HZ_MERGE_PARTY_HISTORY does not reference any database object
AR.HZ_MERGE_PARTY_HISTORY is referenced by following:
|
|
|