[Home] [Help] [Dependency Information]
Object Name: | CAC_SYNC_CONTACT_TEMPS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
JTF.CAC_SYNC_CONTACT_TEMPS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CAC_SYNC_CONTACT_TEMPS_U1 | NORMAL | UNIQUE | SYNC_CONTACT_TEMP_ID | |
CAC_SYNC_CONTACT_TEMPS_N1 | NORMAL | NONUNIQUE | STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYNC_CONTACT_TEMP_ID | NUMBER | (15) | Yes | |
REL_CONTACT_PARTY_ID | NUMBER | (15) | Yes | |
ORG_PARTY_ID | NUMBER | (15) | Yes | |
ORG_NAME | VARCHAR2 | (255) | ||
PERSON_PARTY_ID | NUMBER | (15) | Yes | |
PERSON_FULL_NAME | VARCHAR2 | (255) | ||
PERSON_NAME_DELIMITED | VARCHAR2 | (255) | ||
JOB_TITLE | VARCHAR2 | (255) | ||
DEPARTMENT | VARCHAR2 | (255) | ||
ADDRESS_DELIMITED | VARCHAR2 | (255) | ||
WORK_PHONE_NUMBER | VARCHAR2 | (255) | ||
HOME_PHONE_NUMBER | VARCHAR2 | (255) | ||
WORK_FAX_NUMBER | VARCHAR2 | (255) | ||
CELL_NUMBER | VARCHAR2 | (255) | ||
PAGER_NUMBER | VARCHAR2 | (255) | ||
EMAIL_FORMAT | VARCHAR2 | (255) | ||
EMAIL_ADDRESS | VARCHAR2 | (255) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
WORK_PHONE_CONTACT_POINT_ID | NUMBER | (15) | ||
HOME_PHONE_CONTACT_POINT_ID | NUMBER | (15) | ||
WORK_FAX_CONTACT_POINT_ID | NUMBER | (15) | ||
CELL_PHONE_CONTACT_POINT_ID | NUMBER | (15) | ||
PAGER_CONTACT_POINT_ID | NUMBER | (15) | ||
EMAIL_CONTACT_POINT_ID | NUMBER | (15) | ||
STATUS | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT SYNC_CONTACT_TEMP_ID
, REL_CONTACT_PARTY_ID
, ORG_PARTY_ID
, ORG_NAME
, PERSON_PARTY_ID
, PERSON_FULL_NAME
, PERSON_NAME_DELIMITED
, JOB_TITLE
, DEPARTMENT
, ADDRESS_DELIMITED
, WORK_PHONE_NUMBER
, HOME_PHONE_NUMBER
, WORK_FAX_NUMBER
, CELL_NUMBER
, PAGER_NUMBER
, EMAIL_FORMAT
, EMAIL_ADDRESS
, PARTY_SITE_ID
, WORK_PHONE_CONTACT_POINT_ID
, HOME_PHONE_CONTACT_POINT_ID
, WORK_FAX_CONTACT_POINT_ID
, CELL_PHONE_CONTACT_POINT_ID
, PAGER_CONTACT_POINT_ID
, EMAIL_CONTACT_POINT_ID
, STATUS
FROM JTF.CAC_SYNC_CONTACT_TEMPS;
JTF.CAC_SYNC_CONTACT_TEMPS does not reference any database object
JTF.CAC_SYNC_CONTACT_TEMPS is referenced by following:
|
|
|