eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.HZ_MERGE_DICTIONARY

Object Details

Object Name:	HZ_MERGE_DICTIONARY
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_MERGE_DICTIONARY
Subobject Name:
Status:	VALID

The HZ_MERGE_DICTIONARY table stores information about the tables affected by a party merge. This table is used by the party merge concurrent program.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_MERGE_DICTIONARY_U1	NORMAL	UNIQUE	APPS_TS_SEED	MERGE_DICT_ID ZD_EDITION_NAME
HZ_MERGE_DICTIONARY_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ENTITY_NAME
HZ_MERGE_DICTIONARY_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_ENTITY_NAME
HZ_MERGE_DICTIONARY_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	DICT_APPLICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MERGE_DICT_ID	NUMBER	(15)	Yes	Sequence generated id to uniquely identify a record in the Dictionary
RULE_SET_NAME	VARCHAR2	(30)	Yes	Name of the Rule Set. This will be seeded name for Rel 1. Users cannot alter the rule set value or create a new one.
ENTITY_NAME	VARCHAR2	(30)	Yes	Name of the entity
PARENT_ENTITY_NAME	VARCHAR2	(30)		Name of the parent entity
PK_COLUMN_NAME	VARCHAR2	(30)	Yes	Name of the Primary Key Column for the entity
FK_COLUMN_NAME	VARCHAR2	(30)		Name of the Foreign Key Column which links the entity to the parent
DESC_COLUMN_NAME	VARCHAR2	(2000)		The name of the columns that will be used in generating a description for the record. Used in generating reports and logs. Eg: PARTY_NAME for HZ_PARTIESCould also be a complex concatenation or decode statement.
PROCEDURE_TYPE	VARCHAR2	(30)	Yes	Procedure Type. Values allowed : BC4J, PL/SQL
PROCEDURE_NAME	VARCHAR2	(60)	Yes	Name of the Merge Procedure
JOIN_CLAUSE	VARCHAR2	(2000)		Where Clause to related parent and child entity
DESCRIPTION	VARCHAR2	(2000)		Short descriptive name for the entity. EG: 'Party' for HZ_PARTIES
DICT_APPLICATION_ID	NUMBER	(15)		Dictionary application identifier
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).
SEQUENCE_NO	NUMBER			Sequence of the entity for merge.
BULK_FLAG	VARCHAR2	(1)		Indicates if the records in this table are being handled in bulk by the merge procedure. 'Y' for tables where merge is handled in bulk. 'N' for others.
FK_DATA_TYPE	VARCHAR2	(150)		Foreign key data type
BATCH_MERGE_FLAG	VARCHAR2	(1)		Indicates whether merge procedure should be executed only once for a batch
VALIDATE_PURGE_FLAG	VARCHAR2	(1)		Indicates whether purge validation should be skipped for an entity in the HZ Purge program.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MERGE_DICT_ID
,      RULE_SET_NAME
,      ENTITY_NAME
,      PARENT_ENTITY_NAME
,      PK_COLUMN_NAME
,      FK_COLUMN_NAME
,      DESC_COLUMN_NAME
,      PROCEDURE_TYPE
,      PROCEDURE_NAME
,      JOIN_CLAUSE
,      DESCRIPTION
,      DICT_APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SEQUENCE_NO
,      BULK_FLAG
,      FK_DATA_TYPE
,      BATCH_MERGE_FLAG
,      VALIDATE_PURGE_FLAG
,      ZD_EDITION_NAME
FROM AR.HZ_MERGE_DICTIONARY;

Dependencies

[top of page]

AR.HZ_MERGE_DICTIONARY does not reference any database object

AR.HZ_MERGE_DICTIONARY is referenced by following:

AR: HZ_MERGE_DICTIONARY#