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

TABLE: AR.HZ_PURGE_CANDIDATES

Object Details
Object Name: HZ_PURGE_CANDIDATES
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_PURGE_CANDIDATES
Subobject Name:
Status: VALID


The HZ_PURGE_CANDIDATES table stores the parties that have been identified for purge, along with denormalized information about the parties. The table also includes the status of the candidates for purge, as well as their identifying addresses and primary phone numbers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_PURGE_CANDIDATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
HZ_PURGE_CANDIDATES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_NAME
HZ_PURGE_CANDIDATES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCANDIDATE_PARTY_ID
ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Foreign key to HZ_PURGE_BATCH table
CANDIDATE_PARTY_ID NUMBER (15) Yes Foreign key to HZ_PARTIES table
PARTY_NAME VARCHAR2 (255) Yes Name of purged party
PARTY_NUMBER VARCHAR2 (100) Yes Registry ID of purged party
ADDRESSES VARCHAR2 (2000)
Concatenated identifying address for purged party
PHONE_NUMBERS VARCHAR2 (2000)
Primary phone number of purged party
COUNTRY VARCHAR2 (50)
Country of purged party
STATUS VARCHAR2 (30) Yes Purge candidate status. IDENTIFIED, MARKED, PURGED, or PURGE_ERROR
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).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT BATCH_ID
,      CANDIDATE_PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      ADDRESSES
,      PHONE_NUMBERS
,      COUNTRY
,      STATUS
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
FROM AR.HZ_PURGE_CANDIDATES;

Dependencies

[top of page]

AR.HZ_PURGE_CANDIDATES does not reference any database object

AR.HZ_PURGE_CANDIDATES is referenced by following:

SchemaAR
ViewHZ_PURGE_CANDIDATES#