[Home] [Help] [Dependency Information]
Object Name: | HZ_DUP_SET_PARTIES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_DUP_SET_PARTIES |
Subobject Name: | |
Status: | VALID |
The HZ_DUP_SET_PARTIES table stores information that identifies all the parties that comprise a Duplicate Party Set. Only used by Data Quality Management. All parties that are duplicates, including merge-to and merge-from parties as well as their merge status, are stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_DUP_SET_PARTIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DUP_SET_ID
DUP_PARTY_ID |
HZ_DUP_SET_PARTIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DUP_PARTY_ID |
HZ_DUP_SET_PARTIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DUP_SET_BATCH_ID
DUP_PARTY_ID DUP_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUP_PARTY_ID | NUMBER | (15) | Yes | Foreign key to HZ_PARTIES table. |
DUP_SET_ID | NUMBER | (15) | Yes | Foreign key to HZ_DUP_SETS table. |
MERGE_SEQ_ID | NUMBER | (15) | Party merge batch sequence ID. | |
MERGE_BATCH_ID | NUMBER | (15) | Foreign key to HZ_MERGE_BATCH table. | |
SCORE | NUMBER | Yes | Score of the match. | |
MERGE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the party is the merge-to, or winning, party as identified in HZ_DUP_SETS. Y indicates the merge-to party. N indicates a merge-from party. | |
NOT_DUP | VARCHAR2 | (1) | Flag to indicate whether the current party is to be excluded from the set of duplicate parties. Y indicates that it should be excluded. N indicates that it should not be excluded. | |
MERGE_BATCH_NAME | VARCHAR2 | (30) | Party Merge Batch Name. | |
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). |
GROUP_SET | NUMBER | Group set value, for separating merge batches | ||
REMOVE_FLAG | VARCHAR2 | (1) | Indicates if party is nonduplicate. Y for yes, N or null for no. | |
DUP_SET_BATCH_ID | NUMBER | (15) | Unique duplicate identification batch identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DUP_PARTY_ID
, DUP_SET_ID
, MERGE_SEQ_ID
, MERGE_BATCH_ID
, SCORE
, MERGE_FLAG
, NOT_DUP
, MERGE_BATCH_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, GROUP_SET
, REMOVE_FLAG
, DUP_SET_BATCH_ID
FROM AR.HZ_DUP_SET_PARTIES;
AR.HZ_DUP_SET_PARTIES does not reference any database object
AR.HZ_DUP_SET_PARTIES is referenced by following:
|
|
|