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

TABLE: AP.AP_PARTY_CONTACTS_GT

Object Details
Object Name: AP_PARTY_CONTACTS_GT
Object Type: TABLE
Owner: AP
Subobject Name:
Status: VALID

Temporary Table Details

AP.AP_PARTY_CONTACTS_GT 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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
AP_PARTY_CONTACTS_GT_N1 NORMAL NONUNIQUE Tablespace ColumnVENDOR_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15)
VENDOR_ID NUMBER (15)
VENDOR_CONTACT_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
FIRST_NAME VARCHAR2 (15)
LAST_NAME VARCHAR2 (20)
MIDDLE_NAME VARCHAR2 (15)
PREFIX VARCHAR2 (5)
TITLE VARCHAR2 (30)
MAIL_STOP VARCHAR2 (35)
AREA_CODE VARCHAR2 (10)
PHONE VARCHAR2 (15)
CONTACT_NAME_ALT VARCHAR2 (320)
FIRST_NAME_ALT VARCHAR2 (230)
LAST_NAME_ALT VARCHAR2 (230)
DEPARTMENT VARCHAR2 (230)
EMAIL_ADDRESS VARCHAR2 (2000)
URL VARCHAR2 (2000)
ALT_AREA_CODE VARCHAR2 (10)
ALT_PHONE VARCHAR2 (15)
FAX_AREA_CODE VARCHAR2 (10)
FAX VARCHAR2 (15)
Query Text

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


SELECT PARTY_ID
,      VENDOR_ID
,      VENDOR_CONTACT_ID
,      VENDOR_SITE_ID
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      PREFIX
,      TITLE
,      MAIL_STOP
,      AREA_CODE
,      PHONE
,      CONTACT_NAME_ALT
,      FIRST_NAME_ALT
,      LAST_NAME_ALT
,      DEPARTMENT
,      EMAIL_ADDRESS
,      URL
,      ALT_AREA_CODE
,      ALT_PHONE
,      FAX_AREA_CODE
,      FAX
FROM AP.AP_PARTY_CONTACTS_GT;

Dependencies

[top of page]

AP.AP_PARTY_CONTACTS_GT does not reference any database object

AP.AP_PARTY_CONTACTS_GT is referenced by following:

SchemaAPPS
SynonymAP_PARTY_CONTACTS_GT