[Home] [Help] [Dependency Information]
Object Name: | HZ_MERGE_ENTITY_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_MERGE_ENTITY_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
The HZ_MERGE_ENTITY_ATTRIBUTES table stores attribute level merge information. You can use the information from this table to control what information is retained at an attribute level during party merge. For example, when you do a party merge of orgnanization profiles, you can specify that the Total Employees attribute data comes from one party and that the Current Year Revenue data comes from another party for the same merge.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_MERGE_ENTITY_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
MERGE_BATCH_ID
MERGE_TO_PARTY_ID ENTITY_NAME ATTRIBUTE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MERGE_BATCH_ID | NUMBER | (15) | Yes | Foreign Key to HZ_MERGE_BATCH |
MERGE_TO_PARTY_ID | NUMBER | (15) | Yes | Merge-to party ID |
ATTRIBUTE_NAME | VARCHAR2 | (30) | Yes | Entity column name |
ATTRIBUTE_VALUE | VARCHAR2 | (2000) | Entity column value | |
ATTRIBUTE_TYPE | VARCHAR2 | (1) | Data type of the column. D for DATE, V FOR VARCHAR2, or N for NUMBER. | |
ATTRIBUTE_PARTY_ID | NUMBER | (15) | Foreign Key to HZ_PARTIES. If NULL, the data is user-entered or updated, not from any party. | |
ENTITY_NAME | VARCHAR2 | (30) | Yes | Name of the entity. For example, HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
DERIVED_LAST_UPDATE_DATE | DATE | Last update date derived based on defaulting rule | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Version number for concurrency control purposes | |
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_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT MERGE_BATCH_ID
, MERGE_TO_PARTY_ID
, ATTRIBUTE_NAME
, ATTRIBUTE_VALUE
, ATTRIBUTE_TYPE
, ATTRIBUTE_PARTY_ID
, ENTITY_NAME
, DERIVED_LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM AR.HZ_MERGE_ENTITY_ATTRIBUTES;
AR.HZ_MERGE_ENTITY_ATTRIBUTES does not reference any database object
AR.HZ_MERGE_ENTITY_ATTRIBUTES is referenced by following:
|
|
|