[Home] [Help] [Dependency Information]
Object Name: | HZ_MERGE_PARTY_LOG |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_MERGE_PARTY_LOG |
Subobject Name: | |
Status: | VALID |
The HZ_MERGE_PARTY_LOG table stores information about the operations performed as a result of a party merge. The structure of this table is the same as the HZ_MERGE_PARTY_HISTORY table. The rows in this table are generated even if the merge is not completed or fails. If the Party Merge Concurrent program runs in the "Preview" Mode, rows are also created . If an error was encountered when merging one of the records, the error message is recorded in the ERROR_MESSAGES column for that merge. The entries in this table are created by the party merge concurrent program.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_MERGE_PARTY_LOG_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
REQUEST_ID
MERGE_DICT_ID OPERATION_TYPE FROM_ENTITY_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. | |
ERROR_MESSAGES | VARCHAR2 | (2000) | Error messages | |
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
, ERROR_MESSAGES
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM AR.HZ_MERGE_PARTY_LOG;
AR.HZ_MERGE_PARTY_LOG does not reference any database object
AR.HZ_MERGE_PARTY_LOG is referenced by following:
|
|
|