eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTA_SYNC_CONTACTS_TEMP

Object Details

Object Name:	JTA_SYNC_CONTACTS_TEMP
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTA_SYNC_CONTACTS_TEMP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTA_SYNC_CONTACTS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYNCID
JTA_SYNC_CONTACTS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Resource Id
SYNC_ANCHOR	DATE		Yes	Sync Anchor (Date Time)
SYNCID	NUMBER		Yes	Sync Id
SYNC_EVENT	VARCHAR2	(20)		Sync Event
SEQ_NO	NUMBER			Sequence Number
SEQ_NO_EVENT	NUMBER			Sequence Nuber Event
CATEGORY	VARCHAR2	(255)		Category
LASTNAME	VARCHAR2	(255)		Last Name
FIRSTNAME	VARCHAR2	(255)		First Name
MIDDLENAME	VARCHAR2	(255)		Middle Name
COMPANYNAME	VARCHAR2	(255)		Company Name
JOBTITLE	VARCHAR2	(255)		Job Title
BUSINESSSTREET	VARCHAR2	(255)		Business Street
BUSINESSSTREET2	VARCHAR2	(255)		Business Street 2
BUSINESSSTREET3	VARCHAR2	(255)		Business Street 3
BUSINESSSTREET4	VARCHAR2	(255)		Business Street 4
BUSINESSCITY	VARCHAR2	(255)		Business City
BUSINESSSTATE	VARCHAR2	(255)		Business State
BUSINESSZIP	VARCHAR2	(255)		Business Zip
BUSINESSCOUNTRY	VARCHAR2	(255)		Business Country
HOMESTREET	VARCHAR2	(255)		Home Street
HOMESTREET2	VARCHAR2	(255)		Home Street 2
HOMESTREET3	VARCHAR2	(255)		Home Street 3
HOMESTREET4	VARCHAR2	(255)		Home Street 4
HOMECITY	VARCHAR2	(255)		Home City
HOMESTATE	VARCHAR2	(255)		Home State
HOMEZIP	VARCHAR2	(255)		Home Zip
HOMECOUNTRY	VARCHAR2	(255)		Home Country
EMAIL	VARCHAR2	(255)		Email
BUSINESSPHONE	VARCHAR2	(255)		Business Phone
HOMEPHONE	VARCHAR2	(255)		Home Phone
FAX	VARCHAR2	(255)		Fax
MOBILE	VARCHAR2	(255)		Mobile
PAGER	VARCHAR2	(255)		Pager
OTHERPHONE	VARCHAR2	(255)		Other Phone

Query Text

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


SELECT RESOURCE_ID
,      SYNC_ANCHOR
,      SYNCID
,      SYNC_EVENT
,      SEQ_NO
,      SEQ_NO_EVENT
,      CATEGORY
,      LASTNAME
,      FIRSTNAME
,      MIDDLENAME
,      COMPANYNAME
,      JOBTITLE
,      BUSINESSSTREET
,      BUSINESSSTREET2
,      BUSINESSSTREET3
,      BUSINESSSTREET4
,      BUSINESSCITY
,      BUSINESSSTATE
,      BUSINESSZIP
,      BUSINESSCOUNTRY
,      HOMESTREET
,      HOMESTREET2
,      HOMESTREET3
,      HOMESTREET4
,      HOMECITY
,      HOMESTATE
,      HOMEZIP
,      HOMECOUNTRY
,      EMAIL
,      BUSINESSPHONE
,      HOMEPHONE
,      FAX
,      MOBILE
,      PAGER
,      OTHERPHONE
FROM JTF.JTA_SYNC_CONTACTS_TEMP;

Dependencies

[top of page]

JTF.JTA_SYNC_CONTACTS_TEMP does not reference any database object

JTF.JTA_SYNC_CONTACTS_TEMP is referenced by following:

APPS: JTA_SYNC_CONTACTS_TEMP