[Home] [Help] [Dependency Information]

TABLE: AR.HZ_DL_SELECTED_CRITERIA

Object Details

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

The HZ_DL_SELECTED_CRITERIA table stores the criteria
used to select parties to include in System Duplicate Identification (SDI)
batches or purge requests. SDI batches contain sets of system-identified
duplicates to merge. Each duplicate set within a batch can have either
multiple parties to merge together or just one party to cleanse duplicate
information for. A purge request is a batch of parties that you submit to
purge from the TCA Registry.
Each selection criterion contains an attribute, operation, and corresponding
attribute value. For example, a criterion can be that the Registry ID must be
less than 1001. Registry ID would be the attribute, less than is the
operation, and 1001 is the attribute value. A party must meet all criteria
specified for the SDI batch or purge request to be included.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_DL_SELECTED_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID BATCH_TYPE ATTRIBUTE_NAME OPERATION

Columns

Query Text

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

SELECT CRITERIA_ID
,      BATCH_TYPE
,      BATCH_ID
,      ATTRIBUTE_NAME
,      OPERATION
,      VALUE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
FROM AR.HZ_DL_SELECTED_CRITERIA;

Dependencies

[top of page]

AR.HZ_DL_SELECTED_CRITERIA does not reference any database object

AR.HZ_DL_SELECTED_CRITERIA is referenced by following:

AR

HZ_DL_SELECTED_CRITERIA#