[Home] [Help] [Dependency Information]
Object Name: | HZ_MERGE_PARTIES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_MERGE_PARTIES |
Subobject Name: | |
Status: | VALID |
The HZ_MERGE_PARTIES table stores detail information about a party merge batch. This table stores a record for each pair of parties that is merged in a batch. The records in this table are created in the Merge Parties form.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_MERGE_PARTIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_PARTY_ID |
HZ_MERGE_PARTIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FROM_PARTY_ID |
HZ_MERGE_PARTIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TO_PARTY_ID |
HZ_MERGE_PARTIES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PARTY_ID | NUMBER | (15) | Yes | Sequence generated id to uniquely identify a batch and party. |
BATCH_ID | NUMBER | (15) | Yes | Id of the Batch |
MERGE_TYPE | VARCHAR2 | (30) | Yes | Specify whether its a Party or a Party Site Merge Values: PARTY_MERGE, PARTY_SITE_MERGE |
FROM_PARTY_ID | NUMBER | (15) | Yes | Id of the party that is being merged |
TO_PARTY_ID | NUMBER | (15) | Id of the party to which the from party is being merged to. In case of Party Site Merge, to party should be same as from party | |
MERGE_REASON_CODE | VARCHAR2 | (30) | Reason for Party merge. Based on Lookup type MERGE_REASON in AR_LOOKUPS | |
MERGE_STATUS | VARCHAR2 | (30) | Yes | This stores the status of the merge performed for this party. |
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
, BATCH_ID
, MERGE_TYPE
, FROM_PARTY_ID
, TO_PARTY_ID
, MERGE_REASON_CODE
, MERGE_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM AR.HZ_MERGE_PARTIES;
AR.HZ_MERGE_PARTIES does not reference any database object
AR.HZ_MERGE_PARTIES is referenced by following:
|
|
|