[Home] [Help] [Dependency Information]
Object Name: | HZ_MERGE_PARTYDTLS_SUGG |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_MERGE_PARTYDTLS_SUGG |
Subobject Name: | |
Status: | VALID |
The HZ_MERGE_PARTY_DETAILS_SUGG table stores suggested details for the operations performed on the records to be merged. The details include the name and the identifiers of the entity to be merged, as well as an indication whether the merge is mandatory or not.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_MERGE_PARTYDTLS_SUGG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_PARTY_ID |
HZ_MERGE_PARTYDTLS_SUGG_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MERGE_FROM_ENTITY_ID |
HZ_MERGE_PARTYDTLS_SUGG_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENTITY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_PARTY_ID | NUMBER | (15) | Yes | Unique sequence generated identifier for a batch and party |
ENTITY_NAME | VARCHAR2 | (30) | Yes | Party's detail entity name, such as Party Site, Contact, and Relationship |
MERGE_FROM_ENTITY_ID | NUMBER | (15) | Yes | Identifier of the detail entity record that is being merged |
MERGE_TO_ENTITY_ID | NUMBER | (15) | Identifier of the detail entity record that is being merged into | |
MANDATORY_MERGE | VARCHAR2 | (30) | Y or N indicates whether this merge is mandatory or not | |
CREATED_BY | NUMBER | 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 | 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 | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_PARTY_ID
, ENTITY_NAME
, MERGE_FROM_ENTITY_ID
, MERGE_TO_ENTITY_ID
, MANDATORY_MERGE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
FROM AR.HZ_MERGE_PARTYDTLS_SUGG;
AR.HZ_MERGE_PARTYDTLS_SUGG does not reference any database object
AR.HZ_MERGE_PARTYDTLS_SUGG is referenced by following:
|
|
|