[Home] [Help] [Dependency Information]
Object Name: | HZ_THIN_ST_CONTACTS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_THIN_ST_CONTACTS |
Subobject Name: | |
Status: | VALID |
The HZ_THIN_ST_CONTACTS table stores staged parties with ROWID of main staging table HZ_STAGED_CONTACTS. This is the narrow table for HZ_STAGED_CONTACTS for creating Oracle Text indexes. Since narrow table would use smaller number of data blocks, search operation will be faster.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_THIN_ST_CONTACTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PARTY_ID
QKEY ORG_CONTACT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | (15) | Party identifier | |
QKEY | VARCHAR2 | (255) | Concatenation of specific transformed values | |
ORG_CONTACT_ID | NUMBER | (15) | Yes | Organization contact identifier |
PARENT_ROWID | ROWID | (10) | Row identifier in HZ_STAGED_PARTY_SITES table | |
CONCAT_COL | VARCHAR2 | (1) | Virtual column for building index | |
STATUS_FLAG | VARCHAR2 | (1) | Status of staged record. A for active, I for inactive. | |
PERSON_PARTY_ID | NUMBER | (15) | Person Party Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, QKEY
, ORG_CONTACT_ID
, PARENT_ROWID
, CONCAT_COL
, STATUS_FLAG
, PERSON_PARTY_ID
FROM AR.HZ_THIN_ST_CONTACTS;
AR.HZ_THIN_ST_CONTACTS does not reference any database object
AR.HZ_THIN_ST_CONTACTS is referenced by following:
|
|
|